///
/// insert
///
public static Insert_
(
)
{
using (SqlConnection conn = new SqlConnection(DNS.QnxCommunityDNS))
{
SqlCommand cmd = new SqlCommand("_Insert_p", conn);
cmd.CommandType = CommandType.StoredProcedure;
conn.Open();
try
{
cmd.ExecuteNonQuery();
result = .Parse(cmd.Parameters["@"].Value.ToString());
return result;
int returnValue = cmd.ExecuteNonQuery();
if (returnValue > 0)
return true;
return false;
}
catch (Exception ex)
{
//To do...
throw ex;
}
}
}
///
/// delete
///
public static bool Delete_
(
)
{
using (SqlConnection conn = new SqlConnection(DNS.QnxCommunityDNS))
{
SqlCommand cmd = new SqlCommand("_Delete_p", conn);
cmd.CommandType = CommandType.StoredProcedure;
conn.Open();
try
{
int rowCount = cmd.ExecuteNonQuery();
if (rowCount > 0)
return true;
return false;
}
catch (Exception ex)
{
//To do...
throw ex;
}
}
}
///
/// update
///
public static bool Update_
(
)
{
using (SqlConnection conn = new SqlConnection(DNS.QnxCommunityDNS))
{
SqlCommand cmd = new SqlCommand("_Update_p", conn);
cmd.CommandType = CommandType.StoredProcedure;
conn.Open();
try
{
int rowCount = cmd.ExecuteNonQuery();
if (rowCount > 0)
return true;
return false;
}
catch (Exception ex)
{
//To do...
throw ex;
}
}
}
///
/// get
///
public static Model Load_
(
)
{
using (SqlConnection conn = new SqlConnection(DNS.QnxCommunityDNS))
{
SqlCommand cmd = new SqlCommand("_Load_p", conn);
cmd.CommandType = CommandType.StoredProcedure;
conn.Open();
try
{
SqlDataAdapter dp = new SqlDataAdapter(cmd);
DataTable dt = new DataTable();
dp.Fill(dt);
Model model = DataSetParser.ToModel<Model>(dt);
return model;
}
catch (Exception ex)
{
//To do...
throw ex;
}
}
}
///
/// getlist
///
public static List<Model> GetList_
(
int pageIndex,
int pageSize,
)
{
using (SqlConnection conn = new SqlConnection(DNS.QnxCommunityDNS))
{
SqlCommand cmd = new SqlCommand("_GetList_p", conn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@PageIndex", pageIndex);
cmd.Parameters.AddWithValue("@PageSize", pageSize);
conn.Open();
try
{
SqlDataAdapter dp = new SqlDataAdapter(cmd);
DataTable dt = new DataTable();
dp.Fill(dt);
List<Model> list = DataSetParser.ToModels<Model>(dt);
return list;
}
catch (Exception ex) {
//To do...
throw ex;
}
}
}
///
/// getlistcount
///
public static int GetListCount_
(
)
{
using (SqlConnection conn = new SqlConnection(DNS.QnxCommunityDNS))
{
SqlCommand cmd = new SqlCommand("_GetListCount_p", conn);
cmd.CommandType = CommandType.StoredProcedure;
conn.Open();
try
{
object obj = cmd.ExecuteScalar();
if(obj is int)
return (int)obj;
return 0;
}
catch (Exception ex)
{
//To do...
throw ex;
}
}
}
///
/// getalllist
///
public static List<Model> GetAllList_
(
)
{
using (SqlConnection conn = new SqlConnection(DNS.QnxCommunityDNS))
{
SqlCommand cmd = new SqlCommand("_GetAllList_p", conn);
cmd.CommandType = CommandType.StoredProcedure;
conn.Open();
try
{
SqlDataAdapter dp = new SqlDataAdapter(cmd);
DataTable dt = new DataTable();
dp.Fill(dt);
List<Model> list = DataSetParser.ToModels<Model>(dt);
return list;
}
catch (Exception ex)
{
//To do...
throw ex;
}
}
}
///
/// getlist
///
public static List<Model> GetListAndCount_
(
int pageIndex,
int pageSize,
out int totalRec,
)
{
using (SqlConnection conn = new SqlConnection(DNS.QnxCommunityDNS))
{
SqlCommand cmd = new SqlCommand("_GetListAndCount_p", conn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@PageIndex", pageIndex);
cmd.Parameters.AddWithValue("@PageSize", pageSize);
cmd.Parameters.AddWithValue("@TotalRec", SqlDbType.Int);
cmd.Parameters["@TotalRec"].Direction = ParameterDirection.Output;
conn.Open();
try
{
SqlDataAdapter dp = new SqlDataAdapter(cmd);
DataTable dt = new DataTable();
dp.Fill(dt);
totalRec = Convert.ToInt32(cmd.Parameters["@TotalRec"].Value);
List<Model> list = DataSetParser.ToModels<Model>(dt);
return list;
}
catch (Exception ex) {
//To do...
throw ex;
}
}
}