public static OperationResult EditTerminalManufacturer(TerminalManufacturerEditModel model, int EditUserID) { List <SqlParameter> paras = new List <SqlParameter>() { new SqlParameter("@ManufacturerName", SqlDbType.NVarChar, 200), new SqlParameter("@ManufacturerCode", SqlDbType.Char, 5), new SqlParameter("@Nationality", SqlDbType.Char, 6), new SqlParameter("@ID", SqlDbType.Int), new SqlParameter("@EditUserID", SqlDbType.Int), new SqlParameter("@EditTime", SqlDbType.DateTime) }; paras[0].Value = model.ManufacturerName.Trim(); paras[1].Value = model.ManufacturerCode.Trim(); paras[2].Value = model.Nationality.Trim(); paras[3].Value = model.ID; paras[4].Value = EditUserID; paras[5].Value = DateTime.Now; #region SQL string sql = @"UPDATE dbo.TerminalManufacturer SET ManufacturerName = @ManufacturerName , ManufacturerCode = @ManufacturerCode , Nationality = @Nationality, EditUserID=@EditUserID, EditTime=@EditTime WHERE ID = @ID"; #endregion 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 }); }
public ActionResult EditTerminalManufacturer(TerminalManufacturerEditModel model) { if (ModelState.IsValid) { //base.UserIDForLog为修改人的ID var result = TerminalManufacturerBLL.EditTerminalManufacturer(model, base.UserIDForLog); base.DoLog(OperationTypeEnum.Edit, result, "TerminalManufacturerName:" + model.ManufacturerName); return(Json(result)); } else { return(PartialView("_EditTerminalManufacturer", model)); } }
public static SelectResult <TerminalManufacturerEditModel> GetTerminalManufacturerByID(int id) { List <SqlParameter> paras = new List <SqlParameter>() { new SqlParameter("@ID", SqlDbType.Int), }; paras[0].Value = id; string sql = @"SELECT ID , ManufacturerName , ManufacturerCode , Nationality FROM dbo.TerminalManufacturer WHERE ID = @ID"; List <TerminalManufacturerEditModel> list = ConvertToList <TerminalManufacturerEditModel> .Convert(MSSQLHelper.ExecuteDataTable(CommandType.Text, sql, paras.ToArray())); TerminalManufacturerEditModel 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 <TerminalManufacturerEditModel>() { DataResult = data, Message = msg }); }