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