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