public static SelectResult <VehicleTypeEditModel> GetVehicleTypeID(int id)
{
List <SqlParameter> paras = new List <SqlParameter>()
{
new SqlParameter("@Code", SqlDbType.TinyInt),
};
paras[0].Value = id;
string sql = @"SELECT Code ,Name ,CAST(ParentCode AS nvarchar(10))as ParentCode
FROM dbo.VehicleTypes
WHERE Code=@Code";
List <VehicleTypeEditModel> list = ConvertToList <VehicleTypeEditModel> .Convert(MSSQLHelper.ExecuteDataTable(CommandType.Text, sql, paras.ToArray()));
VehicleTypeEditModel data = null;
string msg = string.Empty;
if (list == null)
{
msg = PromptInformation.DBError;
}
else if (list.Count == 0)
{
msg = PromptInformation.NotExists;
}
else
{
data = list[0];
}
return(new SelectResult <VehicleTypeEditModel>()
{
DataResult = data,
Message = msg
});
}
public ActionResult EditVehicleTypes(VehicleTypeEditModel model)
{
if (ModelState.IsValid)
{
var result = VehicleMaintainBLL.EditVehicleType(model, base.UserIDForLog);
base.DoLog(OperationTypeEnum.Edit, result, "Code:" + model.Code);
return(Json(result));
}
else
{
return(PartialView("_EditVehicleTypes", model));
}
}
public static OperationResult EditVehicleType(VehicleTypeEditModel model, int EditUserID)
{
List <SqlParameter> paras = new List <SqlParameter>()
{
new SqlParameter("@Code", SqlDbType.TinyInt),
new SqlParameter("@Name", SqlDbType.VarChar, 13),
new SqlParameter("@ID", SqlDbType.TinyInt),
new SqlParameter("@EditTime", SqlDbType.DateTime),
new SqlParameter("@EditUserID", SqlDbType.Int)
};
paras[0].Value = model.Code;
paras[1].Value = model.Name.Trim();
paras[2].Value = model.ID;
paras[3].Value = DateTime.Now;
paras[4].Value = EditUserID;
#region SQL
string sql;
#endregion
if (!string.IsNullOrWhiteSpace(model.ParentCode))
{
paras.Add(new SqlParameter("@ParentCode", SqlDbType.TinyInt));
paras[3].Value = model.ParentCode;
sql = @"UPDATE dbo.VehicleTypes
SET Code = @ID ,Name=@Name,
ParentCode = @ParentCode,EditUserID=@EditUserID,EditTime=@EditTime
WHERE Code = @ID";
}
else
{
sql = @"UPDATE dbo.VehicleTypes
SET Code = @ID ,Name=@Name,EditUserID=@EditUserID,EditTime=@EditTime
WHERE Code = @ID";
}
int result = MSSQLHelper.ExecuteNonQuery(CommandType.Text, sql, paras.ToArray());
string msg = string.Empty;
switch (result)
{
case 1:
msg = PromptInformation.OperationSuccess;
break;
case 0:
msg = PromptInformation.NotExists;
break;
case -1:
msg = PromptInformation.DBError;
break;
}
return(new OperationResult()
{
Success = result > 0,
Message = msg
});
}
