public Model.Sys_Colliery DataRowToModel(System.Data.DataRow row)
{
TDTK.PlatForm.MVC4.Model.Sys_Colliery model = new TDTK.PlatForm.MVC4.Model.Sys_Colliery();
if (row != null)
{
if (row["CollCode"] != null)
{
model.CollCode = row["CollCode"].ToString();
}
if (row["CollName"] != null)
{
model.CollName = row["CollName"].ToString();
}
if (row["OrgCode"] != null)
{
model.OrgCode = row["OrgCode"].ToString();
}
if (row["VillageCode"] != null)
{
model.VillageCode = row["VillageCode"].ToString();
}
if (row["MineOwner"] != null)
{
model.MineOwner = row["MineOwner"].ToString();
}
if (row["MinePhone"] != null)
{
model.MinePhone = row["MinePhone"].ToString();
}
if (row["YearOutput"] != null && row["YearOutput"].ToString() != "")
{
model.YearOutput = decimal.Parse(row["YearOutput"].ToString());
}
if (row["CollState"] != null)
{
model.CollState = row["CollState"].ToString();
}
if (row["ImageLicence"] != null)
{
model.ImageLicence = row["ImageLicence"].ToString();
}
if (row["ImageRevenue"] != null)
{
model.ImageRevenue = row["ImageRevenue"].ToString();
}
if (row["ImageCompetency"] != null)
{
model.ImageCompetency = row["ImageCompetency"].ToString();
}
if (row["Remark"] != null)
{
model.Remark = row["Remark"].ToString();
}
if (row["IsForbid"] != null)
{
model.IsForbid = row["IsForbid"].ToString();
}
if (row["CollProperty"] != null)
{
model.CollProperty = row["CollProperty"].ToString();
}
if (row["ParcelCode"] != null)
{
model.ParcelCode = row["ParcelCode"].ToString();
}
}
return model;
}
public Model.Sys_Colliery GetModel(Model.Sys_Colliery t)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 CollCode,CollName,OrgCode,VillageCode,MineOwner,MinePhone,YearOutput,CollState,ImageLicence,ImageRevenue,ImageCompetency,Remark,IsForbid,CollProperty,ParcelCode from Sys_Colliery ");
strSql.Append(" where CollCode=@CollCode ");
SqlParameter[] parameters = {
new SqlParameter("@CollCode", SqlDbType.VarChar,10) };
parameters[0].Value = t.CollCode;
TDTK.PlatForm.MVC4.Model.Sys_Colliery model = new TDTK.PlatForm.MVC4.Model.Sys_Colliery();
DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return DataRowToModel(ds.Tables[0].Rows[0]);
}
else
{
return null;
}
}
