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