public static OperationResult EditPickUpTransportPoint(EditPickUpTransportPointModel model, int currentUserID) { string _EFInfo = ChangeCoordinateSystem(model.EFType, model.EFInfo, 1); //地图坐标转车机坐标,存入数据库 List <SqlParameter> paras = new List <SqlParameter>() { new SqlParameter("@AddressName", SqlDbType.NVarChar), new SqlParameter("@AddressCode", SqlDbType.NVarChar), new SqlParameter("@EFType", SqlDbType.TinyInt), new SqlParameter("@EFInfo", SqlDbType.NVarChar), new SqlParameter("@UpdateUser", SqlDbType.Int), new SqlParameter("@UpdateTime", SqlDbType.DateTime), new SqlParameter("@ID", SqlDbType.Int), }; paras[0].Value = model.AddressName.Trim(); paras[1].Value = model.AddressCode.Trim(); paras[2].Value = model.EFType; paras[3].Value = _EFInfo; paras[4].Value = currentUserID; paras[5].Value = DateTime.Now; paras[6].Value = model.ID; #region SQL string sql = @"UPDATE dbo.MGJH_TransportPointSetting SET AddressName = @AddressName , AddressCode = @AddressCode , EFType = @EFType , EFInfo = @EFInfo , UpdateUser = @UpdateUser, UpdateTime = @UpdateTime 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 EditPickUpTransportPoint(EditPickUpTransportPointModel model) { if (ModelState.IsValid) { var result = MGJH_TransportPointBLL.EditPickUpTransportPoint(model, base.CurrentUserID); base.DoLog(OperationTypeEnum.Edit, result, "PickUpTransportID:" + model.ID); return(Json(result)); } else { return(PartialView("_EditPickUpTransportPoint", model)); } }
public static SelectResult <EditPickUpTransportPointModel> GetPickUpTransportPointByID(int id) { List <SqlParameter> paras = new List <SqlParameter>() { new SqlParameter() { ParameterName = "@ID", SqlDbType = SqlDbType.Int, }, }; paras[0].Value = id; string sql = @"SELECT ID ,SettingType ,AddressName ,AddressCode ,EFType ,EFInfo FROM dbo.MGJH_TransportPointSetting WHERE ID=@ID"; List <EditPickUpTransportPointModel> list = ConvertToList <EditPickUpTransportPointModel> .Convert(MSSQLHelper.ExecuteDataTable(CommandType.Text, sql, paras.ToArray())); EditPickUpTransportPointModel data = null; string msg = string.Empty; if (list == null) { msg = PromptInformation.DBError; } else if (list.Count == 0) { msg = PromptInformation.NotExists; } else { data = list[0]; data.EFInfo = ChangeCoordinateSystem(data.EFType, data.EFInfo, 2); //将取出的车机坐标转成地图坐标,显示 } return(new SelectResult <EditPickUpTransportPointModel>() { DataResult = data, Message = msg }); }