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; } }