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