public static OperationResult AddPickUpTransportPoint(AddPickUpTransportPointModel model, int currentUserID) { string _EFInfo = ChangeCoordinateSystem(model.EFType, model.EFInfo, 1); //地图坐标转车机坐标,存入数据库 #region 参数 List <SqlParameter> paras = new List <SqlParameter>() { new SqlParameter("@SettingType", SqlDbType.TinyInt), new SqlParameter("@AddressName", SqlDbType.NVarChar), new SqlParameter("@AddressCode", SqlDbType.NVarChar), new SqlParameter("@EFType", SqlDbType.TinyInt), new SqlParameter("@EFInfo", SqlDbType.NVarChar), new SqlParameter("@CreateUser", SqlDbType.Int), new SqlParameter("@CreateTime", SqlDbType.DateTime), }; paras[0].Value = 1; //1-提货点 paras[1].Value = model.AddressName.Trim(); paras[2].Value = model.AddressCode.Trim(); paras[3].Value = model.EFType; paras[4].Value = _EFInfo; paras[5].Value = currentUserID; paras[6].Value = DateTime.Now; #endregion #region string sql = @"INSERT INTO dbo.MGJH_TransportPointSetting ( [SettingType] ,[AddressName] ,[AddressCode] ,[EFType] ,[EFInfo] ,[CreateUser] ,[CreateTime] ) VALUES ( @SettingType , @AddressName, @AddressCode, @EFType , @EFInfo, @CreateUser, @CreateTime )"; bool result = MSSQLHelper.ExecuteNonQuery(CommandType.Text, sql, paras.ToArray()) > 0; #endregion return(new OperationResult() { Success = result, Message = result ? PromptInformation.OperationSuccess : PromptInformation.DBError }); }
public ActionResult AddPickUpTransportPoint(AddPickUpTransportPointModel model) { if (ModelState.IsValid) { var result = MGJH_TransportPointBLL.AddPickUpTransportPoint(model, base.CurrentUserID); base.DoLog(OperationTypeEnum.Add, result, "PickUpAddressName:" + model.AddressName); return(Json(result)); } else { return(PartialView("_AddPickUpTransportPoint", model)); } }
public ActionResult AddPickUpTransportPoint() { AddPickUpTransportPointModel model = new AddPickUpTransportPointModel(); return(PartialView("_AddPickUpTransportPoint", model)); }