public ActionResult ModifyGoodsType(GoodsTypeViewModel model) { if (ModelState.IsValid) { //创建数据 GoodsType data = new GoodsType(); data.Id = model.Id; data.Name = model.Name; data.ParentId = model.ParentId; data.Remark = model.Remark ?? string.Empty; //保存数据 string strErrText; DDSystem dd = new DDSystem(); if (dd.UpdateGoodsType(data, LoginAccountId, LoginStaffName, out strErrText)) { return(Json(string.Empty)); } else { return(Json(strErrText)); } } return(View(model)); }
public ActionResult ModifyCity(CityViewModel model) { if (ModelState.IsValid) { //创建数据 City data = new City(); data.Id = model.Id; data.Name = model.Name; data.CountryName = model.CountryName; data.ProvinceName = model.ProvinceName; data.Remark = model.Remark ?? string.Empty; //保存数据 string strErrText; DDSystem city = new DDSystem(); if (city.UpdateCity(data, LoginAccountId, LoginStaffName, out strErrText)) { return(Json(string.Empty)); } else { return(Json(strErrText)); } } return(View(model)); }
public JsonResult LoadGoodsByGoodsNo(string strGoodsNo) { string strErrText; DDSystem dd = new DDSystem(); Goods data = dd.LoadGoodsByGoodsNo(strGoodsNo, LoginAccountId, LoginStaffName, out strErrText); if (data == null) { return(Json(null, JsonRequestBehavior.AllowGet)); } else { var ret = new { Id = data.Id, Name = data.Name, Brand = data.Brand, SpecModel = data.SpecModel, GWeight = data.GWeight, Grade = data.Grade, Packing = data.Packing, PieceWeight = data.PieceWeight }; return(Json(ret, JsonRequestBehavior.AllowGet)); } }
public JsonResult LoadReceiverByName(string strName) { string strErrText; DDSystem dd = new DDSystem(); Receiver data = dd.LoadReceiverByName(strName, LoginAccountId, LoginStaffName, out strErrText); if (data == null) { return(Json(null, JsonRequestBehavior.AllowGet)); } else { var ret = new { Country = data.Country, Province = data.Province, City = data.City, Address = data.Address, Contact = data.Contact, ContactTel = data.ContactTel }; return(Json(ret, JsonRequestBehavior.AllowGet)); } }
public ActionResult NewProvince() { string strErrText; //生成国家下拉列表项 DDSystem dd = new DDSystem(); List <Country> listCountry = dd.LoadCountrys(LoginAccountId, LoginStaffName, out strErrText); if (listCountry == null) { throw new Exception(strErrText); } List <SelectListItem> selectListCountry = new List <SelectListItem>(); selectListCountry.Add(new SelectListItem { Text = string.Empty, Value = string.Empty }); selectListCountry.AddRange(from c in listCountry select new SelectListItem { Text = c.Name, Value = c.Name }); ViewData["Countries"] = new SelectList(selectListCountry, "Value", "Text"); //创建空的Model ProvinceViewModel model = new ProvinceViewModel(); return(View(model)); }
public ActionResult ModifyProvince(ProvinceViewModel model) { if (ModelState.IsValid) { //创建数据 Province data = new Province(); data.Id = model.Id; data.Name = model.Name; data.CountryName = model.CountryName; data.Remark = model.Remark ?? string.Empty; //保存数据 string strErrText; DDSystem province = new DDSystem(); if (province.UpdateProvince(data, LoginAccountId, LoginStaffName, out strErrText)) { return(Json(string.Empty)); } else { return(Json(strErrText)); } } return(View(model)); }
public ActionResult NewGoodsType() { string strErrText; //生成上级货物类别下拉列表项 DDSystem dd = new DDSystem(); List <GoodsType> listGoodsType = dd.LoadGoodsTypes(LoginAccountId, LoginStaffName, out strErrText); if (listGoodsType == null) { throw new Exception(strErrText); } List <SelectListItem> selectListGoodsType = new List <SelectListItem>(); selectListGoodsType.Add(new SelectListItem { Text = string.Empty, Value = "0" }); selectListGoodsType.AddRange(from o in listGoodsType orderby o.FullName select new SelectListItem { Text = o.FullName, Value = o.Id.ToString() }); ViewData["GoodsTypes"] = new SelectList(selectListGoodsType, "Value", "Text"); //创建空的Model GoodsTypeViewModel model = new GoodsTypeViewModel(); return(View(model)); }
public ActionResult DeleteCity(string id) { //删除数据 string strErrText; DDSystem city = new DDSystem(); if (city.DeleteCity(long.Parse(id), LoginAccountId, LoginStaffName, out strErrText)) { return(Json(string.Empty)); } else { return(Json(strErrText)); } }
public JsonResult LoadCarrierTransportPrice(string carrierId, string startCountry, string startProvince, string startCity, string destCountry, string destProvince, string destCity, string planType, string createTime) { string strErrText; DDSystem dd = new DDSystem(); CarrierTransportPrice data = dd.LoadCarrierTransportPrice(long.Parse(carrierId), startCountry, startProvince, startCity, destCountry, destProvince, destCity, planType, DateTime.Parse(createTime), LoginAccountId, LoginStaffName, out strErrText); if (data == null) { return(Json(0, JsonRequestBehavior.AllowGet)); } else { return(Json(data.TransportPrice, JsonRequestBehavior.AllowGet)); } }
public JsonResult LoadDistance(string strReceiverName, string startCountry, string startProvince, string startCity) { string strErrText; DDSystem dd = new DDSystem(); ReceiverDistance data = dd.LoadReceiverDistance(strReceiverName, startCountry, startProvince, startCity, LoginAccountId, LoginStaffName, out strErrText); if (data == null) { return(Json(null, JsonRequestBehavior.AllowGet)); } else { return(Json(data.KM, JsonRequestBehavior.AllowGet)); } }
public JsonResult LoadCountrysGrid(string sidx, string sord, int page, int rows) { //读取全部数据 string strErrText; DDSystem country = new DDSystem(); List <Country> listCountry = country.LoadCountrys(LoginAccountId, LoginStaffName, out strErrText); if (listCountry == null) { throw new Exception(strErrText); } //提取当前页面数据 int nTotalRows = listCountry.Count; int nPageIndex = page; int nPageSize = rows; int nTotalPages = nTotalRows / nPageSize; if (nTotalRows % nPageSize > 0) { nTotalPages++; } string sortExpression = (sidx ?? "Id") + " " + (sord ?? "ASC"); var data = listCountry.OrderBy(sortExpression).Skip((nPageIndex - 1) * nPageSize).Take(nPageSize).ToList(); //生成表格数据 var ret = new { total = nTotalPages, page = nPageIndex, records = nTotalRows, rows = ( from c in data select new { id = c.Id, cell = new string[] { c.Id.ToString(), c.Name, c.Remark, } }).ToArray() }; return(Json(ret, JsonRequestBehavior.AllowGet)); }
public JsonResult LoadProvincesGrid(string sidx, string sord, int page, int rows) { //读取全部数据 string strErrText; DDSystem province = new DDSystem(); List <Province> listProvince = province.LoadProvinces(LoginAccountId, LoginStaffName, out strErrText); if (listProvince == null) { throw new Exception(strErrText); } //提取当前页面数据 int nTotalRows = listProvince.Count; int nPageIndex = page; int nPageSize = rows; int nTotalPages = nTotalRows / nPageSize; if (nTotalRows % nPageSize > 0) { nTotalPages++; } var data = listProvince.OrderBy(p => p.Name).Skip((nPageIndex - 1) * nPageSize).Take(nPageSize).ToList(); //生成表格数据 var ret = new { total = nTotalPages, page = nPageIndex, records = nTotalRows, rows = ( from p in data select new { id = p.Id, cell = new string[] { p.Id.ToString(), p.Name, p.CountryName, p.Remark, } }).ToArray() }; return(Json(ret, JsonRequestBehavior.AllowGet)); }
public JsonResult LoadProvincesByCountry(string strCountryName) { string strErrText; DDSystem dd = new DDSystem(); List <Province> listProvince = dd.LoadProvincesByCountry(strCountryName, LoginAccountId, LoginStaffName, out strErrText); if (listProvince == null) { throw new Exception(strErrText); } var ret = from p in listProvince select p.Name; return(Json(ret, JsonRequestBehavior.AllowGet)); }
public JsonResult LoadCustomerReceivers(string customerName) { string strErrText; DDSystem dd = new DDSystem(); List <Receiver> listReceiver = dd.LoadCustomerReceivers(customerName, LoginAccountId, LoginStaffName, out strErrText); if (listReceiver == null) { throw new Exception(strErrText); } var ret = from r in listReceiver select r.Name; return(Json(ret, JsonRequestBehavior.AllowGet)); }
public JsonResult LoadCitysByProvince(string strCountryName, string strProvinceName) { string strErrText; DDSystem dd = new DDSystem(); List <City> listCity = dd.LoadCitysByProvince(strCountryName, strProvinceName, LoginAccountId, LoginStaffName, out strErrText); if (listCity == null) { throw new Exception(strErrText); } var ret = from c in listCity select c.Name; return(Json(ret, JsonRequestBehavior.AllowGet)); }
public JsonResult LoadGenerateBusinessCarriersByTimespan(string startTime, string endTime) { string strErrText; DDSystem dd = new DDSystem(); List <Carrier> listCarrier = dd.LoadGenerateBusinessCarriersByTimespan(startTime, endTime, LoginAccountId, LoginStaffName, out strErrText); if (listCarrier == null) { throw new Exception(strErrText); } var ret = from c in listCarrier select c.Name; return(Json(ret, JsonRequestBehavior.AllowGet)); }
public ActionResult ModifyProvince(string id) { string strErrText; //生成Model数据 DDSystem province = new DDSystem(); Province data = province.LoadProvince(long.Parse(id), LoginAccountId, LoginStaffName, out strErrText); if (data == null) { throw new Exception(strErrText); } ProvinceViewModel model = new ProvinceViewModel(); model.Id = data.Id; model.Name = data.Name; model.CountryName = data.CountryName; model.Remark = data.Remark; //生成国家下拉列表项 DDSystem dd = new DDSystem(); List <Country> listCountry = dd.LoadCountrys(LoginAccountId, LoginStaffName, out strErrText); if (listCountry == null) { throw new Exception(strErrText); } List <SelectListItem> selectListCountry = new List <SelectListItem>(); selectListCountry.Add(new SelectListItem { Text = string.Empty, Value = string.Empty }); selectListCountry.AddRange(from c in listCountry select new SelectListItem { Text = c.Name, Value = c.Name }); ViewData["Countries"] = new SelectList(selectListCountry, "Value", "Text", model.CountryName); return(View(model)); }
public ActionResult ModifyGoodsType(string id) { string strErrText; //生成Model数据 DDSystem dd = new DDSystem(); GoodsType data = dd.LoadGoodsType(long.Parse(id), LoginAccountId, LoginStaffName, out strErrText); if (data == null) { throw new Exception(strErrText); } GoodsTypeViewModel model = new GoodsTypeViewModel(); model.Id = data.Id; model.Name = data.Name; model.ParentId = data.ParentId; model.Remark = data.Remark; List <GoodsType> listGoodsType = dd.LoadGoodsTypes(LoginAccountId, LoginStaffName, out strErrText); if (listGoodsType == null) { throw new Exception(strErrText); } List <SelectListItem> selectlistGoodsType = new List <SelectListItem>(); selectlistGoodsType.Add(new SelectListItem { Text = string.Empty, Value = "0" }); selectlistGoodsType.AddRange(from t in listGoodsType where !t.FullPath.StartsWith(data.FullPath) orderby t.FullName select new SelectListItem { Text = t.FullName, Value = t.Id.ToString() }); ViewData["GoodsTypes"] = new SelectList(selectlistGoodsType, "Value", "Text", model.ParentId); return(View(model)); }
public JsonResult LoadGoodsTypes() { string strErrText = string.Empty; DDSystem dd = new DDSystem(); List <GoodsType> listGoodsType = dd.LoadGoodsTypes(LoginAccountId, LoginStaffName, out strErrText); if (listGoodsType == null) { throw new Exception(strErrText); } var ret = from t in listGoodsType select new { t.Id, t.FullName }; return(Json(ret, JsonRequestBehavior.AllowGet)); }
public JsonResult LoadDriversByCarNo(string strCarNo) { string strErrText; DDSystem dd = new DDSystem(); List <CarrierDriver> listDriver = dd.LoadDriversByCarNo(strCarNo, LoginAccountId, LoginStaffName, out strErrText); if (listDriver == null) { throw new Exception(strErrText); } var ret = from d in listDriver select new { d.Id, d.Name }; return(Json(ret, JsonRequestBehavior.AllowGet)); }
public JsonResult LoadDriver(long nId) { string strErrText; DDSystem dd = new DDSystem(); CarrierDriver data = dd.LoadDriver(nId, LoginAccountId, LoginStaffName, out strErrText); if (data == null) { throw new Exception(strErrText); } var ret = new { LicenseNo = data.LicenseNo, MobileTel = data.MobileTel, HomeTel = data.HomeTel, }; return(Json(ret, JsonRequestBehavior.AllowGet)); }
public JsonResult LoadCarrierSettlementExpression(string carrierId, string planType) { string strErrText; DDSystem dd = new DDSystem(); CarrierSettlementExpression data = dd.LoadCarrierSettlementExpression(long.Parse(carrierId), planType, LoginAccountId, LoginStaffName, out strErrText); if (data == null) { return(Json(null, JsonRequestBehavior.AllowGet)); } else { var ret = new { TransportChargeExpression = data.TransportChargeExpression, TransportPriceExpression = data.TransportPriceExpression }; return(Json(ret, JsonRequestBehavior.AllowGet)); } }
public ActionResult ModifyCountry(string id) { string strErrText; //生成Model数据 DDSystem country = new DDSystem(); Country data = country.LoadCountry(long.Parse(id), LoginAccountId, LoginStaffName, out strErrText); if (data == null) { throw new Exception(strErrText); } CountryViewModel model = new CountryViewModel(); model.Id = data.Id; model.Name = data.Name; model.Remark = data.Remark; return(View(model)); }
public JsonResult LoadCarrierCars(string carrierName) { string strErrText; DDSystem dd = new DDSystem(); List <CarrierCar> listCar = dd.LoadCarrierCars(carrierName, LoginAccountId, LoginStaffName, out strErrText); if (listCar == null) { throw new Exception(strErrText); } var ret = from c in listCar select new { c.CarNo, c.TrailerNo, c.CarryingCapacity }; return(Json(ret, JsonRequestBehavior.AllowGet)); }
public JsonResult LoadCarByCarNo(string strCarNo) { string strErrText; DDSystem dd = new DDSystem(); CarrierCar data = dd.LoadCarByCarNo(strCarNo, LoginAccountId, LoginStaffName, out strErrText); if (data == null) { return(Json(null, JsonRequestBehavior.AllowGet)); } else { var ret = new { TrailerNo = data.TrailerNo, CarryingCapacity = data.CarryingCapacity }; return(Json(ret, JsonRequestBehavior.AllowGet)); } }
public JsonResult LoadGoodsTypesGrid(long?nodeid, int?n_level) { //读取全部数据 string strErrText; DDSystem dd = new DDSystem(); List <GoodsType> listGoodsType = dd.LoadGoodsTypes(LoginAccountId, LoginStaffName, out strErrText); if (listGoodsType == null) { throw new Exception(strErrText); } //根据父子关系生成类别树 List <GoodsType> data = new List <GoodsType>(); RecursiveMakeGoodsTypeTree(listGoodsType, 0, ref data); //返回数据 var ret = new { page = 1, total = 1, records = data.Count, rows = (from t in data select new { cell = new[] { t.Name, t.Id.ToString(), t.Remark, (t.FullPath.Where(c => c == '\\').Count() - 1).ToString(), t.ParentId.ToString(), data.Where(GoodsType => (GoodsType.FullPath.StartsWith(t.FullPath) && GoodsType.Id != t.Id)).Count() == 0 ? "true" : "false", "true" } }).ToArray() }; return(Json(ret, JsonRequestBehavior.AllowGet)); }
public ActionResult NewCountry(CountryViewModel model) { if (ModelState.IsValid) { //创建数据 Country data = new Country(); data.Name = model.Name; data.Remark = model.Remark ?? string.Empty; //保存数据 string strErrText; DDSystem country = new DDSystem(); if (country.InsertCountry(data, LoginAccountId, LoginStaffName, out strErrText)) { return(Json(string.Empty)); } else { return(Json(strErrText)); } } return(View(model)); }
public JsonResult LoadCarrierByCarNo(string strCarNo) { string strErrText; DDSystem dd = new DDSystem(); Carrier data = dd.LoadCarrierByCarNo(strCarNo, LoginAccountId, LoginStaffName, out strErrText); if (data == null) { return(Json(null, JsonRequestBehavior.AllowGet)); } else { var ret = new { Id = data.Id, Name = data.Name, BusinessType = data.BusinessType, PaymentType = data.PaymentType }; return(Json(ret, JsonRequestBehavior.AllowGet)); } }
public ActionResult ModifyCity(string id) { string strErrText; //生成Model数据 DDSystem city = new DDSystem(); City data = city.LoadCity(long.Parse(id), LoginAccountId, LoginStaffName, out strErrText); if (data == null) { throw new Exception(strErrText); } CityViewModel model = new CityViewModel(); model.Id = data.Id; model.Name = data.Name; model.CountryName = data.CountryName; model.ProvinceName = data.ProvinceName; model.Remark = data.Remark; //生成国家下拉列表项 DDSystem dd = new DDSystem(); List <Country> listCountry = dd.LoadCountrys(LoginAccountId, LoginStaffName, out strErrText); if (listCountry == null) { throw new Exception(strErrText); } List <SelectListItem> selectListCountry = new List <SelectListItem>(); selectListCountry.Add(new SelectListItem { Text = string.Empty, Value = string.Empty }); selectListCountry.AddRange(from c in listCountry select new SelectListItem { Text = c.Name, Value = c.Name }); ViewData["Countries"] = new SelectList(selectListCountry, "Value", "Text", model.CountryName); //生成空的省份下拉列表项 List <Province> listState = null; if (!string.IsNullOrEmpty(model.CountryName)) { listState = dd.LoadProvincesByCountry(model.CountryName, LoginAccountId, LoginStaffName, out strErrText); if (listState == null) { throw new Exception(strErrText); } } else { listState = new List <Province>(); } List <SelectListItem> selectListState = new List <SelectListItem>(); selectListState.Add(new SelectListItem { Text = string.Empty, Value = string.Empty }); selectListState.AddRange(from s in listState select new SelectListItem { Text = s.Name, Value = s.Name }); ViewData["States"] = new SelectList(selectListState, "Value", "Text", model.ProvinceName); return(View(model)); }
public JsonResult LoadCitysGrid(string country, string province, string sidx, string sord, int page, int rows) { //读取全部数据 string strErrText; DDSystem city = new DDSystem(); List <City> listCity = null; if (country == null || country == InnoSoft.LS.Resources.Options.SelectCountry) { listCity = city.LoadCitys(LoginAccountId, LoginStaffName, out strErrText); } else { if (province == null || province == InnoSoft.LS.Resources.Options.SelectProvince) { listCity = city.LoadCitysByCountry(country, LoginAccountId, LoginStaffName, out strErrText); } else { listCity = city.LoadCitysByProvince(country, province, LoginAccountId, LoginStaffName, out strErrText); } } if (listCity == null) { throw new Exception(strErrText); } //提取当前页面数据 int nTotalRows = listCity.Count; int nPageIndex = page; int nPageSize = rows; int nTotalPages = nTotalRows / nPageSize; if (nTotalRows % nPageSize > 0) { nTotalPages++; } var data = listCity.OrderBy(c => c.ProvinceName).ThenBy(c => c.Name).Skip((nPageIndex - 1) * nPageSize).Take(nPageSize).ToList(); //生成表格数据 var ret = new { total = nTotalPages, page = nPageIndex, records = nTotalRows, rows = ( from c in data select new { id = c.Id, cell = new string[] { c.Id.ToString(), c.Name, c.CountryName, c.ProvinceName, c.Remark, } }).ToArray() }; return(Json(ret, JsonRequestBehavior.AllowGet)); }