public MDModel GetModelBymodel_code(string model_code)
{
MDModel oMDModel = new MDModel();
DataTable dTable = new DataTable();
SqlCommand sql = new SqlCommand();
sql.CommandText = "SELECT model_id,model_code,model_name,model_type,model_updateby,model_updatedate FROM model";
sql.CommandText += " WHERE model_code=@model_code";
sql.Parameters.Add(new SqlParameter("@model_code", model_code));
dTable = oConn.Query(sql);
if (dTable.Rows.Count > 0)
{
foreach (DataRow row in dTable.Rows)
{
MDModel.CMDModel oMD = new MDModel.CMDModel();
oMD.model_id = row["model_id"].ToString();
oMD.model_code = row["model_code"].ToString();
oMD.model_name = row["model_name"].ToString();
oMD.model_type = row["model_type"].ToString();
oMD.model_updateby = row["model_updateby"].ToString();
oMD.model_updatedate = row["model_updatedate"].ToString();
oMDModel.ListOfModel.Add(oMD);
}
}
return(oMDModel);
}
public MDModel GetModel(string inSearch)
{
inSearch = "%" + inSearch + "%";
MDModel oMDModel = new MDModel();
DataTable dTable = new DataTable();
SqlCommand sql = new SqlCommand();
sql.CommandText = "SELECT model_id,model_code,model_name,model_type,model_updateby,model_updatedate FROM model";
sql.CommandText += " WHERE ISNULL(model_code,'')+ISNULL(model_name,'')+ISNULL(model_type,'') like @inSearch";
sql.Parameters.Add(new SqlParameter("@inSearch", inSearch));
dTable = oConn.Query(sql);
if (dTable.Rows.Count > 0)
{
foreach (DataRow row in dTable.Rows)
{
MDModel.CMDModel oMD = new MDModel.CMDModel();
oMD.model_id = row["model_id"].ToString();
oMD.model_code = row["model_code"].ToString();
oMD.model_name = row["model_name"].ToString();
oMD.model_type = row["model_type"].ToString();
oMD.model_updateby = row["model_updateby"].ToString();
oMD.model_updatedate = row["model_updatedate"].ToString();
oMDModel.ListOfModel.Add(oMD);
}
}
return(oMDModel);
}
