/// <summary> /// 添加新的物流公司 /// </summary> /// <param name="logisticsModel">物流公司对象</param> /// <param name="wareStr">物流仓库权限字符</param> /// <param name="mgrPassword">管理密码计算</param> /// <param name="number">操作人编号</param> /// <returns> 执行返回值 0 失败 1 成功</returns> public int AddLogistics2(LogisticsModel logisticsModel, string wareStr, string mgrPassword) { string sp = "AddLogisticsManage"; SqlParameter[] paras = new SqlParameter[] { new SqlParameter("@number", logisticsModel.Number), new SqlParameter("@logisticsCompany", logisticsModel.LogisticsCompany), new SqlParameter("@principal", logisticsModel.Principal), new SqlParameter("@telephone1", logisticsModel.Telephone1), new SqlParameter("@telephone2", logisticsModel.Telephone2), new SqlParameter("@telephone3", logisticsModel.Telephone3), new SqlParameter("@telephone4", logisticsModel.Telephone4), new SqlParameter("@country", logisticsModel.Country), new SqlParameter("@province", logisticsModel.Province), new SqlParameter("@city", logisticsModel.City), new SqlParameter("@storeAddress", logisticsModel.StoreAddress), new SqlParameter("@postalCode", logisticsModel.PostalCode), new SqlParameter("@licenceCode", logisticsModel.LicenceCode), new SqlParameter("@bank", logisticsModel.Bank), new SqlParameter("@bankCard", logisticsModel.BankCard), new SqlParameter("@tax", logisticsModel.Tax), new SqlParameter("@rigisterDate", logisticsModel.RigisterDate), new SqlParameter("@remark", logisticsModel.Remark), new SqlParameter("@operateIP", logisticsModel.OperateIP), new SqlParameter("@number", logisticsModel.OperateNum), //new SqlParameter ("@pass",logisticsModel.mgrPassword ), //new SqlParameter ("@WareHouse",logisticsModel.wareStr ) }; return((int)DBHelper.ExecuteScalar(sp, paras, CommandType.StoredProcedure)); }
/// <summary> /// 添加物流公司及管理员 /// </summary> /// <param name="logisticsModel">物流公司实例</param> /// <param name="pass">物流管理的密码</param> /// <param name="wareHouse">物流管理的仓库权限</param> /// <returns></returns> public static int AddLogistics(LogisticsModel logisticsModel, string pass, string wareHouse) { string sp = "AddThirdLogister"; SqlParameter[] para = new SqlParameter[] { new SqlParameter("@number", logisticsModel.Number), new SqlParameter("@logisticsCompany", logisticsModel.LogisticsCompany), new SqlParameter("@principal", logisticsModel.Principal), new SqlParameter("@telephone1", logisticsModel.Telephone1), new SqlParameter("@telephone2", logisticsModel.Telephone2), new SqlParameter("@telephone3", logisticsModel.Telephone3), new SqlParameter("@telephone4", logisticsModel.Telephone4), new SqlParameter("@country", logisticsModel.Country), new SqlParameter("@province", logisticsModel.Province), new SqlParameter("@city", logisticsModel.City), new SqlParameter("@storeAddress", logisticsModel.StoreAddress), new SqlParameter("@postalCode", logisticsModel.PostalCode), new SqlParameter("@licenceCode", logisticsModel.LicenceCode), new SqlParameter("@bank", logisticsModel.Bank), new SqlParameter("@bankCard", logisticsModel.BankCard), new SqlParameter("@tax", logisticsModel.Tax), new SqlParameter("@rigisterDate", logisticsModel.RigisterDate), new SqlParameter("@remark", logisticsModel.Remark), new SqlParameter("@operateIP", logisticsModel.OperateIP), new SqlParameter("@OperateNum", logisticsModel.OperateNum), new SqlParameter("@pass", pass), new SqlParameter("@WareHouse", wareHouse) }; return(int.Parse(DBHelper.ExecuteScalar(sp, para, CommandType.Text).ToString())); }
/// <summary> /// 修改物流公司 /// </summary> /// <param name="item"></param> /// /// <returns></returns> public int UpdateThirdLogistics(LogisticsModel logisticsModel, int id) { string sql = "update Logistics set LogisticsCompany=@logisticsCompany,Principal=@principal,Telephone1=@telephone1,Telephone2=@telephone2,Telephone3=@telephone3,Telephone4=@telephone4," + "Cpccode=@cpccode,StoreAddress=@storeAddress,PostalCode=@postalCode,LicenceCode=@licenceCode,BankCode=@bankCode,BankCard=@bankCard,tax=@tax," + "Remark=@remark where id=@id"; SqlParameter[] para = new SqlParameter[] { new SqlParameter("@logisticsCompany", logisticsModel.LogisticsCompany), new SqlParameter("@principal", logisticsModel.Principal), new SqlParameter("@telephone1", logisticsModel.Telephone1), new SqlParameter("@telephone2", logisticsModel.Telephone2), new SqlParameter("@telephone3", logisticsModel.Telephone3), new SqlParameter("@telephone4", logisticsModel.Telephone4), new SqlParameter("@cpccode", logisticsModel.Cpccode), new SqlParameter("@storeAddress", logisticsModel.StoreAddress), new SqlParameter("@postalCode", logisticsModel.PostalCode), new SqlParameter("@licenceCode", logisticsModel.LicenceCode), new SqlParameter("@bankCode", logisticsModel.BankCode), new SqlParameter("@bankCard", logisticsModel.BankCard), new SqlParameter("@tax", logisticsModel.Tax), new SqlParameter("@remark", logisticsModel.Remark), new SqlParameter("@id", id) }; return(DBHelper.ExecuteNonQuery(sql, para, CommandType.Text)); }
/// <summary> /// 添加物流公司 /// </summary> /// <param name="item"></param> /// /// <returns></returns> public int AddLogistics(LogisticsModel logisticsModel) { string sql = "insert into Logistics(Number,LogisticsCompany,Principal,Telephone1,Telephone2,Telephone3,Telephone4,cpccode,StoreAddress,PostalCode,LicenceCode,BankCode,BankCard,tax,RigisterDate,Remark,OperateIP)" + " values (@number,@logisticsCompany,@principal,@telephone1,@telephone3,@telephone3,@telephone4,@cpccode,@storeAddress,@postalCode,@licenceCode,@bankCode,@bankCard,@tax,@rigisterDate,@remark,@operateIP)"; SqlParameter[] para = new SqlParameter[] { new SqlParameter("@number", logisticsModel.Number), new SqlParameter("@logisticsCompany", logisticsModel.LogisticsCompany), new SqlParameter("@principal", logisticsModel.Principal), new SqlParameter("@telephone1", logisticsModel.Telephone1), new SqlParameter("@telephone2", logisticsModel.Telephone2), new SqlParameter("@telephone3", logisticsModel.Telephone3), new SqlParameter("@telephone4", logisticsModel.Telephone4), new SqlParameter("@cpccode", logisticsModel.Cpccode), new SqlParameter("@storeAddress", logisticsModel.StoreAddress), new SqlParameter("@postalCode", logisticsModel.PostalCode), new SqlParameter("@licenceCode", logisticsModel.LicenceCode), new SqlParameter("@bankCode", logisticsModel.BankCode), new SqlParameter("@bankCard", logisticsModel.BankCard), new SqlParameter("@tax", logisticsModel.Tax), new SqlParameter("@rigisterDate", Convert.ToDateTime(logisticsModel.RigisterDate.ToShortDateString() + " " + DateTime.Now.ToLongTimeString()).ToUniversalTime()), new SqlParameter("@remark", logisticsModel.Remark), new SqlParameter("@operateIP", logisticsModel.OperateIP), }; return(DBHelper.ExecuteNonQuery(sql, para, CommandType.Text)); }
/// <summary> /// 添加第三方物流信息 /// </summary> /// <param name="logisticsModel">第三方物流基本信息</param> /// <param name="pass">第三方物流对应管理密码</param> /// <param name="warehouse">第三方物流权限仓库编号字符</param> /// <returns></returns> public int AddLogistics(LogisticsModel logisticsModel, string pass, string warehouse) { if (!ManagerBLL.CheckNumber(logisticsModel.Number)) { //标识已存在相同编号的管理员不可修改 return(-2); } return(0);//ThirdLogisticsDAL.AddLogistics(logisticsModel, pass, warehouse); }
/// <summary> /// 根据ID修改物流公司 /// </summary> /// <param name="item"></param> /// /// <returns></returns> public Boolean UpdateThirdLogistics(LogisticsModel logisticsModel, int id) { BLL.CommonClass.ChangeLogs cl_h_info = new BLL.CommonClass.ChangeLogs("Logistics", "ltrim(rtrim(id))"); cl_h_info.AddRecord(id); bool bb = thirdLogisticsDAL.UpdateThirdLogistics(logisticsModel, id) == 0 ? false : true; cl_h_info.AddRecord(id); cl_h_info.ModifiedIntoLogs(BLL.CommonClass.ChangeCategory.company9, id.ToString(), BLL.CommonClass.ENUM_USERTYPE.objecttype8); return(bb); }
/// <summary> /// 修改第三方物流信息 /// </summary> /// <param name="logisticsModel">第三方物流基本信息</param> /// <param name="id">第三方物流编号</param> /// <param name="pass">第三方物流对应管理密码</param> /// <param name="warehouse">第三方物流权限仓库编号字符</param> /// <returns></returns> public int UpdateThirdLogistics(LogisticsModel logisticsModel, int id, string pass, string warehouse) { LogisticsModel model = thirdLogisticsDAL.GetThirdLogisticsInit(id); if (model.Number != logisticsModel.Number) { if (!ManagerBLL.CheckNumber(logisticsModel.Number)) { //标识已存在相同编号的管理员不可修改 return(-2); } } return(ThirdLogisticsDAL.UptLogistics(logisticsModel, pass, warehouse, id)); }
//用于添加 private bool AddThirdLogistics() { LogisticsModel logisticsModel = Set(); if (logisticsModel == null) { ScriptHelper.SetAlert(Page, "请输入正确的批准日期"); //this.txtDate.Focus(); return(false); } else { return(thirdLogisticsDLL.AddLogistics(Set())); } }
private LogisticsModel Set() { LogisticsModel logisticsModel = new LogisticsModel(); logisticsModel.Number = this.txtnumber.Text.Trim(); logisticsModel.LogisticsCompany = txtName.Text.Trim(); logisticsModel.Telephone1 = txtTelephone1.Text.Trim(); logisticsModel.Telephone2 = txtTelephone2.Text.Trim(); logisticsModel.Telephone3 = txtTelephone3.Text.Trim(); logisticsModel.Telephone4 = txtTelephone4.Text.Trim(); logisticsModel.StoreAddress = txtStoreAddress.Text.Trim(); logisticsModel.PostalCode = txtPostalCode.Text.Trim(); logisticsModel.Principal = txtPrincipal.Text.Trim(); //logisticsModel.Bank = txtBank.Text.Trim(); logisticsModel.Bank = ddlBank.SelectedItem.Text; logisticsModel.BankCard = txtBankCard.Text.Trim(); logisticsModel.Tax = txtTax.Text.Trim(); logisticsModel.LicenceCode = txtLicenceCode.Text.Trim(); logisticsModel.Remark = txtRemark.Text.Trim(); logisticsModel.Country = CountryCity1.Country; logisticsModel.Province = CountryCity1.Province; logisticsModel.City = CountryCity1.City; logisticsModel.Xian = CountryCity1.Xian; string sgas = "select Cpccode from city where Country='" + CountryCity1.Country + "' and Province='" + CountryCity1.Province + "' and City='" + CountryCity1.City + "' and xian='" + CountryCity1.Xian + "'"; string Cpccode = DAL.DBHelper.ExecuteScalar(sgas) + ""; logisticsModel.Cpccode = Cpccode; logisticsModel.BankCode = DAL.DBHelper.ExecuteScalar("select BankCode from MemberBank where BankId='" + ddlBank.SelectedValue + "'") + ""; try { logisticsModel.RigisterDate = Convert.ToDateTime(txtDate.Text.ToString()); } catch (FormatException) { return(null); } logisticsModel.City = CountryCity1.City; logisticsModel.Country = CountryCity1.Country; logisticsModel.Province = CountryCity1.Province; logisticsModel.Xian = CountryCity1.Xian; logisticsModel.OperateIP = Request.UserHostAddress; return(logisticsModel); }
//得到所有信息用于初始化,填冲到各个文本框中 private void showDetail(int id) { LogisticsModel logistics = thirdLogisticsDLL.GetThirdLogisticsInit(id); txtnumber.Text = logistics.Number.ToString(); //绑定 物流公司编号 txtName.Text = logistics.LogisticsCompany.ToString(); //绑定 物流公司名称 txtTelephone2.Text = logistics.Telephone2.ToString(); //绑定 办公电话 txtStoreAddress.Text = logistics.StoreAddress.ToString(); //绑定 办公地址 txtPostalCode.Text = logistics.PostalCode; //绑定 邮编 txtTelephone3.Text = logistics.Telephone3.ToString(); //绑定 负责人手机 txtTelephone1.Text = logistics.Telephone1.ToString(); //绑定 负责人电话 txtTelephone4.Text = logistics.Telephone4.ToString(); //绑定 传真电话 txtPrincipal.Text = logistics.Principal.ToString(); //绑定 负责人姓名 //txtBank.Text = logistics.Bank.ToString();//绑定 银行帐号 ddlBank.SelectedItem.Text = logistics.Bank.ToString(); txtBankCard.Text = logistics.BankCard.ToString(); //绑定 营业执 txtTax.Text = logistics.Tax.ToString(); //绑定 税号 txtLicenceCode.Text = logistics.LicenceCode.ToString(); //绑定 营业执 txtRemark.Text = logistics.Remark.ToString(); //绑定 备注 txtDate.Text = logistics.RigisterDate.ToShortDateString(); this.CountryCity1.SelectCountry(logistics.Country, logistics.Province, logistics.City, logistics.Xian); }
/// <summary> /// 得到物流公司信息用于初始化显示 /// </summary> /// <param name="item"></param> /// /// <returns></returns> public LogisticsModel GetThirdLogisticsInit(int id) { string sql = "select a.ID,a.Number,a.LogisticsCompany,a.Principal,a.Telephone1,a.Telephone2,a.Telephone3,a.Telephone4," + "a.cpccode,b.Country,b.Province,b.City,b.xian,a.StoreAddress,a.PostalCode,a.LicenceCode,a.bankcode,isnull((select bankname from memberbank where bankcode = a.bankcode),'') as bank,a.BankCard,a.RigisterDate,a.Remark,a.Tax,a.Administer,a.LogisticsPerson,a.OperateIP,a.OperateNum from Logistics a,city b where a.id=@id and a.cpccode=b.cpccode"; SqlParameter[] para = new SqlParameter[] { new SqlParameter("@id", id) }; SqlDataReader dr = DBHelper.ExecuteReader(sql, para, CommandType.Text); LogisticsModel logisticsModel = null; while (dr.Read()) { logisticsModel = new LogisticsModel(); logisticsModel.ID = id; logisticsModel.Number = dr.GetString(dr.GetOrdinal("Number")); logisticsModel.LogisticsCompany = dr.GetString(dr.GetOrdinal("LogisticsCompany")); logisticsModel.Principal = dr.GetString(dr.GetOrdinal("Principal")); logisticsModel.Telephone1 = dr.GetString(dr.GetOrdinal("Telephone1")); logisticsModel.Telephone2 = dr.GetString(dr.GetOrdinal("Telephone2")); logisticsModel.Telephone3 = dr.GetString(dr.GetOrdinal("Telephone3")); logisticsModel.Telephone4 = dr.GetString(dr.GetOrdinal("Telephone4")); logisticsModel.StoreAddress = dr.GetString(dr.GetOrdinal("StoreAddress")); logisticsModel.PostalCode = dr.GetString(dr.GetOrdinal("PostalCode")); logisticsModel.LicenceCode = dr.GetString(dr.GetOrdinal("LicenceCode")); logisticsModel.Bank = dr.GetString(dr.GetOrdinal("Bank")); logisticsModel.BankCard = dr.GetString(dr.GetOrdinal("BankCard")); logisticsModel.Tax = dr.GetString(dr.GetOrdinal("Tax")); logisticsModel.Remark = dr.GetString(dr.GetOrdinal("Remark")); logisticsModel.RigisterDate = Convert.ToDateTime(dr["RigisterDate"]); logisticsModel.Country = dr["Country"].ToString(); logisticsModel.City = dr["City"].ToString(); logisticsModel.Xian = dr["xian"].ToString(); logisticsModel.Province = dr["Province"].ToString(); } dr.Close(); return(logisticsModel); }
/// <summary> /// 添加第三方物流公司 /// </summary> /// <returns></returns> public Boolean AddLogistics(LogisticsModel logisticsModel) { return(thirdLogisticsDAL.AddLogistics(logisticsModel) == 0 ? false : true); }
/// <summary> /// 初始化(加载配置文件) /// </summary> /// <param name="folderPath">配置文件所在路径</param> public void Initialize(string folderPath) { try { ruleSequenceDic = new Dictionary <string, RuleEntity>(); ruleEntityList = new List <RuleEntity>(); logisticcDic = new Dictionary <string, Logistic>(); logisticsList = new List <LogisticsModel>(); // 加载产品配置文件,并初始化 productConfig = this.LoadProductConfig(Path.Combine(folderPath, "Product.xml")); if ((productConfig == null) || (productConfig.Products == null) || (productConfig.Products.Count <= 0)) { throw new ArgumentException("配置文件Product.xml有误。"); } SubLevelDic = productConfig.ProductClass.SubLevels.ToDictionary(sl => sl.PTId); foreach (var p in productConfig.Products) { ProductEntity pe = new ProductEntity(p); if (this.prodDic.ContainsKey(p.SKUNo.Trim().ToLower())) { throw new ArgumentException(string.Format("SKUNO[{0}]重复配置", pe.SKUNo)); } this.prodDic.Add(p.SKUNo.Trim().ToLower(), pe); } // 加载规则配置文件,并初始化 ruleConfigs = this.LoadRules(Path.Combine(folderPath, "Rules")); foreach (SplitPackageConfig config in ruleConfigs) { var organizations = config.SubOrganizations; if ((organizations == null) || (organizations.Count < 0)) { continue; } LogisticsModel logisiticsModel = new LogisticsModel() { ID = config.OrganizationId, Name = config.OrganizationName, Rule = config.RuleDiscription, URL = config.URL, LogoURL = config.LogoURL }; if (logisticsList.Any(o => o.ID == logisiticsModel.ID)) { throw new ArgumentException(string.Format("Logistics ID:{0}重复配置", logisiticsModel.ID)); } else { // 海关的配置不需要,代码不处理,不在配置文件目录中放海关的规则 if (!Regex.IsMatch(config.OrganizationId, @"^(\-\d+|0)$")) { logisticsList.Add(logisiticsModel); } } foreach (var organization in organizations) { logisiticsModel.GradeList.Add(organization.GradeName); var rules = organization.Rules; if ((rules == null) || (rules.Count < 0)) { continue; } Logistic logistics = new Logistic(organization, config); if (logisticcDic.ContainsKey(logistics.LogisticName)) { throw new ArgumentException(String.Format("Logistics Name is already Added. LogisticName:[{0}]", logistics.LogisticName)); } logisticcDic.Add(logistics.LogisticName, logistics); foreach (PackageRule rule in rules) { if (rule == null) { continue; } RuleEntity ruleSeq = new RuleEntity(rule, config, organization); ruleSequenceDic.Add(ruleSeq.Key, ruleSeq); ruleEntityList.Add(ruleSeq); logistics.AddRuleSequenceDic(ruleSeq); } } } logisticsRelated = this.LoadLogisticsRelated(Path.Combine(folderPath, "LogisticsRelated.xml")); CheckLevelConfig(); splitConfig.Initialize(ruleEntityList); bcRuleEntity.Initialize(productConfig.ProductClass.BcConfig, SubLevelDic); var msgs = Enumerable.Repeat("Spliter Initialized.", 1) .Concat(ruleEntityList.Select(re => string.Format(" ({0}, {1}, {2})", re.LogisticsName, re.SubOrganizationName, re.RuleName))); LogHelper.Logger.Info(string.Join(Environment.NewLine, msgs)); } catch (Exception ex) { LogHelper.Logger.Info(ex.Message, ex); throw; } }
public LogisticsReport ReceiveLogistics(LogisticsModel source) { var result = _lisService.ReceiveLogistics(source); return(result); }
public LogisticsReport SendLogistics(LogisticsModel source) { var result = _lisService.SendLogistics(source); return(result); }