/// <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);
}
