/// <summary>
/// 纳品书
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void btnShipper_Click(object sender, EventArgs e)
{
try
{
if (isSearch)
{
//纳品书订单的选择
FrmShipmentPrintSelect frm = new FrmShipmentPrintSelect(currentConduction);
if (frm.ShowDialog(this) == DialogResult.Cancel)
{
return;
}
string slipNumber = frm.resultValue;
if (!string.IsNullOrEmpty(slipNumber))
{
Hashtable ht = null; //单个替换用
DataTable dt = null; //数据集
bool isMechanicalBase = false;
DataSet ds = bShipment.GetList(" SLIP_NUMBER in (" + slipNumber + ")");
foreach (DataRow dr in ds.Tables[0].Rows)
{
if (CConstant.MECHANICAL_BASE.Equals(dr["MECHANICAL_DISTINCTION_FLAG"]))
{
isMechanicalBase = true;
break;
}
}
if (isMechanicalBase)
{
#region 含机械本体
dt = new DataTable();
dt.Columns.Add("NO", Type.GetType("System.String"));
dt.Columns.Add("NAME", Type.GetType("System.String"));
dt.Columns.Add("SPEC", Type.GetType("System.String"));
dt.Columns.Add("QTY", Type.GetType("System.Decimal"));
dt.Columns.Add("UNIT_NAME", Type.GetType("System.String"));
dt.Columns.Add("SERIAL_NUMBER", Type.GetType("System.String"));
DataRow row = null;
bool isFirst = true;
int i = 1;
foreach (DataRow dr in ds.Tables[0].Rows)
{
if (isFirst)
{
ht = new Hashtable();
ht.Add("&SLIP_NUMBER", CConvert.ToString(dr["SLIP_NUMBER"]));
ht.Add("&DATE", CConvert.ToDateTime(dr["SLIP_DATE"]).ToShortDateString());
ht.Add("&CUSTOMER_NAME", CConvert.ToString(dr["CUSTOMER_NAME"]));
ht.Add("&CONTACT_NAME", CConvert.ToString(dr["CONTACT_NAME"]));
ht.Add("&MOBIL_NUMBER", CConvert.ToString(dr["MOBIL_NUMBER"]));
ht.Add("&MONTH", CConvert.ToDateTime(dr["ARRIVAL_DATE"]).Month);
ht.Add("&DAY", CConvert.ToDateTime(dr["ARRIVAL_DATE"]).Day);
ht.Add("&HOUR", CConvert.ToDateTime(dr["ARRIVAL_DATE"]).Hour);
ht.Add("&MINUTE", CConvert.ToDateTime(dr["ARRIVAL_DATE"]).Minute);
ht.Add("&ADDRESS", CConvert.ToString(dr["DELIVERY_POINT_NAME"]));
}
if (CConstant.PRODUCT_PACKAGE_ALONT.Equals(dr["PACKAGE_MODE"]))
{
row = dt.NewRow();
row["NO"] = i++;
row["NAME"] = CConvert.ToString(dr["PRODUCT_NAME"]);
row["SPEC"] = CConvert.ToString(dr["SPEC"]);
row["QTY"] = CConvert.ToDecimal(dr["QUANTITY"]);
row["UNIT_NAME"] = CConvert.ToString(dr["UNIT_NAME"]);
if (CConstant.MECHANICAL_BASE.Equals(dr["MECHANICAL_DISTINCTION_FLAG"]))
{
row["SERIAL_NUMBER"] = CConvert.ToString(dr["SERIAL_NUMBER"]);
}
else
{
row["SERIAL_NUMBER"] = "";
}
dt.Rows.Add(row);
}
}
SaveFileDialog sf = new SaveFileDialog();
sf.FileName = "LZ_SHIPMENT_BODY_" + DateTime.Now.ToString("yyyyMMddHHmmss") + ".xls";
sf.Filter = "(文件)|*.xls;*.xlsx";
if (sf.ShowDialog(this) == DialogResult.OK)
{
if (dt.Rows.Count > 0)
{
int ret = CommonExport.ExportShipmentBody(@"rpt\shipper_body.xls", sf.FileName, dt, ht);
if (CConstant.EXPORT_FAILURE.Equals(ret))
{
MessageBox.Show("导出失败。", this.Text, MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
}
else if (CConstant.EXPORT_SUCCESS.Equals(ret))
{
MessageBox.Show("导出成功。", this.Text, MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else if (CConstant.EXPORT_RUNNING.Equals(ret))
{
MessageBox.Show("文件正在运行，重新生成文件失败。", this.Text, MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
}
else if (CConstant.EXPORT_TEMPLETE_FILE_NOT_EXIST.Equals(ret))
{
MessageBox.Show("模版文件不存在。", this.Text, MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
}
}
else
{
MessageBox.Show("明细信息不存在。", this.Text, MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
}
}
#endregion
}
else
{
#region 部件出货
dt = new DataTable();
dt.Columns.Add("NO", Type.GetType("System.Int32"));
dt.Columns.Add("PRODUCT_NAME", Type.GetType("System.String"));
dt.Columns.Add("X_1", Type.GetType("System.String"));
dt.Columns.Add("X_2", Type.GetType("System.String"));
dt.Columns.Add("MODEL_NUMBER", Type.GetType("System.String"));
dt.Columns.Add("X_3", Type.GetType("System.String"));
dt.Columns.Add("QUANTITY", Type.GetType("System.Decimal"));
dt.Columns.Add("MEMO", Type.GetType("System.String"));
DataRow row = null;
bool isFirst = true;
int i = 1;
foreach (DataRow dr in ds.Tables[0].Rows)
{
if (isFirst)
{
ht = new Hashtable();
ht.Add("&SLIP_NUMBER", CConvert.ToString(dr["SLIP_NUMBER"]));
ht.Add("&DATE", CConvert.ToDateTime(dr["SLIP_DATE"]).ToShortDateString());
ht.Add("&END_CUSTOMER_NAME", CConvert.ToString(dr["ENDER_CUSTOMER_NAME"]));
ht.Add("&CONTACT", CConvert.ToString(dr["ENDER_CONTACT_NAME"]));
ht.Add("&MOBIL_NUMBER", CConvert.ToString(dr["ENDER_MOBIL_NUMBER"]));
ht.Add("&ADDRESS", CConvert.ToString(dr["DELIVERY_POINT_NAME"]));
DataTable userDt = new BUser().GetList(" CODE='" + CConvert.ToString(dr["CREATE_USER"]) + "'").Tables[0];
string companyName = "";
if (userDt != null && userDt.Rows.Count > 0)
{
companyName = CConvert.ToString(userDt.Rows[0]["COMPANY_NAME"]);
}
ht.Add("&COMPANY_NAME", companyName);
ht.Add("&INVOICE_NUMBER", bShipment.GetReceiptInvoiceNumber(CConvert.ToString(dr["ORDER_SLIP_NUMBER"])));
}
row = dt.NewRow();
row["NO"] = i++;
row["PRODUCT_NAME"] = CConvert.ToString(dr["PRODUCT_NAME"]);
row["MODEL_NUMBER"] = CConvert.ToString(dr["SPEC"]) + CConvert.ToString(dr["MODEL_NUMBER"]);
row["QUANTITY"] = CConvert.ToDecimal(dr["QUANTITY"]);
row["MEMO"] = CConvert.ToString(dr["MEMO"]);
dt.Rows.Add(row);
}
SaveFileDialog sf = new SaveFileDialog();
sf.FileName = "LZ_SHIPMENT_ACCESSORIES_" + DateTime.Now.ToString("yyyyMMddHHmmss") + ".xls";
sf.Filter = "(文件)|*.xls;*.xlsx";
if (sf.ShowDialog(this) == DialogResult.OK)
{
if (dt.Rows.Count > 0)
{
int ret = CommonExport.ExportShipmentAccessories(@"rpt\shipper_accessories.xls", sf.FileName, dt, ht);
if (CConstant.EXPORT_FAILURE.Equals(ret))
{
MessageBox.Show("导出失败。", this.Text, MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
}
else if (CConstant.EXPORT_SUCCESS.Equals(ret))
{
MessageBox.Show("导出成功。", this.Text, MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else if (CConstant.EXPORT_RUNNING.Equals(ret))
{
MessageBox.Show("文件正在运行，重新生成文件失败。", this.Text, MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
}
else if (CConstant.EXPORT_TEMPLETE_FILE_NOT_EXIST.Equals(ret))
{
MessageBox.Show("模版文件不存在。", this.Text, MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
}
}
else
{
MessageBox.Show("明细信息不存在。", this.Text, MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
}
}
#endregion
}
}
// end if (!string.IsNullOrEmpty(slipNumber))
} // end if (isSearch)
}
catch (Exception ex)
{ }
}
