public ActionResult AddVehicleTypes(VehicleTypeAddModel model)
{
if (ModelState.IsValid)
{
var result = VehicleMaintainBLL.AddVehicleType(model, base.UserIDForLog);
base.DoLog(OperationTypeEnum.Add, result, "VehicleTCode:" + model.Code);
return(Json(result));
}
else
{
return(PartialView("_AddVehicleTypeGrid", model));
}
}
public static OperationResult AddVehicleType(VehicleTypeAddModel model, int CreateUserID)
{
List <SqlParameter> paras = new List <SqlParameter>()
{
new SqlParameter("@Code", SqlDbType.TinyInt),
new SqlParameter("@Name", SqlDbType.NVarChar, 30),
new SqlParameter("@CreateUserID", SqlDbType.Int)
};
paras[0].Value = model.Code;
paras[1].Value = model.Name.Trim();
paras[2].Value = CreateUserID;
#region SQL
string sql;
#endregion
if (!string.IsNullOrWhiteSpace(model.HigheNumber.ToString()))
{
paras.Add(new SqlParameter("@Number", SqlDbType.TinyInt));
paras[3].Value = model.HigheNumber;
sql = @"INSERT INTO dbo.VehicleTypes
(Code,Name,ParentCode,CreateUserID) VALUES (@Code,@Name,@Number,@CreateUserID)";
}
else
{
sql = @"INSERT INTO dbo.VehicleTypes
(Code,Name,CreateUserID) VALUES (@Code,@Name,@CreateUserID)";
}
bool result = MSSQLHelper.ExecuteNonQuery(CommandType.Text, sql, paras.ToArray()) > 0;
return(new OperationResult()
{
Success = result,
Message = result ? PromptInformation.OperationSuccess : PromptInformation.DBError
});
}
