public ActionResult AddMaintenanceRecord(AddMaintenanceRecordModel model)
{
if (ModelState.IsValid)
{
var result = MaintenanceRecordBLL.AddMaintenanceRecord(model, base.CurrentUserID);
base.DoLog(OperationTypeEnum.Add, result, "VehicleName:" + model.VehicleName);
return(Json(result));
}
else
{
return(PartialView("_AddMaintenanceRecord", model));
}
}
public static OperationResult AddMaintenanceRecord(AddMaintenanceRecordModel model, int currentUserID)
{
List <SqlParameter> paras = new List <SqlParameter>()
{
new SqlParameter("@VehicleID", SqlDbType.BigInt),
new SqlParameter("@RecordDetails", SqlDbType.NVarChar),
new SqlParameter("@CreateUser", SqlDbType.Int),
new SqlParameter("@CreateTime", SqlDbType.DateTime),
};
paras[0].Value = model.VehicleID;
if (model.RecordDetails == null)
{
paras[1].Value = DBNull.Value;
}
else
{
paras[1].Value = model.RecordDetails;
}
paras[2].Value = currentUserID;
paras[3].Value = DateTime.Now;
string sql = @"INSERT INTO dbo.MaintenanceRecord
( [VehicleID]
,[RecordDetails]
,[CreateUser]
,[CreateTime] )
VALUES ( @VehicleID ,
@RecordDetails,
@CreateUser,
@CreateTime )";
bool result = MSSQLHelper.ExecuteNonQuery(CommandType.Text, sql, paras.ToArray()) > 0;
return(new OperationResult()
{
Success = result,
Message = result ? PromptInformation.OperationSuccess : PromptInformation.DBError
});
}
public ActionResult AddMaintenanceRecord()
{
AddMaintenanceRecordModel model = new AddMaintenanceRecordModel();
return(PartialView("_AddMaintenanceRecord", model));
}
