/// <summary>
/// 添加, 这里可以人工干预，提高程序的性能
/// </summary>
/// <param name="entity">实体</param>
/// <param name="identity">自增量方式，表主键是否采用自增的策略</param>
/// <param name="returnId">返回主键，不返回程序允许速度会快，主要是为了主细表批量插入数据优化用的</param>
/// <returns>主键</returns>
public string AddToRecycleBill(ZtoPrintBillEntity entity, bool identity = false, bool returnId = false, string dataSource = "0")
{
this.Identity = identity;
this.ReturnId = returnId;
return(this.AddObject(entity));
}
/// <summary>
/// 添加, 这里可以人工干预，提高程序的性能
/// </summary>
/// <param name="entity">实体</param>
/// <param name="identity">自增量方式，表主键是否采用自增的策略</param>
/// <param name="returnId">返回主键，不返回程序允许速度会快，主要是为了主细表批量插入数据优化用的</param>
/// <returns>主键</returns>
public string Add(ZtoPrintBillEntity entity, bool identity = false, bool returnId = false)
{
this.Identity = identity;
this.ReturnId = returnId;
return(this.AddObject(entity));
}
/// <summary>
/// 更新修改记录
/// </summary>
/// <param name="oldShow"> </param>
/// <param name="newShow"> </param>
public void UpdateModifyRecord(ZtoPrintBillEntity oldShow, ZtoPrintBillEntity newShow, string tableName = null)
{
if (string.IsNullOrEmpty(tableName))
{
tableName = this.CurrentTableName + "_LOG";
}
BaseModifyRecordManager manager = new BaseModifyRecordManager(DbHelper, this.UserInfo, tableName);
foreach (var property in typeof(ZtoPrintBillEntity).GetProperties())
{
var fieldDescription = property.GetCustomAttributes(typeof(FieldDescription), false).FirstOrDefault() as FieldDescription;
var oldValue = Convert.ToString(property.GetValue(oldShow, null));
var newValue = Convert.ToString(property.GetValue(newShow, null));
if (!fieldDescription.NeedLog || oldValue == newValue)
{
continue;
}
var record = new BaseModifyRecordEntity();
record.ColumnCode = property.Name.ToUpper();
record.ColumnDescription = fieldDescription.Text;
record.NewValue = newValue;
record.OldValue = oldValue;
record.TableCode = ZtoPrintBillEntity.TableName.ToUpper();
record.TableDescription = FieldExtensions.ToDescription(typeof(ZtoPrintBillEntity), "TableName");
record.RecordKey = oldShow.Id.ToString();
record.IPAddress = DotNet.Business.Utilities.GetIPAddress(true);
record.CreateBy = UserInfo.RealName;
record.CreateOn = DateTime.Now;
manager.Add(record, true, false);
}
}
/// <summary>
/// 窗体加载
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void FrmAddZto180ElecBill_Load(object sender, EventArgs e)
{
// 到付和代收不可以编辑的还有单号也不能自己填写的
myEnterBillControl1.txtToPayMent.Enabled = false;
myEnterBillControl1.txtGoodsPayment.Enabled = false;
myEnterBillControl1.txtBillCode.Enabled = false;
var result = BillPrintHelper.GetLoadDefaultSendMan();
if (!string.IsNullOrEmpty(result))
{
if (result == "1")
{
myEnterBillControl1.txtReceiveMan.Focus();
myEnterBillControl1.txtReceiveMan.Select();
}
}
if (!string.IsNullOrEmpty(SelectedId))
{
this.Text = @"编辑申通普通电子面单";
myEnterBillControl1.PrintBillId = SelectedId;
// 绑定收发件人的信息
ZtoPrintBillEntity billEntity = _printBillManager.GetObject(SelectedId);
myEnterBillControl1.txtSendMan.Text = billEntity.SendMan;
myEnterBillControl1.txtSendPhone.Text = billEntity.SendPhone;
myEnterBillControl1.txtSendCompany.Text = billEntity.SendCompany;
myEnterBillControl1.txtSendAddress.Text = billEntity.SendAddress;
myEnterBillControl1.dgvSendArea.Text = string.Format("{0}-{1}-{2}", billEntity.SendProvince, billEntity.SendCity, billEntity.SendCounty).Replace(" ", "");
myEnterBillControl1.txtReceiveMan.Text = billEntity.ReceiveMan;
myEnterBillControl1.txtReceivePhone.Text = billEntity.ReceivePhone;
myEnterBillControl1.txtReceiveCompany.Text = billEntity.ReceiveCompany;
myEnterBillControl1.txtReceiveAddress.Text = billEntity.ReceiveAddress;
myEnterBillControl1.txtBigPen.Text = billEntity.BigPen;
myEnterBillControl1.dgvReceiveArea.Text = string.Format("{0}-{1}-{2}", billEntity.ReceiveProvince, billEntity.ReceiveCity, billEntity.ReceiveCounty).Replace(" ", "");
myEnterBillControl1.cmbGoodsName.Text = billEntity.GoodsName;
myEnterBillControl1.txtGoodsWeight.Text = billEntity.Weight;
myEnterBillControl1.txtRemark.Text = billEntity.Remark;
myEnterBillControl1.txtOrderNumber.Text = billEntity.OrderNumber;
myEnterBillControl1.txtBillCode.Text = billEntity.BillCode;
// 这里防止重复获取，订单号一样，重复获取没关系啊，除非你改了订单号
if (!string.IsNullOrEmpty(myEnterBillControl1.txtBillCode.Text))
{
myEnterBillControl1.btnGetZtoElecBill.Enabled = false;
myEnterBillControl1.txtOrderNumber.Enabled = false;
}
else
{
myEnterBillControl1.btnGetZtoElecBill.Enabled = true;
myEnterBillControl1.txtOrderNumber.Enabled = true;
}
if (!string.IsNullOrEmpty(billEntity.SendDate))
{
myEnterBillControl1.txtSendDate.Text = BaseBusinessLogic.ConvertToDateToString(billEntity.SendDate);
}
myEnterBillControl1.txtSendMan.Select(0, 0);
myEnterBillControl1.txtSendMan.Focus();
}
}
/// <summary>
/// 批量打印发件人
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void BtnPrintSendManClick(object sender, EventArgs e)
{
if (gvSendMan.RowCount > 0)
{
var list = GetCheckedUserRecord(gvSendMan);
if (list.Any())
{
_list = new List <ZtoPrintBillEntity>();
foreach (ZtoUserEntity userEntity in list)
{
var printBillEntity = new ZtoPrintBillEntity
{
SendMan = userEntity.Realname,
SendProvince = userEntity.Province,
SendCity = userEntity.City,
SendCounty = userEntity.County,
SendPhone = userEntity.Mobile + " " + userEntity.TelePhone
};
var tempAddress = userEntity.Address;
if (!string.IsNullOrEmpty(tempAddress))
{
if (!string.IsNullOrEmpty(printBillEntity.SendProvince))
{
tempAddress = tempAddress.Replace(printBillEntity.SendProvince, "");
}
if (!string.IsNullOrEmpty(printBillEntity.SendCounty))
{
tempAddress = tempAddress.Replace(printBillEntity.SendCounty, "");
}
if (!string.IsNullOrEmpty(printBillEntity.SendCity))
{
tempAddress = tempAddress.Replace(printBillEntity.SendCity, "");
}
}
if (ckTodaySend.Checked)
{
printBillEntity.SendDate = DateTime.Now.ToString(BaseSystemInfo.DateFormat);
}
printBillEntity.SendAddress = printBillEntity.SendProvince + printBillEntity.SendCity + printBillEntity.SendCounty + tempAddress;
printBillEntity.SendCompany = userEntity.Company;
printBillEntity.SendDeparture = userEntity.Department;
printBillEntity.SendPostcode = userEntity.Postcode;
_list.Add(printBillEntity);
}
GreatReport();
_report.PrintPreview(true);
}
else
{
XtraMessageBox.Show(@"请选择发件人数据。", AppMessage.MSG0000, MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
else
{
XtraMessageBox.Show(@"请添加发件人数据。", AppMessage.MSG0000, MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
/// <summary>
/// 更新实体
/// </summary>
/// <param name="entity">实体</param>
public int UpdateObject(ZtoPrintBillEntity entity)
{
SQLBuilder sqlBuilder = new SQLBuilder(DbHelper);
sqlBuilder.BeginUpdate(this.CurrentTableName);
this.SetObject(sqlBuilder, entity);
sqlBuilder.SetDBNow(ZtoPrintBillEntity.FieldModifiedOn);
sqlBuilder.SetWhere(this.PrimaryKey, entity.Id);
return(sqlBuilder.EndUpdate());
}
/// <summary>
/// 构建打印实体
/// </summary>
/// <returns></returns>
private ZtoPrintBillEntity BuildPrintBillEntity()
{
var printBillEntity = new ZtoPrintBillEntity
{
SendMan = txtSendMan.Text.Trim(),
SendDeparture = txtSendDeparture.Text.Trim(),
SendAddress = txtSendAddress.Text.Trim(),
SendPhone = txtSendPhone.Text.Trim(),
SendCompany = txtSendCompany.Text.Trim(),
SendDate = "",
ReceiveMan = txtReceiveMan.Text.Trim(),
ReceiveDestination = txtReceiveDestination.Text.Trim(),
ReceiveAddress = txtReceiveAddress.Text.Trim(),
ReceiveCompany = txtReceiveCompany.Text.Trim(),
ReceivePhone = txtReceivePhone.Text.Trim(),
TotalNumber = string.IsNullOrEmpty(txtNumber.Text.Trim()) ? "" : txtNumber.Text,
Remark = txtRemark.Text.Trim(),
Weight = string.IsNullOrEmpty(txtWeight.Text.Trim()) ? "" : txtWeight.Text,
TranFee = "",
GoodsName = txtGoodsName.Text,
};
if (ckTodaySend.Checked)
{
printBillEntity.SendDate = DateTime.Now.ToString(BaseSystemInfo.DateFormat);
}
else
{
printBillEntity.SendDate = txtSendDate.Text;
}
if (!string.IsNullOrEmpty(dgvSearchSendArea.Text.Trim()))
{
var sendAreaArray = dgvSearchSendArea.Text.Split('-');
printBillEntity.SendProvince = sendAreaArray[0];
printBillEntity.SendCity = sendAreaArray[1];
printBillEntity.SendCounty = sendAreaArray[2];
}
if (!string.IsNullOrEmpty(dgvSearchReceiveArea.Text.Trim()))
{
var receiveAreaArray = dgvSearchReceiveArea.Text.Split('-');
printBillEntity.ReceiveProvince = receiveAreaArray[0];
printBillEntity.ReceiveCity = receiveAreaArray[1];
printBillEntity.ReceiveCounty = receiveAreaArray[2];
}
printBillEntity.BigPen = txtPrintMark.Text.Trim();
return(printBillEntity);
}
/// <summary>
/// 设置实体
/// </summary>
/// <param name="entity">实体</param>
private void SetObject(SQLBuilder sqlBuilder, ZtoPrintBillEntity entity, string dataSource = "0")
{
SetObjectExpand(sqlBuilder, entity);
sqlBuilder.SetValue(ZtoPrintBillEntity.FieldSendPostcode, entity.SendPostcode);
sqlBuilder.SetValue(ZtoPrintBillEntity.FieldReceiveMan, entity.ReceiveMan);
sqlBuilder.SetValue(ZtoPrintBillEntity.FieldReceiveProvince, entity.ReceiveProvince);
sqlBuilder.SetValue(ZtoPrintBillEntity.FieldCreateUserName, entity.CreateUserName);
sqlBuilder.SetValue(ZtoPrintBillEntity.FieldModifiedSite, entity.ModifiedSite);
sqlBuilder.SetValue(ZtoPrintBillEntity.FieldModifiedUserName, entity.ModifiedUserName);
sqlBuilder.SetValue(ZtoPrintBillEntity.FieldPaymentType, entity.PaymentType);
sqlBuilder.SetValue(ZtoPrintBillEntity.FieldLength, entity.Length);
sqlBuilder.SetValue(ZtoPrintBillEntity.FieldSendMan, entity.SendMan);
sqlBuilder.SetValue(ZtoPrintBillEntity.FieldReceiveAddress, entity.ReceiveAddress);
sqlBuilder.SetValue(ZtoPrintBillEntity.FieldReceivePostcode, entity.ReceivePostcode);
sqlBuilder.SetValue(ZtoPrintBillEntity.FieldReceivePhone, entity.ReceivePhone);
sqlBuilder.SetValue(ZtoPrintBillEntity.FieldSendDepartment, entity.SendDepartment);
sqlBuilder.SetValue(ZtoPrintBillEntity.FieldSendDate, entity.SendDate);
sqlBuilder.SetValue(ZtoPrintBillEntity.FieldSendProvince, entity.SendProvince);
sqlBuilder.SetValue(ZtoPrintBillEntity.FieldTranFee, entity.TranFee);
sqlBuilder.SetValue(ZtoPrintBillEntity.FieldSendDeparture, entity.SendDeparture);
sqlBuilder.SetValue(ZtoPrintBillEntity.FieldSendPhone, entity.SendPhone);
sqlBuilder.SetValue(ZtoPrintBillEntity.FieldSendCity, entity.SendCity);
sqlBuilder.SetValue(ZtoPrintBillEntity.FieldGoodsName, entity.GoodsName);
sqlBuilder.SetValue(ZtoPrintBillEntity.FieldWeight, entity.Weight);
sqlBuilder.SetValue(ZtoPrintBillEntity.FieldHeight, entity.Height);
sqlBuilder.SetValue(ZtoPrintBillEntity.FieldReceiveCounty, entity.ReceiveCounty);
sqlBuilder.SetValue(ZtoPrintBillEntity.FieldReceiveDestination, entity.ReceiveDestination);
sqlBuilder.SetValue(ZtoPrintBillEntity.FieldSendCompany, entity.SendCompany);
sqlBuilder.SetValue(ZtoPrintBillEntity.FieldBillCode, entity.BillCode);
sqlBuilder.SetValue(ZtoPrintBillEntity.FieldTotalNumber, entity.TotalNumber);
sqlBuilder.SetValue(ZtoPrintBillEntity.FieldRemark, entity.Remark);
sqlBuilder.SetValue(ZtoPrintBillEntity.FieldCreateSite, entity.CreateSite);
sqlBuilder.SetValue(ZtoPrintBillEntity.FieldSendSite, entity.SendSite);
sqlBuilder.SetValue(ZtoPrintBillEntity.FieldWidth, entity.Width);
sqlBuilder.SetValue(ZtoPrintBillEntity.FieldReceiveCity, entity.ReceiveCity);
sqlBuilder.SetValue(ZtoPrintBillEntity.FieldSendAddress, entity.SendAddress);
sqlBuilder.SetValue(ZtoPrintBillEntity.FieldSendCounty, entity.SendCounty);
sqlBuilder.SetValue(ZtoPrintBillEntity.FieldReceiveCompany, entity.ReceiveCompany);
sqlBuilder.SetValue(ZtoPrintBillEntity.FieldBigPen, entity.BigPen);
sqlBuilder.SetValue(ZtoPrintBillEntity.FieldOrderNumber, entity.OrderNumber);
sqlBuilder.SetValue(ZtoPrintBillEntity.FieldExpressId, entity.ExpressId);
sqlBuilder.SetValue(ZtoPrintBillEntity.FieldGoodsPayMent, entity.GOODS_PAYMENT);
sqlBuilder.SetValue(ZtoPrintBillEntity.FieldToPayMent, entity.TOPAYMENT);
if (this.CurrentTableName == "ZTO_RECYCLE_BILL")
{
sqlBuilder.SetValue("DATA_SOURCE", dataSource);
}
}
private ZtoPrintBillEntity BuildPrintEntity()
{
//构建实体
ZtoPrintBillEntity printBillEntity = new ZtoPrintBillEntity();
if (!string.IsNullOrEmpty(PrintBillId))
{
printBillEntity = new ZtoPrintBillManager(BillPrintHelper.DbHelper).GetObject(PrintBillId);
}
printBillEntity.SendMan = txtSendMan.Text;
printBillEntity.SendPhone = txtSendPhone.Text;
printBillEntity.SendCompany = txtSendCompany.Text;
printBillEntity.SendAddress = txtSendAddress.Text;
printBillEntity.SendDate = string.IsNullOrEmpty(txtSendDate.Text) ? DateTime.Now.ToString(BaseSystemInfo.DateFormat) : txtSendDate.Text;
if (!string.IsNullOrEmpty(dgvSendArea.Text))
{
var sendAreaArray = dgvSendArea.Text.Split('-');
printBillEntity.SendProvince = sendAreaArray[0];
printBillEntity.SendCity = sendAreaArray[1];
printBillEntity.SendCounty = sendAreaArray[2];
}
printBillEntity.ReceiveMan = txtReceiveMan.Text;
printBillEntity.ReceivePhone = txtReceivePhone.Text;
printBillEntity.ReceiveCompany = txtReceiveCompany.Text;
printBillEntity.ReceiveAddress = txtReceiveAddress.Text;
if (!string.IsNullOrEmpty(dgvReceiveArea.Text))
{
var receiveAreaArray = dgvReceiveArea.Text.Split('-');
printBillEntity.ReceiveProvince = receiveAreaArray[0];
printBillEntity.ReceiveCity = receiveAreaArray[1];
printBillEntity.ReceiveCounty = receiveAreaArray[2];
}
printBillEntity.GoodsName = cmbGoodsName.Text;
printBillEntity.Weight = txtGoodsWeight.Text;
printBillEntity.GOODS_PAYMENT = string.IsNullOrEmpty(txtGoodsPayment.Text) ? 0 : decimal.Parse(txtGoodsPayment.Text);
printBillEntity.TOPAYMENT = string.IsNullOrEmpty(txtToPayMent.Text) ? 0 : decimal.Parse(txtToPayMent.Text);
printBillEntity.Remark = txtRemark.Text;
printBillEntity.BigPen = txtBigPen.Text;
// 2016年6月18日11:19:58 杨恒连加上
printBillEntity.OrderNumber = txtOrderNumber.Text;
printBillEntity.BillCode = txtBillCode.Text;
return(printBillEntity);
}
/// <summary>
/// 窗体加载事件
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void FrmAddBill_Load(object sender, EventArgs e)
{
LoadDefaultData();
BindArea();
var result = BillPrintHelper.GetLoadDefaultSendMan();
if (!string.IsNullOrEmpty(result))
{
if (result == "1")
{
ckGetDefaultSendMan.Checked = true;
ckGetDefaultSendMan_CheckedChanged(this, null);
txtReceiveMan.Focus();
txtReceiveMan.Select();
}
}
if (!string.IsNullOrEmpty(SelectedId))
{
this.Text = @"编辑圆通运单信息";
// 绑定收发件人的信息
ZtoPrintBillEntity billEntity = _printBillManager.GetObject(SelectedId);
txtSendMan.Text = billEntity.SendMan;
txtSendPhone.Text = billEntity.SendPhone;
txtSendDeparture.Text = billEntity.SendDeparture;
txtSendCompany.Text = billEntity.SendCompany;
txtSendAddress.Text = billEntity.SendAddress;
dgvSearchSendArea.Text = string.Format("{0}-{1}-{2}", billEntity.SendProvince, billEntity.SendCity,
billEntity.SendCounty).Replace(" ", "");
txtReceiveMan.Text = billEntity.ReceiveMan;
txtReceivePhone.Text = billEntity.ReceivePhone;
txtReceiveDestination.Text = billEntity.ReceiveDestination;
txtReceiveCompany.Text = billEntity.ReceiveCompany;
txtReceiveAddress.Text = billEntity.ReceiveAddress;
txtPrintMark.Text = billEntity.BigPen;
dgvSearchReceiveArea.Text = string.Format("{0}-{1}-{2}", billEntity.ReceiveProvince,
billEntity.ReceiveCity, billEntity.ReceiveCounty).Replace(" ", "");
}
_report.Initialize += ReportInitialize;
_report.FetchRecord += ReportFetchRecord;
}
/// <summary>
/// 导入Excel数据到本地数据库
/// </summary>
public bool Import()
{
if (string.IsNullOrEmpty(txtFileFullPath.Text.Trim()))
{
XtraMessageBox.Show(@"请选择录单模板", AppMessage.MSG0000, MessageBoxButtons.OK, MessageBoxIcon.Information);
btnOpenExcel_Click(this, null);
return(false);
}
if (!File.Exists(txtFileFullPath.Text))
{
XtraMessageBox.Show(@"选中文件不存在，请重新选择导入Excel文件", AppMessage.MSG0000, MessageBoxButtons.OK, MessageBoxIcon.Information);
btnOpenExcel_Click(this, null);
return(false);
}
var startDateTime = DateTime.Now;
StartDt = startDateTime;
if (!splashScreenManagerImportExcel.IsSplashFormVisible)
{
splashScreenManagerImportExcel.ShowWaitForm();
}
Application.DoEvents();
splashScreenManagerImportExcel.SetWaitFormCaption("请稍后");
splashScreenManagerImportExcel.SetWaitFormDescription("开始导入Excel数据...");
try
{
DataTable chooseDt = ExcelHelper.ExcelToDataTable(txtFileFullPath.Text.Trim(), 38, 0, 3);
if (chooseDt != null && chooseDt.Rows.Count > 0)
{
var list = new List <ZtoPrintBillEntity>();
int temp = 0;
var defaultUserList = new ZtoUserManager(BillPrintHelper.DbHelper).GetList <ZtoUserEntity>(new KeyValuePair <string, object>(ZtoUserEntity.FieldIsDefault, 1), new KeyValuePair <string, object>(ZtoUserEntity.FieldIssendorreceive, 1));
ZtoUserEntity defaultUserEntity = null;
if (defaultUserList.Any())
{
defaultUserEntity = defaultUserList.First();
}
foreach (DataRow dr in chooseDt.Rows)
{
++temp;
splashScreenManagerImportExcel.SetWaitFormDescription(string.Format("正在导入Excel数据：{0}/{1}", temp, chooseDt.Rows.Count));
ZtoPrintBillEntity entity = new ZtoPrintBillEntity();
if (ckTodaySend.Checked)
{
entity.SendDate = DateTime.Now.ToString(BaseSystemInfo.DateFormat);
}
if (ckUserDefaultSendMan.Checked)
{
if (defaultUserEntity != null)
{
entity.SendMan = defaultUserEntity.Realname;
entity.SendPhone = defaultUserEntity.Mobile + " " + defaultUserEntity.TelePhone;
entity.SendProvince = defaultUserEntity.Province;
entity.SendCity = defaultUserEntity.City;
entity.SendCounty = defaultUserEntity.County;
entity.SendAddress = defaultUserEntity.Address;
entity.SendSite = "";
entity.SendDeparture = entity.SendProvince;
entity.SendCompany = defaultUserEntity.Company;
entity.SendDepartment = defaultUserEntity.Department;
entity.SendPostcode = defaultUserEntity.Postcode;
}
}
else
{
if (this.Tag != null)
{
var sendUserEntity = this.Tag as ZtoUserEntity;
// 表示选择了一个发件人的信息，这样也不用读取Excel里面的发件人了
if (sendUserEntity != null)
{
entity.SendMan = sendUserEntity.Realname;
entity.SendPhone = sendUserEntity.Mobile + " " + sendUserEntity.TelePhone;
entity.SendProvince = sendUserEntity.Province;
entity.SendCity = sendUserEntity.City;
entity.SendCounty = sendUserEntity.County;
entity.SendAddress = sendUserEntity.Address;
entity.SendSite = "";
entity.SendDeparture = sendUserEntity.Province;
entity.SendCompany = sendUserEntity.Company;
entity.SendDepartment = sendUserEntity.Department;
entity.SendPostcode = sendUserEntity.Postcode;
}
}
else
{
entity.SendMan = BaseBusinessLogic.ConvertToString(dr[2]);
entity.SendPhone = BaseBusinessLogic.ConvertToString(dr[3]);
entity.SendProvince = BaseBusinessLogic.ConvertToString(dr[4]);
entity.SendCity = BaseBusinessLogic.ConvertToString(dr[5]);
entity.SendCounty = BaseBusinessLogic.ConvertToString(dr[6]);
entity.SendAddress = BaseBusinessLogic.ConvertToString(dr[7]);
entity.SendSite = "";
entity.SendDeparture = BaseBusinessLogic.ConvertToString(dr[26]);
if (string.IsNullOrEmpty(entity.SendDeparture))
{
entity.SendDeparture = entity.SendProvince;
}
entity.SendCompany = BaseBusinessLogic.ConvertToString(dr[27]);
entity.SendDepartment = BaseBusinessLogic.ConvertToString(dr[28]);
entity.SendPostcode = BaseBusinessLogic.ConvertToString(dr[29]);
}
}
entity.ReceiveMan = BaseBusinessLogic.ConvertToString(dr[8]);
entity.ReceivePhone = BaseBusinessLogic.ConvertToString(dr[9]);
entity.ReceiveProvince = BaseBusinessLogic.ConvertToString(dr[10]);
entity.ReceiveCity = BaseBusinessLogic.ConvertToString(dr[11]);
entity.ReceiveCounty = BaseBusinessLogic.ConvertToString(dr[12]);
entity.ReceiveAddress = BaseBusinessLogic.ConvertToString(dr[13]);
entity.ReceiveDestination = BaseBusinessLogic.ConvertToString(dr[30]);
if (string.IsNullOrEmpty(entity.ReceiveDestination))
{
entity.ReceiveDestination = entity.ReceiveProvince;
}
entity.ReceiveCompany = BaseBusinessLogic.ConvertToString(dr[31]);
entity.ReceivePostcode = BaseBusinessLogic.ConvertToString(dr[32]);
entity.GoodsName = BaseBusinessLogic.ConvertToString(dr[14]);
entity.Weight = BaseBusinessLogic.ConvertToString(dr[15]);
entity.TranFee = BaseBusinessLogic.ConvertToString(dr[16]);
entity.GOODS_PAYMENT = BaseBusinessLogic.ConvertToDecimal(dr[17]);
entity.TOPAYMENT = BaseBusinessLogic.ConvertToDecimal(dr[18]);
entity.Length = BaseBusinessLogic.ConvertToString(dr[33]);
entity.Width = BaseBusinessLogic.ConvertToString(dr[34]);
entity.Height = BaseBusinessLogic.ConvertToString(dr[35]);
entity.TotalNumber = BaseBusinessLogic.ConvertToString(dr[36]);
entity.OrderNumber = BaseBusinessLogic.ConvertToString(dr[37]);
entity.Remark = BaseBusinessLogic.ConvertToString(dr[22]);
entity.CreateUserName = "";
entity.CreateSite = "";
entity.CreateOn = DateTime.Now;
entity.PaymentType = "现金";
// 如果Excel里面没有填写订单号系统自动生成一个订单号，这样提取电子面单单号就不用怕了，2016-1-23 14:07:12
if (string.IsNullOrEmpty(entity.OrderNumber))
{
// 导入自动生成订单号（电子面单）79170-南昌昌南 18779176845 这个qq提供的思路，2016-1-20 20:08:50
entity.OrderNumber = Guid.NewGuid().ToString("N").ToLower();
}
if (!ckGetServerPrintMark.Checked)
{
entity.BigPen = string.Format("{0} {1} {2}", entity.ReceiveProvince, entity.ReceiveCity, entity.ReceiveCounty);
}
else
{
entity.BigPen = "";
}
list.Add(entity);
}
if (!ckGetServerPrintMark.Checked)
{
var manager = new ZtoPrintBillManager(BillPrintHelper.DbHelper);
foreach (ZtoPrintBillEntity ztoPrintBillEntity in list)
{
manager.Add(ztoPrintBillEntity, true);
}
if (splashScreenManagerImportExcel != null && splashScreenManagerImportExcel.IsSplashFormVisible)
{
splashScreenManagerImportExcel.CloseWaitForm();
}
GridDataBind();
var ts = DateTime.Now - startDateTime;
lblTime.Text = string.Format("耗时:{0}时{1}分{2}秒{3}毫秒", ts.Hours, ts.Minutes, ts.Seconds, ts.Milliseconds);
Close();
}
else
{
splashScreenManagerImportExcel.SetWaitFormDescription("正在联网获取大头笔信息，请稍后......");
// 开线程去读取大头笔的
CheckBillCode(list);
}
}
else
{
XtraMessageBox.Show(@"模板没有填写任何数据，导入失败", AppMessage.MSG0000, MessageBoxButtons.OK, MessageBoxIcon.Error);
return(false);
}
}
catch (Exception ex)
{
ProcessException(ex);
return(false);
}
finally
{
if (splashScreenManagerImportExcel != null && splashScreenManagerImportExcel.IsSplashFormVisible)
{
splashScreenManagerImportExcel.CloseWaitForm();
}
}
return(true);
}
/// <summary>
/// 线程执行校验单号函数
/// </summary>
/// <param name="updateBillItem"></param>
public void CheckBillList(object updateBillItem)
{
var item = updateBillItem as LoadPrintMarkEntity;
try
{
if (item != null)
{
// 循环次数 65 2
var length = item.PrintBillEntities.Count > 50 ? Convert.ToInt32(Math.Ceiling(item.PrintBillEntities.Count / 50.0)) : 1;
// 每次循环单号个数 33
var listNo = item.PrintBillEntities.Count / length;
for (int i = 1; i < length + 1; i++)
{
List <ZtoPrintBillEntity> billCodeListSend;
if (i == 1)
{
billCodeListSend = item.PrintBillEntities.Skip((i - 1) * listNo).Take(listNo + 1).ToList();
}
else
{
billCodeListSend = item.PrintBillEntities.Skip((i - 1) * listNo + i - 1).Take(listNo + 1).ToList();
}
// 获取发件人的省市区
foreach (ZtoPrintBillEntity ztoPrintBillEntity in billCodeListSend)
{
if (string.IsNullOrEmpty(ztoPrintBillEntity.SendProvince) && string.IsNullOrEmpty(ztoPrintBillEntity.SendCity) && string.IsNullOrEmpty(ztoPrintBillEntity.SendCounty))
{
if (!string.IsNullOrEmpty(ztoPrintBillEntity.SendAddress))
{
var baiAddressEntity = BaiduMapHelper.GetProvCityDistFromBaiduMap(ztoPrintBillEntity.SendAddress);
if (baiAddressEntity != null)
{
ztoPrintBillEntity.SendProvince = baiAddressEntity.Result.AddressComponent.Province;
ztoPrintBillEntity.SendCity = baiAddressEntity.Result.AddressComponent.City;
ztoPrintBillEntity.SendCounty = baiAddressEntity.Result.AddressComponent.District;
ZtoPrintBillEntity entity = ztoPrintBillEntity;
marqueeProgressBarControl1.BeginInvoke(new Action(() =>
{
marqueeProgressBarControl1.Text = string.Format("正在获取发件人省市区({0}-{1}-{2}),数据加载中,请稍后...", entity.SendProvince, entity.SendCity, entity.SendCounty);
}));
}
}
}
}
// 获取收件人的省市区
foreach (ZtoPrintBillEntity ztoPrintBillEntity in billCodeListSend)
{
if (string.IsNullOrEmpty(ztoPrintBillEntity.ReceiveProvince) && string.IsNullOrEmpty(ztoPrintBillEntity.ReceiveCity) && string.IsNullOrEmpty(ztoPrintBillEntity.ReceiveCounty))
{
if (!string.IsNullOrEmpty(ztoPrintBillEntity.ReceiveAddress))
{
var baiAddressEntity = BaiduMapHelper.GetProvCityDistFromBaiduMap(ztoPrintBillEntity.ReceiveAddress);
if (baiAddressEntity != null)
{
ztoPrintBillEntity.ReceiveProvince = baiAddressEntity.Result.AddressComponent.Province;
ztoPrintBillEntity.ReceiveCity = baiAddressEntity.Result.AddressComponent.City;
ztoPrintBillEntity.ReceiveCounty = baiAddressEntity.Result.AddressComponent.District;
ZtoPrintBillEntity entity = ztoPrintBillEntity;
marqueeProgressBarControl1.BeginInvoke(new Action(() =>
{
marqueeProgressBarControl1.Text = string.Format("正在获取收件人省市区({0}-{1}-{2}),数据加载中,请稍后...", entity.ReceiveProvince, entity.ReceiveCity, entity.ReceiveCounty);
}));
}
}
}
}
// 绑定大头笔信息
foreach (ZtoPrintBillEntity ztoPrintBillEntity in billCodeListSend)
{
// 如果大头笔已经有了就不用联网获取了
var selectedRemark = new List <string> {
ztoPrintBillEntity.SendProvince, ztoPrintBillEntity.SendCity, ztoPrintBillEntity.SendCounty
};
var selectedReceiveMark = new List <string> {
ztoPrintBillEntity.ReceiveProvince, ztoPrintBillEntity.ReceiveCity, ztoPrintBillEntity.ReceiveCounty
};
var printMark = BillPrintHelper.GetRemaike(string.Join(",", selectedRemark), ztoPrintBillEntity.SendAddress, string.Join(",", selectedReceiveMark), ztoPrintBillEntity.ReceiveAddress);
ztoPrintBillEntity.BigPen = printMark;
PrintBillEntities.Add(ztoPrintBillEntity);
ZtoPrintBillEntity entity = ztoPrintBillEntity;
marqueeProgressBarControl1.BeginInvoke(new Action(() =>
{
marqueeProgressBarControl1.Text = string.Format("正在获取大头笔({0}),数据加载中,请稍后...", entity.BigPen);
}));
}
BillCodeIndex += billCodeListSend.Count;
//指定委托方法
CheckDelegate refresh = Refresh;
Invoke(refresh, item.Code);
}
}
}
catch (Exception ex)
{
ProcessException(ex);
}
}
/// <summary>
/// 导入Excel数据到本地数据库
/// </summary>
public bool Import()
{
if (string.IsNullOrEmpty(txtFileFullPath.Text.Trim()))
{
XtraMessageBox.Show(@"请选择淘宝订单Excel", AppMessage.MSG0000, MessageBoxButtons.OK, MessageBoxIcon.Information);
btnOpenExcel_Click(this, null);
return(false);
}
if (!File.Exists(txtFileFullPath.Text))
{
XtraMessageBox.Show(@"选中文件不存在，请重新选择导入Excel文件", AppMessage.MSG0000, MessageBoxButtons.OK, MessageBoxIcon.Information);
btnOpenExcel_Click(this, null);
return(false);
}
#region 检查是否选择了发件人
ZtoUserEntity defaultUserEntity = null;
if (ckUserDefaultSendMan.Checked)
{
// 获取到默认的发件人
var defaultUserList = new ZtoUserManager(BillPrintHelper.DbHelper).GetList <ZtoUserEntity>(new KeyValuePair <string, object>(ZtoUserEntity.FieldIsDefault, 1), new KeyValuePair <string, object>(ZtoUserEntity.FieldIssendorreceive, 1));
if (defaultUserList.Any())
{
defaultUserEntity = defaultUserList.FirstOrDefault();
if (defaultUserEntity == null)
{
XtraMessageBox.Show(@"请添加一个默认的发件人，然后再导入订单数据", AppMessage.MSG0000, MessageBoxButtons.OK, MessageBoxIcon.Information);
return(false);
}
}
else
{
XtraMessageBox.Show(@"请添加一个默认的发件人，然后再导入订单数据", AppMessage.MSG0000, MessageBoxButtons.OK, MessageBoxIcon.Information);
return(false);
}
}
else
{
if (this.Tag != null)
{
defaultUserEntity = this.Tag as ZtoUserEntity;
// 表示选择了一个发件人的信息，这样也不用读取Excel里面的发件人了
if (defaultUserEntity == null)
{
XtraMessageBox.Show(@"请重新选择一个发件人，然后再导入订单数据", AppMessage.MSG0000, MessageBoxButtons.OK, MessageBoxIcon.Information);
ckChooseSendMan.Checked = true;
Import();
}
}
else
{
XtraMessageBox.Show(@"请选择一个发件人，然后再导入订单数据", AppMessage.MSG0000, MessageBoxButtons.OK, MessageBoxIcon.Information);
ckChooseSendMan.Checked = true;
Import();
}
}
#endregion
var startDateTime = DateTime.Now;
StartDt = startDateTime;
if (!splashScreenManagerImportExcel.IsSplashFormVisible)
{
splashScreenManagerImportExcel.ShowWaitForm();
}
Application.DoEvents();
splashScreenManagerImportExcel.SetWaitFormCaption("请稍后");
splashScreenManagerImportExcel.SetWaitFormDescription("开始导入淘宝订单Excel数据...");
try
{
DataTable chooseDt;
if (Path.GetExtension(txtFileFullPath.Text) == ".csv")
{
var readCsv = new ReadCsvHelper(txtFileFullPath.Text);
readCsv.CreateTable();
chooseDt = readCsv.GetResoultTable();
}
else
{
chooseDt = ExcelHelper.ExcelToDataTable(txtFileFullPath.Text, 0, null);
}
if (chooseDt != null && chooseDt.Rows.Count > 0)
{
var list = new List <ZtoPrintBillEntity>();
int temp = 0;
foreach (DataRow dr in chooseDt.Rows)
{
++temp;
splashScreenManagerImportExcel.SetWaitFormDescription(string.Format("正在导入Excel数据：{0}/{1}", temp, chooseDt.Rows.Count));
var entity = new ZtoPrintBillEntity();
if (ckTodaySend.Checked)
{
entity.SendDate = DateTime.Now.ToString(BaseSystemInfo.DateFormat);
}
if (defaultUserEntity != null)
{
entity.SendMan = defaultUserEntity.Realname;
entity.SendPhone = defaultUserEntity.Mobile + " " + defaultUserEntity.TelePhone;
entity.SendProvince = defaultUserEntity.Province;
entity.SendCity = defaultUserEntity.City;
entity.SendCounty = defaultUserEntity.County;
entity.SendAddress = defaultUserEntity.Address;
entity.SendCompany = defaultUserEntity.Company;
entity.SendDepartment = defaultUserEntity.Department;
entity.SendPostcode = defaultUserEntity.Postcode;
}
entity.SendSite = "";
entity.SendDeparture = entity.SendProvince;
entity.ReceiveMan = BaseBusinessLogic.ConvertToString(dr[12]);
entity.ReceivePhone = BaseBusinessLogic.ConvertToString(dr[16]);
entity.ReceiveProvince = "";
entity.ReceiveCity = "";
entity.ReceiveCounty = "";
entity.ReceiveAddress = BaseBusinessLogic.ConvertToString(dr[13]).Replace(" ", "");
// 目的地
entity.ReceiveDestination = "";
if (string.IsNullOrEmpty(entity.ReceiveDestination))
{
entity.ReceiveDestination = entity.ReceiveProvince;
}
entity.ReceiveCompany = "";
entity.ReceivePostcode = "";
entity.GoodsName = BaseBusinessLogic.ConvertToString(dr[19]);
entity.Weight = "";
entity.TranFee = "";
entity.GOODS_PAYMENT = 0;
entity.TOPAYMENT = 0;
entity.Length = "";
entity.Width = "";
entity.Height = "";
entity.TotalNumber = "";
entity.OrderNumber = BaseBusinessLogic.ConvertToString(dr[0]);
entity.Remark = BaseBusinessLogic.ConvertToString(dr[23]);
entity.CreateUserName = "";
entity.CreateSite = "";
entity.CreateOn = DateTime.Now;
entity.PaymentType = "";
// 如果Excel里面没有填写订单号系统自动生成一个订单号，这样提取电子面单单号就不用怕了，2016-1-23 14:07:12
if (string.IsNullOrEmpty(entity.OrderNumber))
{
// 导入自动生成订单号（电子面单）79170-南昌昌南 18779176845 这个qq提供的思路，2016-1-20 20:08:50
entity.OrderNumber = Guid.NewGuid().ToString("N").ToLower();
}
if (!ckGetServerPrintMark.Checked)
{
entity.BigPen = string.Format("{0} {1} {2}", entity.ReceiveProvince, entity.ReceiveCity, entity.ReceiveCounty);
}
else
{
entity.BigPen = "";
}
list.Add(entity);
}
if (!ckGetServerPrintMark.Checked)
{
var manager = new ZtoPrintBillManager(BillPrintHelper.DbHelper);
foreach (ZtoPrintBillEntity ztoPrintBillEntity in list)
{
manager.Add(ztoPrintBillEntity, true);
}
if (splashScreenManagerImportExcel != null && splashScreenManagerImportExcel.IsSplashFormVisible)
{
splashScreenManagerImportExcel.CloseWaitForm();
}
GridDataBind();
Close();
}
else
{
splashScreenManagerImportExcel.SetWaitFormDescription("正在联网获取大头笔信息，请稍后......");
// 开线程去读取大头笔的
CheckBillCode(list);
}
}
else
{
XtraMessageBox.Show(@"模板没有填写任何数据，导入失败", AppMessage.MSG0000, MessageBoxButtons.OK, MessageBoxIcon.Error);
return(false);
}
}
catch (Exception ex)
{
ProcessException(ex);
return(false);
}
finally
{
if (splashScreenManagerImportExcel != null && splashScreenManagerImportExcel.IsSplashFormVisible)
{
splashScreenManagerImportExcel.CloseWaitForm();
}
}
return(true);
}
// 这个是声明扩展方法 partial void SetObjectExpand(SQLBuilder sqlBuilder, ZtoPrintBillEntity entity);
/// <summary>
/// 添加实体
/// </summary>
/// <param name="entity">实体</param>
public string AddObject(ZtoPrintBillEntity entity, string dataSource = "0")
{
string key = string.Empty;
if (entity.Id != null)
{
key = entity.Id.ToString();
}
SQLBuilder sqlBuilder = new SQLBuilder(DbHelper, this.Identity, this.ReturnId);
sqlBuilder.BeginInsert(this.CurrentTableName, this.PrimaryKey);
if (!this.Identity)
{
// 这里已经是指定了主键了，所以不需要返回主键了
sqlBuilder.ReturnId = false;
sqlBuilder.SetValue(this.PrimaryKey, entity.Id);
}
else
{
if (!this.ReturnId && (DbHelper.CurrentDbType == CurrentDbType.Oracle || DbHelper.CurrentDbType == CurrentDbType.DB2))
{
if (DbHelper.CurrentDbType == CurrentDbType.Oracle)
{
sqlBuilder.SetFormula(this.PrimaryKey, "SEQ_" + this.CurrentTableName.ToUpper() + ".NEXTVAL ");
}
if (DbHelper.CurrentDbType == CurrentDbType.DB2)
{
sqlBuilder.SetFormula(this.PrimaryKey, "NEXT VALUE FOR SEQ_" + this.CurrentTableName.ToUpper());
}
}
else
{
if (this.Identity && (DbHelper.CurrentDbType == CurrentDbType.Oracle || DbHelper.CurrentDbType == CurrentDbType.DB2))
{
BaseSequenceManager sequenceManager = new BaseSequenceManager(DbHelper);
// entity.Id = sequenceManager.Increment(this.CurrentTableName);
sqlBuilder.SetValue(this.PrimaryKey, entity.Id);
}
}
}
this.SetObject(sqlBuilder, entity, dataSource);
//if (entity.CreateOn.Year != 1)
//{
// sqlBuilder.SetValue(ZtoPrintBillEntity.FieldCreateOn, entity.CreateOn);
//}
//else
//{
sqlBuilder.SetDBNow(ZtoPrintBillEntity.FieldCreateOn);
//}
sqlBuilder.SetDBNow(ZtoPrintBillEntity.FieldModifiedOn);
if (this.Identity && (DbHelper.CurrentDbType == CurrentDbType.SqlServer || DbHelper.CurrentDbType == CurrentDbType.Access))
{
key = sqlBuilder.EndInsert().ToString();
}
else
{
sqlBuilder.EndInsert();
}
if (this.Identity && (DbHelper.CurrentDbType == CurrentDbType.Oracle || DbHelper.CurrentDbType == CurrentDbType.DB2))
{
return(entity.Id.ToString());
}
return(key);
}
/// <summary>
/// 更新
/// </summary>
/// <param name="entity">实体</param>
public int Update(ZtoPrintBillEntity entity)
{
return(this.UpdateObject(entity));
}
/// <summary>
/// 打印多份
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void btnPrintMore_Click(object sender, EventArgs e)
{
try
{
int printNumber;
if (string.IsNullOrEmpty(cmbPrintNumber.Text.Trim()))
{
printNumber = 1;
}
else
{
var result = int.TryParse(cmbPrintNumber.Text, out printNumber);
if (!result)
{
printNumber = 1;
}
}
if (gvReceiveMan.RowCount > 0)
{
ZtoUserEntity defaultSendManEntity = new ZtoUserEntity();
if (ckUserDefaultSendMan.Checked)
{
ZtoUserManager userManager = new ZtoUserManager(BillPrintHelper.DbHelper);
var userList = userManager.GetList <ZtoUserEntity>(new KeyValuePair <string, object>(ZtoUserEntity.FieldIsDefault, 1), new KeyValuePair <string, object>(ZtoUserEntity.FieldIssendorreceive, 1));
defaultSendManEntity = userList.FirstOrDefault();
}
if (defaultSendManEntity == null)
{
if (XtraMessageBox.Show(@"未添加默认发件人信息，请添加默认发件人信息", AppMessage.MSG0000, MessageBoxButtons.OK, MessageBoxIcon.Information) == DialogResult.OK)
{
var addSendMan = new FrmAddSendMan();
addSendMan.ShowDialog();
addSendMan.Dispose();
}
return;
}
var list = GetCheckedUserRecord(gvReceiveMan);
if (list.Any())
{
_list = new List <ZtoPrintBillEntity>();
foreach (ZtoUserEntity userEntity in list)
{
ZtoPrintBillEntity printBillEntity = new ZtoPrintBillEntity
{
ReceiveMan = userEntity.Realname,
ReceiveProvince = userEntity.Province,
ReceiveCity = userEntity.City,
ReceiveCounty = userEntity.County,
ReceivePhone = userEntity.Mobile,
ReceiveAddress = userEntity.Address,
SendDate = DateTime.Now.ToString(BaseSystemInfo.DateFormat)
};
var tempAddress = printBillEntity.ReceiveAddress;
if (!string.IsNullOrEmpty(tempAddress))
{
if (!string.IsNullOrEmpty(printBillEntity.ReceiveProvince))
{
tempAddress = tempAddress.Replace(printBillEntity.ReceiveProvince, "");
}
if (!string.IsNullOrEmpty(printBillEntity.ReceiveCity))
{
tempAddress = tempAddress.Replace(printBillEntity.ReceiveCity, "");
}
if (!string.IsNullOrEmpty(printBillEntity.ReceiveCounty))
{
tempAddress = tempAddress.Replace(printBillEntity.ReceiveCounty, "");
}
}
printBillEntity.ReceiveAddress = printBillEntity.ReceiveProvince +
printBillEntity.ReceiveCity + printBillEntity.ReceiveCounty +
tempAddress;
printBillEntity.ReceiveCompany = userEntity.Company;
printBillEntity.ReceivePostcode = userEntity.Postcode;
if (string.IsNullOrEmpty(printBillEntity.ReceivePhone))
{
printBillEntity.ReceivePhone = userEntity.TelePhone;
}
if (ckUserDefaultSendMan.Checked)
{
printBillEntity.SendMan = defaultSendManEntity.Realname;
printBillEntity.SendPhone = defaultSendManEntity.Mobile + " " + defaultSendManEntity.TelePhone;
printBillEntity.SendProvince = defaultSendManEntity.Province;
printBillEntity.SendCity = defaultSendManEntity.City;
printBillEntity.SendCounty = defaultSendManEntity.County;
printBillEntity.SendAddress = defaultSendManEntity.Address;
printBillEntity.SendSite = "";
printBillEntity.SendDate = DateTime.Now.ToString(BaseSystemInfo.DateFormat);
printBillEntity.SendDeparture = defaultSendManEntity.Province;
printBillEntity.SendCompany = defaultSendManEntity.Company;
printBillEntity.SendDepartment = defaultSendManEntity.Department;
printBillEntity.SendPostcode = defaultSendManEntity.Postcode;
var selectedRemark = new List <string> {
printBillEntity.SendProvince, printBillEntity.SendCity, printBillEntity.SendCounty
};
var selectedReceiveMark = new List <string> {
printBillEntity.ReceiveProvince, printBillEntity.ReceiveCity, printBillEntity.ReceiveCounty
};
var printMark = BillPrintHelper.GetRemaike(string.Join(",", selectedRemark), printBillEntity.SendAddress, string.Join(",", selectedReceiveMark), printBillEntity.ReceiveAddress);
printBillEntity.BigPen = printMark;
}
for (int i = 0; i < printNumber; i++)
{
_list.Add(printBillEntity);
}
}
GreatReport();
_report.PrintPreview(true);
}
else
{
XtraMessageBox.Show(@"请选择收件人数据。", AppMessage.MSG0000, MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
else
{
XtraMessageBox.Show(@"请添加收件人数据。", AppMessage.MSG0000, MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
catch (Exception exception)
{
XtraMessageBox.Show(exception.StackTrace, AppMessage.MSG0000, MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
/// <summary>
/// 导入Excel数据到本地数据库
/// </summary>
public bool Import()
{
if (string.IsNullOrEmpty(txtFileFullPath.Text.Trim()))
{
XtraMessageBox.Show(@"请选择录单模板", AppMessage.MSG0000, MessageBoxButtons.OK, MessageBoxIcon.Information);
btnOpenExcel_Click(this, null);
return(false);
}
if (!File.Exists(txtFileFullPath.Text))
{
XtraMessageBox.Show(@"选中文件不存在，请重新选择导入Excel文件", AppMessage.MSG0000, MessageBoxButtons.OK, MessageBoxIcon.Information);
btnOpenExcel_Click(this, null);
return(false);
}
var startDateTime = DateTime.Now;
StartDt = startDateTime;
if (!splashScreenManagerImportExcel.IsSplashFormVisible)
{
splashScreenManagerImportExcel.ShowWaitForm();
}
Application.DoEvents();
splashScreenManagerImportExcel.SetWaitFormCaption("请稍后");
splashScreenManagerImportExcel.SetWaitFormDescription("开始导入Excel数据...");
try
{
DataTable chooseDt = ExcelHelper.ExcelToDataTable(txtFileFullPath.Text.Trim(), 11, 0, 1);
if (chooseDt != null && chooseDt.Rows.Count > 0)
{
var list = new List <ZtoPrintBillEntity>();
int temp = 0;
var defaultUserList = new ZtoUserManager(BillPrintHelper.DbHelper).GetList <ZtoUserEntity>(new KeyValuePair <string, object>(ZtoUserEntity.FieldIsDefault, 1), new KeyValuePair <string, object>(ZtoUserEntity.FieldIssendorreceive, 1));
ZtoUserEntity defaultUserEntity = null;
if (defaultUserList.Any())
{
defaultUserEntity = defaultUserList.First();
}
foreach (DataRow dr in chooseDt.Rows)
{
++temp;
splashScreenManagerImportExcel.SetWaitFormDescription(string.Format("正在导入Excel数据：{0}/{1}", temp, chooseDt.Rows.Count));
ZtoPrintBillEntity entity = new ZtoPrintBillEntity();
if (ckTodaySend.Checked)
{
entity.SendDate = DateTime.Now.ToString(BaseSystemInfo.DateFormat);
}
if (ckUserDefaultSendMan.Checked)
{
if (defaultUserEntity != null)
{
entity.SendMan = defaultUserEntity.Realname;
entity.SendPhone = defaultUserEntity.Mobile + " " + defaultUserEntity.TelePhone;
entity.SendProvince = defaultUserEntity.Province;
entity.SendCity = defaultUserEntity.City;
entity.SendCounty = defaultUserEntity.County;
entity.SendAddress = defaultUserEntity.Address;
entity.SendDeparture = entity.SendProvince;
entity.SendCompany = defaultUserEntity.Company;
entity.SendDepartment = defaultUserEntity.Department;
entity.SendPostcode = defaultUserEntity.Postcode;
}
}
else
{
// 使用Excel里面的发件人
entity.SendMan = BaseBusinessLogic.ConvertToString(dr[6]);
entity.SendPhone = BaseBusinessLogic.ConvertToString(dr[7]);
entity.SendAddress = BaseBusinessLogic.ConvertToString(dr[8]);
if (string.IsNullOrEmpty(entity.SendProvince) && string.IsNullOrEmpty(entity.SendCity) && string.IsNullOrEmpty(entity.SendCounty))
{
if (!string.IsNullOrEmpty(entity.SendAddress))
{
var baiAddressEntity = BaiduMapHelper.GetProvCityDistFromBaiduMap(entity.SendAddress);
if (baiAddressEntity != null)
{
entity.SendProvince = baiAddressEntity.Result.AddressComponent.Province;
entity.SendCity = baiAddressEntity.Result.AddressComponent.City;
entity.SendCounty = baiAddressEntity.Result.AddressComponent.District;
}
}
}
entity.SendDeparture = entity.SendProvince;
if (string.IsNullOrEmpty(entity.SendDeparture))
{
entity.SendDeparture = entity.SendProvince;
}
entity.SendCompany = BaseBusinessLogic.ConvertToString(dr[10]);
entity.SendDepartment = BaseBusinessLogic.ConvertToString(dr[11]);
entity.SendPostcode = BaseBusinessLogic.ConvertToString(dr[9]);
}
entity.ReceiveMan = BaseBusinessLogic.ConvertToString(dr[0]);
entity.ReceivePhone = BaseBusinessLogic.ConvertToString(dr[1]);
entity.ReceiveAddress = BaseBusinessLogic.ConvertToString(dr[2]);
//if (string.IsNullOrEmpty(entity.ReceiveProvince) && string.IsNullOrEmpty(entity.ReceiveCity) && string.IsNullOrEmpty(entity.ReceiveCounty))
//{
// if (!string.IsNullOrEmpty(entity.ReceiveAddress))
// {
// var baiAddressEntity = BaiduHelper.GetProvCityDistFromBaiduMap(entity.ReceiveAddress);
// if (baiAddressEntity != null)
// {
// entity.ReceiveProvince = baiAddressEntity.Result.AddressComponent.Province;
// entity.ReceiveCity = baiAddressEntity.Result.AddressComponent.City;
// entity.ReceiveCounty = baiAddressEntity.Result.AddressComponent.District;
// }
// }
//}
entity.ReceiveDestination = entity.ReceiveProvince;
if (string.IsNullOrEmpty(entity.ReceiveDestination))
{
entity.ReceiveDestination = entity.ReceiveProvince;
}
//entity.ReceiveCompany = BaseBusinessLogic.ConvertToString(dr[31]);
//entity.ReceivePostcode = BaseBusinessLogic.ConvertToString(dr[32]);
//entity.GoodsName = BaseBusinessLogic.ConvertToString(dr[14]);
//entity.Weight = BaseBusinessLogic.ConvertToString(dr[15]);
//entity.TranFee = BaseBusinessLogic.ConvertToString(dr[16]);
//entity.Length = BaseBusinessLogic.ConvertToString(dr[33]);
//entity.Width = BaseBusinessLogic.ConvertToString(dr[34]);
//entity.Height = BaseBusinessLogic.ConvertToString(dr[35]);
//entity.TotalNumber = BaseBusinessLogic.ConvertToString(dr[36]);
entity.Remark = BaseBusinessLogic.ConvertToString(dr[4]);
entity.OrderNumber = BaseBusinessLogic.ConvertToString(dr[3]);
entity.TranFee = BaseBusinessLogic.ConvertToString(dr[5]);
entity.CreateOn = DateTime.Now;
if (!ckGetServerPrintMark.Checked)
{
entity.BigPen = string.Format("{0} {1} {2}", entity.ReceiveProvince, entity.ReceiveCity, entity.ReceiveCounty);
}
else
{
entity.BigPen = "";
}
list.Add(entity);
}
if (!ckGetServerPrintMark.Checked)
{
var manager = new ZtoPrintBillManager(BillPrintHelper.DbHelper);
foreach (ZtoPrintBillEntity ztoPrintBillEntity in list)
{
manager.Add(ztoPrintBillEntity, true);
}
if (splashScreenManagerImportExcel != null && splashScreenManagerImportExcel.IsSplashFormVisible)
{
splashScreenManagerImportExcel.CloseWaitForm();
}
GridDataBind();
var ts = DateTime.Now - startDateTime;
lblTime.Text = string.Format("耗时:{0}时{1}分{2}秒{3}毫秒", ts.Hours, ts.Minutes, ts.Seconds, ts.Milliseconds);
Close();
}
else
{
splashScreenManagerImportExcel.SetWaitFormDescription("正在联网获取大头笔信息");
if (splashScreenManagerImportExcel != null && splashScreenManagerImportExcel.IsSplashFormVisible)
{
splashScreenManagerImportExcel.CloseWaitForm();
}
// 开线程去读取大头笔的
CheckBillCode(list);
}
}
else
{
XtraMessageBox.Show(@"模板没有填写任何数据，导入失败", AppMessage.MSG0000, MessageBoxButtons.OK, MessageBoxIcon.Error);
return(false);
}
}
catch (Exception ex)
{
ProcessException(ex);
return(false);
}
finally
{
if (splashScreenManagerImportExcel != null && splashScreenManagerImportExcel.IsSplashFormVisible)
{
splashScreenManagerImportExcel.CloseWaitForm();
}
}
return(true);
}
/// <summary>
/// 保存本地
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void btnSaveBill_Click(object sender, EventArgs e)
{
//构建实体
ZtoPrintBillEntity printBillEntity = BuildPrintEntity();
//if (!string.IsNullOrEmpty(PrintBillId))
//{
// printBillEntity = new ZtoPrintBillManager(BillPrintHelper.DbHelper).GetObject(PrintBillId);
//}
//printBillEntity.SendMan = txtSendMan.Text;
//printBillEntity.SendPhone = txtSendPhone.Text;
//printBillEntity.SendCompany = txtSendCompany.Text;
//printBillEntity.SendAddress = txtSendAddress.Text;
//printBillEntity.SendDate = string.IsNullOrEmpty(txtSendDate.Text) ? DateTime.Now.ToString(BaseSystemInfo.DateFormat) : txtSendDate.Text;
//if (!string.IsNullOrEmpty(dgvSendArea.Text))
//{
// var sendAreaArray = dgvSendArea.Text.Split('-');
// printBillEntity.SendProvince = sendAreaArray[0];
// printBillEntity.SendCity = sendAreaArray[1];
// printBillEntity.SendCounty = sendAreaArray[2];
//}
//printBillEntity.ReceiveMan = txtReceiveMan.Text;
//printBillEntity.ReceivePhone = txtReceivePhone.Text;
//printBillEntity.ReceiveCompany = txtReceiveCompany.Text;
//printBillEntity.ReceiveAddress = txtReceiveAddress.Text;
//if (!string.IsNullOrEmpty(dgvReceiveArea.Text))
//{
// var receiveAreaArray = dgvReceiveArea.Text.Split('-');
// printBillEntity.ReceiveProvince = receiveAreaArray[0];
// printBillEntity.ReceiveCity = receiveAreaArray[1];
// printBillEntity.ReceiveCounty = receiveAreaArray[2];
//}
//printBillEntity.GoodsName = cmbGoodsName.Text;
//printBillEntity.Weight = txtGoodsWeight.Text;
//printBillEntity.GOODS_PAYMENT = string.IsNullOrEmpty(txtGoodsPayment.Text) ? 0 : decimal.Parse(txtGoodsPayment.Text);
//printBillEntity.TOPAYMENT = string.IsNullOrEmpty(txtToPayMent.Text) ? 0 : decimal.Parse(txtToPayMent.Text);
//printBillEntity.Remark = txtRemark.Text;
//printBillEntity.BigPen = txtBigPen.Text;
var ztoPrintBillManager = new ZtoPrintBillManager(BillPrintHelper.DbHelper);
// 表示更新
if (!string.IsNullOrEmpty(PrintBillId))
{
printBillEntity.Id = BaseBusinessLogic.ConvertToDecimal(PrintBillId);
ztoPrintBillManager.Update(printBillEntity);
XtraMessageBox.Show("更新成功", AppMessage.MSG0000, MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else
{
_list.Clear();
var saveCount = int.Parse(cmbPrintNumber.Text);
if (saveCount == 0)
{
cmbPrintNumber.Text = "1";
saveCount = 1;
}
// 这里要有订单号可以输入，不能系统生成，这样不科学，2016年6月15日22:33:11，杨恒连
// 如果他大于1条的话，后面的订单号要系统生成了
// 最好检查这个订单号有么有重复使用，重复使用就不好了，这样获取到用过的单号是要罚款的
if (!string.IsNullOrEmpty(txtOrderNumber.Text))
{
saveCount = saveCount - 1;
printBillEntity.OrderNumber = txtOrderNumber.Text;
ztoPrintBillManager.Add(printBillEntity, true);
_list.Add(printBillEntity);
}
for (int i = 0; i < saveCount; i++)
{
printBillEntity.OrderNumber = Guid.NewGuid().ToString("N").ToLower();
ztoPrintBillManager.Add(printBillEntity, true);
_list.Add(printBillEntity);
}
XtraMessageBox.Show(string.Format("新增成功{0}条记录", cmbPrintNumber.Text), AppMessage.MSG0000, MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
/// <summary>
/// 构建打印实体
/// </summary>
/// <returns></returns>
private ZtoPrintBillEntity BuildPrintBillEntity()
{
ZtoPrintBillEntity printBillEntity = null;
if (!string.IsNullOrEmpty(SelectedId))
{
printBillEntity = _printBillManager.GetObject(SelectedId);
}
if (printBillEntity == null)
{
// 表示新增
printBillEntity = new ZtoPrintBillEntity
{
SendMan = txtSendMan.Text.Trim(),
SendDeparture = txtSendDeparture.Text.Trim(),
SendAddress = txtSendAddress.Text.Trim(),
SendPhone = txtSendPhone.Text.Trim(),
SendCompany = txtSendCompany.Text.Trim(),
SendDate = "",
ReceiveMan = txtReceiveMan.Text.Trim(),
ReceiveDestination = txtReceiveDestination.Text.Trim(),
ReceiveAddress = txtReceiveAddress.Text.Trim(),
ReceiveCompany = txtReceiveCompany.Text.Trim(),
ReceivePhone = txtReceivePhone.Text.Trim(),
TotalNumber = string.IsNullOrEmpty(txtNumber.Text.Trim()) ? "" : txtNumber.Text,
Remark = txtRemark.Text.Trim(),
Weight = string.IsNullOrEmpty(txtWeight.Text.Trim()) ? "" : txtWeight.Text,
TranFee = txtGoodsPayMent.Text.Trim(),
GoodsName = txtGoodsName.Text,
};
printBillEntity.GOODS_PAYMENT = BaseBusinessLogic.ConvertToDecimal(txtGoodsPayMent.Text);
}
else
{
// 修改
printBillEntity.SendMan = txtSendMan.Text.Trim();
printBillEntity.SendDeparture = txtSendDeparture.Text.Trim();
printBillEntity.SendAddress = txtSendAddress.Text.Trim();
printBillEntity.SendPhone = txtSendPhone.Text.Trim();
printBillEntity.SendCompany = txtSendCompany.Text.Trim();
printBillEntity.SendDate = "";
printBillEntity.ReceiveMan = txtReceiveMan.Text.Trim();
printBillEntity.ReceiveDestination = txtReceiveDestination.Text.Trim();
printBillEntity.ReceiveAddress = txtReceiveAddress.Text.Trim();
printBillEntity.ReceiveCompany = txtReceiveCompany.Text.Trim();
printBillEntity.ReceivePhone = txtReceivePhone.Text.Trim();
printBillEntity.TotalNumber = string.IsNullOrEmpty(txtNumber.Text.Trim()) ? "" : txtNumber.Text;
printBillEntity.Remark = txtRemark.Text.Trim();
printBillEntity.Weight = string.IsNullOrEmpty(txtWeight.Text.Trim()) ? "" : txtWeight.Text;
printBillEntity.TranFee = txtGoodsPayMent.Text.Trim();
printBillEntity.GoodsName = txtGoodsName.Text;
}
if (ckTodaySend.Checked)
{
printBillEntity.SendDate = DateTime.Now.ToString(BaseSystemInfo.DateFormat);
}
else
{
printBillEntity.SendDate = txtSendDate.Text;
}
if (!string.IsNullOrEmpty(dgvSearchSendArea.Text.Trim()))
{
var sendAreaArray = dgvSearchSendArea.Text.Split('-');
printBillEntity.SendProvince = sendAreaArray[0];
printBillEntity.SendCity = sendAreaArray[1];
printBillEntity.SendCounty = sendAreaArray[2];
}
if (!string.IsNullOrEmpty(dgvSearchReceiveArea.Text.Trim()))
{
var receiveAreaArray = dgvSearchReceiveArea.Text.Split('-');
printBillEntity.ReceiveProvince = receiveAreaArray[0];
printBillEntity.ReceiveCity = receiveAreaArray[1];
printBillEntity.ReceiveCounty = receiveAreaArray[2];
}
printBillEntity.BigPen = txtPrintMark.Text.Trim();
return(printBillEntity);
}
