public Model.SYS_Position DataRowToModel(System.Data.DataRow row) { TDTK.PlatForm.MVC4.Model.SYS_Position model = new TDTK.PlatForm.MVC4.Model.SYS_Position(); if (row != null) { if (row["PositionCode"] != null) { model.PositionCode = row["PositionCode"].ToString(); } if (row["PositionName"] != null) { model.PositionName = row["PositionName"].ToString(); } if (row["Remark"] != null) { model.Remark = row["Remark"].ToString(); } if (row["IsForbid"] != null) { model.IsForbid = row["IsForbid"].ToString(); } } return model; }
public Model.SYS_Position GetModel(Model.SYS_Position t) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 PositionCode,PositionName,Remark,IsForbid from SYS_Position "); strSql.Append(" where PositionCode=@PositionCode "); SqlParameter[] parameters = { new SqlParameter("@PositionCode", SqlDbType.VarChar,10) }; parameters[0].Value = t.PositionCode; TDTK.PlatForm.MVC4.Model.SYS_Position model = new TDTK.PlatForm.MVC4.Model.SYS_Position(); DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { return DataRowToModel(ds.Tables[0].Rows[0]); } else { return null; } }