public ActionResult AddMaintenanceSchedule(AddMaintenanceScheduleModel model) { if (ModelState.IsValid) { var result = MaintenanceScheduleBLL.AddMaintenanceSchedule(model, base.CurrentUserID); base.DoLog(OperationTypeEnum.Add, result, "ScheduleName:" + model.ScheduleName); return(Json(result)); } else { return(PartialView("_AddMaintenanceSchedule", model)); } }
public static OperationResult AddMaintenanceSchedule(AddMaintenanceScheduleModel model, int currentUserID) { int len = model.MaintenanceProjectDetails.Count + 1; //数据表中添加数据=保养方案表一条数据+保养内容表的Count条数据 string[] sqls = new string[len]; SqlParameter[][] paras = new SqlParameter[len][]; int num = 1; #region 保养方案表添加 sqls[0] = @"INSERT INTO dbo.MaintenanceSchedule ( ScheduleName ,RulesType ,SettingMile ,PreMile ,SettingDay ,PreDay ,Remark ,CreateUser ,CreateTime ) VALUES ( @ScheduleName , @RulesType, @SettingMile , @PreMile , @SettingDay, @PreDay , @Remark, @CreateUser, @CreateTime );SELECT SCOPE_IDENTITY();"; paras[0] = new SqlParameter[9]; paras[0][0] = new SqlParameter() { ParameterName = "@ScheduleName", SqlDbType = SqlDbType.NVarChar, Value = model.ScheduleName.Trim() }; paras[0][1] = new SqlParameter() { ParameterName = "@RulesType", SqlDbType = SqlDbType.Int, Value = model.RulesType }; if (model.SettingMile == null) { paras[0][2] = new SqlParameter() { ParameterName = "@SettingMile", SqlDbType = SqlDbType.Int, Value = DBNull.Value }; } else { paras[0][2] = new SqlParameter() { ParameterName = "@SettingMile", SqlDbType = SqlDbType.Int, Value = model.SettingMile }; } if (model.PreMile == null) { paras[0][3] = new SqlParameter() { ParameterName = "@PreMile", SqlDbType = SqlDbType.Int, Value = DBNull.Value }; } else { paras[0][3] = new SqlParameter() { ParameterName = "@PreMile", SqlDbType = SqlDbType.Int, Value = model.PreMile }; } if (model.SettingDay == null) { paras[0][4] = new SqlParameter() { ParameterName = "@SettingDay", SqlDbType = SqlDbType.Int, Value = DBNull.Value }; } else { paras[0][4] = new SqlParameter() { ParameterName = "@SettingDay", SqlDbType = SqlDbType.Int, Value = model.SettingDay }; } if (model.PreDay == null) { paras[0][5] = new SqlParameter() { ParameterName = "@PreDay", SqlDbType = SqlDbType.Int, Value = DBNull.Value }; } else { paras[0][5] = new SqlParameter() { ParameterName = "@PreDay", SqlDbType = SqlDbType.Int, Value = model.PreDay }; } if (string.IsNullOrEmpty(model.Remark)) { paras[0][6] = new SqlParameter() { ParameterName = "@Remark", SqlDbType = SqlDbType.NVarChar, Value = DBNull.Value }; } else { paras[0][6] = new SqlParameter() { ParameterName = "@Remark", SqlDbType = SqlDbType.NVarChar, Value = model.Remark }; } paras[0][7] = new SqlParameter() { ParameterName = "@CreateUser", SqlDbType = SqlDbType.Int, Value = currentUserID }; paras[0][8] = new SqlParameter() { ParameterName = "@CreateTime", SqlDbType = SqlDbType.DateTime, Value = DateTime.Now }; #endregion #region 保养内容表添加 for (int i = 0; i < model.MaintenanceProjectDetails.Count; i++) { string tempSql = string.Empty; tempSql = @" INSERT INTO dbo.MaintenanceProject( ScheduleID , ProjectName , PartsName , PartsBrand , PartsVersion , Num , Unit , UnitPrice , CreateUser , CreateTime ) VALUES ( @ScheduleID,@ProjectName,@PartsName,@PartsBrand,@PartsVersion,@Num,@Unit,@UnitPrice,@CreateUser1,@CreateTime1)"; sqls[num] = tempSql; paras[num] = new SqlParameter[10]; //@ScheduleID用的上一条数据自增列ID,此处参数只能放在[num][0]的位置,放在[num][1]无效 paras[num][0] = new SqlParameter { ParameterName = "@ScheduleID", SqlDbType = SqlDbType.Int }; paras[num][1] = new SqlParameter() { ParameterName = "@ProjectName", SqlDbType = SqlDbType.NVarChar, Value = model.MaintenanceProjectDetails[i].ProjectName.Trim() }; if (string.IsNullOrEmpty(model.MaintenanceProjectDetails[i].PartsName)) { paras[num][2] = new SqlParameter() { ParameterName = "@PartsName", SqlDbType = SqlDbType.NVarChar, Value = DBNull.Value }; } else { paras[num][2] = new SqlParameter() { ParameterName = "@PartsName", SqlDbType = SqlDbType.NVarChar, Value = model.MaintenanceProjectDetails[i].PartsName.Trim() }; } if (string.IsNullOrEmpty(model.MaintenanceProjectDetails[i].PartsBrand)) { paras[num][3] = new SqlParameter() { ParameterName = "@PartsBrand", SqlDbType = SqlDbType.NVarChar, Value = DBNull.Value }; } else { paras[num][3] = new SqlParameter() { ParameterName = "@PartsBrand", SqlDbType = SqlDbType.NVarChar, Value = model.MaintenanceProjectDetails[i].PartsBrand.Trim() }; } if (string.IsNullOrEmpty(model.MaintenanceProjectDetails[i].PartsVersion)) { paras[num][4] = new SqlParameter() { ParameterName = "@PartsVersion", SqlDbType = SqlDbType.NVarChar, Value = DBNull.Value }; } else { paras[num][4] = new SqlParameter() { ParameterName = "@PartsVersion", SqlDbType = SqlDbType.NVarChar, Value = model.MaintenanceProjectDetails[i].PartsVersion.Trim() }; } if (model.MaintenanceProjectDetails[i].Num == null) { paras[num][5] = new SqlParameter() { ParameterName = "@Num", SqlDbType = SqlDbType.Int, Value = DBNull.Value }; } else { paras[num][5] = new SqlParameter() { ParameterName = "@Num", SqlDbType = SqlDbType.Int, Value = model.MaintenanceProjectDetails[i].Num }; } if (string.IsNullOrEmpty(model.MaintenanceProjectDetails[i].Unit)) { paras[num][6] = new SqlParameter() { ParameterName = "@Unit", SqlDbType = SqlDbType.NVarChar, Value = DBNull.Value }; } else { paras[num][6] = new SqlParameter() { ParameterName = "@Unit", SqlDbType = SqlDbType.NVarChar, Value = model.MaintenanceProjectDetails[i].Unit.Trim() }; } if (model.MaintenanceProjectDetails[i].UnitPrice == null) { paras[num][7] = new SqlParameter() { ParameterName = "@UnitPrice", SqlDbType = SqlDbType.Int, Value = DBNull.Value }; } else { paras[num][7] = new SqlParameter() { ParameterName = "@UnitPrice", SqlDbType = SqlDbType.Int, Value = model.MaintenanceProjectDetails[i].UnitPrice }; } paras[num][8] = new SqlParameter() { ParameterName = "@CreateUser1", SqlDbType = SqlDbType.Int, Value = currentUserID }; paras[num][9] = new SqlParameter() { ParameterName = "@CreateTime1", SqlDbType = SqlDbType.DateTime, Value = DateTime.Now }; num++; } #endregion bool result = MSSQLHelper.ExecuteIdentityIncludeTransaction(CommandType.Text, sqls, paras) != 0; return(new OperationResult() { Success = result, Message = result ? PromptInformation.OperationSuccess : PromptInformation.DBError }); }
public ActionResult AddMaintenanceSchedule() { AddMaintenanceScheduleModel model = new AddMaintenanceScheduleModel(); return(PartialView("_AddMaintenanceSchedule", model)); }