public DayPlanItemGroup GetGroup_DRToModel(DataRow dr) { DayPlanItemGroup model = new DayPlanItemGroup(); if (dr != null) { model.ID = ObjectConvertClass.static_ext_int(dr["nID"]); model.Name = ObjectConvertClass.static_ext_string(dr["strName"]); model.ExcelSide = ObjectConvertClass.static_ext_int(dr["nExcelSide"]); model.ExcelPos = ObjectConvertClass.static_ext_int(dr["nExcelPos"]); model.DayPlanID = ObjectConvertClass.static_ext_string(dr["nDayPlanID"]); model.IsDaWen = ObjectConvertClass.static_ext_int(dr["bIsDawen"]); } return(model); }
public int Add(DayPlanItemGroup model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into Tab_Base_DayPlan_Group"); strSql.Append("(strName,nExcelSide,nExcelPos,nDayPlanID,bIsDawen)"); strSql.Append("values(@strName,@nExcelSide,@nExcelPos,@nDayPlanID,@bIsDawen)"); strSql.Append(";select @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@strName", model.Name), new SqlParameter("@nExcelSide", model.ExcelSide), new SqlParameter("@nExcelPos", model.ExcelPos), new SqlParameter("@nDayPlanID", model.DayPlanID), new SqlParameter("@bIsDawen", model.IsDaWen) }; return(SqlHelper.ExecuteNonQuery(SqlHelper.ConnString, CommandType.Text, strSql.ToString(), parameters)); }
public int Update(DayPlanItemGroup model) { StringBuilder strSql = new StringBuilder(); strSql.Append("Update Tab_Base_DayPlan_Group set "); strSql.Append(" strName = @strName, "); strSql.Append(" nExcelSide = @nExcelSide, "); strSql.Append(" nExcelPos = @nExcelPos, "); strSql.Append(" nDayPlanID = @nDayPlanID, "); strSql.Append(" bIsDawen = @bIsDawen "); strSql.Append(" where nID = @nID "); SqlParameter[] parameters = { new SqlParameter("@strName", model.Name), new SqlParameter("@nID", model.ID), new SqlParameter("@nExcelSide", model.ExcelSide), new SqlParameter("@nExcelPos", model.ExcelPos), new SqlParameter("@nDayPlanID", model.DayPlanID), new SqlParameter("@bIsDawen", model.IsDaWen) }; return(SqlHelper.ExecuteNonQuery(SqlHelper.ConnString, CommandType.Text, strSql.ToString(), parameters)); }