private void btnSelect_Click(object sender, EventArgs e)
{
if (string.IsNullOrEmpty(this.txt_sup.Text))
{
MsgForm.ShowFrom("请先选择供应商");
return;
}
IBLL.IInOutBLL bll = new BLL.InOutBLL();
var dt = new DataTable();
var supcust_no = txt_sup.Text.Trim().Split('/')[0];
dt = bll.GetSimpleInOutList(DateTime.Now.AddMonths(-2), DateTime.Now, supcust_no, "A");
frmSelect frm = new frmSelect();
frm.dgv.AddColumn("oper_date", "日期", "", 100, 1, "yyyy-MM-dd");
frm.dgv.AddColumn("sheet_no", "单据号", "", 150, 1, "");
frm.dgv.AddColumn("仓库", "仓库", "", 200, 1, "");
frm.dgv.AddColumn("货商", "货商", "", 200, 1, "");
frm.dgv.AddColumn("total_amount", "金额", "", 100, 3, "0.00");
frm.Text = "选择入库单";
frm.tb = dt;
frm.is_show_left = false;
this.txt_voucher_no.Text = frm.SelectData("单号:", "sheet_no");
}
private void tsbDel_Click(object sender, EventArgs e)
{
try
{
if (!MyLove.PermissionsBalidation(this.Text, "02"))
{
return;
}
if (sheet_no != null && sheet_no != "")
{
if (YesNoForm.ShowFrom("确认删除单据[" + sheet_no + "]?") == System.Windows.Forms.DialogResult.Yes)
{
IBLL.IInOutBLL bll = new BLL.InOutBLL();
bll.DeleteInOut(sheet_no, update_time);
IOrder ins = this;
ins.Add();
}
}
}
catch (Exception ex)
{
MsgForm.ShowFrom("删除单据异常[" + ex.Message + "]");
Helper.LogHelper.writeLog("frmOtherInOutSheet->tsbDel_Click()", ex.ToString(), sheet_no);
}
}
private void tsbDel_Click(object sender, EventArgs e)
{
try
{
if (!MyLove.PermissionsBalidation(this.Text, "02"))
{
return;
}
if (this.dataGrid1.CurrentRow() != null)
{
string sheet_no = this.dataGrid1.CurrentRow()["sheet_no"].ToString();
if (YesNoForm.ShowFrom("确认删除单据" + sheet_no + "?") == DialogResult.Yes)
{
IBLL.IInOutBLL bll = new BLL.InOutBLL();
bll.DeleteInOut(sheet_no, update_time);
var tb = this.dataGrid1.DataSource;
tb.Rows.Remove(this.dataGrid1.CurrentRow());
this.dataGrid2.DataSource = new DataTable();
this.dataGrid1.Refresh();
}
}
}
catch (Exception ex)
{
MsgForm.ShowFrom(ex);
Helper.LogHelper.writeLog("frmIOMaster->tsbDel_Click()", ex.ToString());
}
}
private void tsbCheck_Click(object sender, EventArgs e)
{
try
{
if (!MyLove.PermissionsBalidation(this.Text, "05"))
{
return;
}
if (this.dataGrid1.CurrentRow() != null)
{
string sheet_no = this.dataGrid1.CurrentRow()["sheet_no"].ToString();
IBLL.IInOutBLL bll = new BLL.InOutBLL();
bll.CheckInOut(sheet_no, Program.oper.oper_id, update_time);
var row = this.dataGrid1.CurrentRow();
row["approve_flag"] = "1";
row["approve_man"] = Program.oper.oper_id;
row["approve_date"] = System.DateTime.Now;
this.dataGrid1.Refresh();
}
}
catch (Exception ex)
{
MsgForm.ShowFrom(ex);
Helper.LogHelper.writeLog("frmIOMaster->tsbDel_Click()", ex.ToString());
}
}
/// <summary>
/// 收货称流水生成采购单
/// </summary>
/// <param name="dgv"></param>
public void GenerateReceiveCG(DataGrid dgv)
{
try
{
if (dgv.DataSource.Rows.Count < 1)
{
throw new Exception("表格中没有数据!");
}
DataTable tb = dgv.GetSelectData();
if (tb.Rows.Count < 1)
{
throw new Exception("请选择要生成采购单的数据!");
}
StringBuilder flow_id = new StringBuilder("''");
foreach (DataRow dr in tb.Rows)
{
flow_id.Append(",'" + dr["flow_id"].ToString() + "'");
}
IBLL.IInOutBLL bll = new BLL.InOutBLL();
bll.ReceiveGenCG(flow_id.ToString(), Program.oper.oper_id);
MsgForm.ShowFrom("生成采购单成功");
}
catch (Exception ex)
{
MsgForm.ShowFrom(ex);
}
}
private void refreshData()
{
try
{
System.Windows.Forms.Cursor.Current = System.Windows.Forms.Cursors.WaitCursor;
//
DateTime date1 = Helper.Conv.ToDateTime(dateTextBox1.Text.Trim());
DateTime date2 = Helper.Conv.ToDateTime(dateTextBox2.Text.Trim());
System.Threading.Thread th = new System.Threading.Thread(() =>
{
Cursor.Current = Cursors.WaitCursor;
Helper.GlobalData.windows.ShowLoad(this);
try
{
IBLL.IInOutBLL bll = new BLL.InOutBLL();
if (date1 == DateTime.MinValue)
{
throw new Exception("期间不正确");
}
if (date2 == DateTime.MinValue)
{
throw new Exception("期间不正确");
}
DataTable tb = bll.GetInOutList(date1, date2, "", "G");
this.dataGrid1.Invoke((MethodInvoker) delegate
{
this.dataGrid1.DataSource = tb;
});
}
catch (Exception ex)
{
IvyBack.Helper.LogHelper.writeLog("refreshData", ex.ToString());
MsgForm.ShowFrom(ex);
}
Cursor.Current = Cursors.Default;
Helper.GlobalData.windows.CloseLoad(this);
});
th.Start();
}
catch (Exception ex)
{
MsgForm.ShowFrom(ex);
Helper.LogHelper.writeLog("frmIOMaster->refreshData()", ex.ToString());
}
finally
{
System.Windows.Forms.Cursor.Current = System.Windows.Forms.Cursors.Default;
}
}
private void LoadOrder()
{
string order_sheet_no = this.txt_voucher_no.Text.Trim();
if (string.IsNullOrEmpty(order_sheet_no))
{
return;
}
this.editGrid1.DataSource.Clear();
IBLL.IInOutBLL bll3 = new BLL.InOutBLL();
DataTable tbmain;
DataTable tbdetail;
bll3.GetCGOrder(order_sheet_no, out tbmain, out tbdetail);
DataRow row = tbmain.Rows[0];
txt_sup.GetValue("supcust_no", row["sup_no"].ToString());
txtbranch.GetValue("branch_no", row["branch_no"].ToString());
txt_deal_man.GetValue("oper_id", row["order_man"].ToString());
txt_other1.Text = row["memo"].ToString();
this.editGrid1.DataSource.ClearTable();
foreach (DataRow dr in tbdetail.Rows)
{
this.editGrid1.DataSource.ImportRow(dr);
DataRow r = this.editGrid1.DataSource.Rows[this.editGrid1.DataSource.Rows.Count - 1];
r["item_no"] = dr["item_no"];
r["item_subno"] = dr["item_subno"];
r["barcode"] = dr["barcode"];
r["item_name"] = dr["item_name"];
r["unit_no"] = dr["unit_no"];
r["in_qty"] = dr["order_qnty"];
r["valid_price"] = dr["in_price"];
r["sub_amount"] = dr["sub_amount"];
r["other1"] = dr["other1"];
r["discount"] = dr["discount"];
r["valid_date"] = row["valid_date"].ToDateTime();
}
txt_sup.Enabled = false;
txtbranch.Enabled = false;
txt_voucher_no.Enabled = false;
this.editGrid1.DataSource.Rows.Add();
this.editGrid1.Refresh();
}
private void LoadOrder()
{
string order_sheet_no = this.txt_voucher_no.Text.Trim();
if (string.IsNullOrEmpty(order_sheet_no))
{
return;
}
IBLL.IInOutBLL bll3 = new BLL.InOutBLL();
DataTable tbmain;
DataTable tbdetail;
bll3.GetSaleSSSheet(order_sheet_no, out tbmain, out tbdetail);
DataRow row = tbmain.Rows[0];
txt_cust.GetValue("supcust_no", row["sup_no"].ToString());
txtbranch.GetValue("branch_no", row["branch_no"].ToString());
txt_sale_man.GetValue("oper_id", row["order_man"].ToString());
txt_paid_amount.Text = row["paid_amount"].ToString();
txtmemo.Text = row["memo"].ToString();
this.editGrid1.DataSource.ClearTable();
foreach (DataRow dr in tbdetail.Rows)
{
DataRow r = this.editGrid1.DataSource.NewRow();
r["item_no"] = dr["item_no"];
r["item_subno"] = dr["item_subno"];
r["barcode"] = dr["barcode"];
r["item_name"] = dr["item_name"];
r["unit_no"] = dr["unit_no"];
r["sale_qnty"] = dr["order_qnty"];
r["real_price"] = dr["in_price"];
r["sale_money"] = dr["sub_amount"];
r["other5"] = dr["other1"];
this.editGrid1.DataSource.Rows.Add(r);
}
txt_cust.Enabled = false;
txtbranch.Enabled = false;
txt_voucher_no.Enabled = false;
this.editGrid1.DataSource.Rows.Add();
this.editGrid1.Refresh();
}
public void GetPrintTb()
{
if (string.IsNullOrEmpty(this.txtsheet_no.Text))
{
throw new Exception("请选择单据!");
}
IBLL.IInOutBLL bll = new BLL.InOutBLL();
DataTable tb1;
DataTable tb2;
bll.GetOtherInOut(this.txtsheet_no.Text, out tb1, out tb2);
PrintForm.PrintHelper.tb_main = tb1;
PrintForm.PrintHelper.tb_detail = tb2;
}
void IOrder.Add()
{
try
{
RunType = 1;
foreach (Control c in this.panel1.Controls)
{
c.Enabled = true;
}
IBLL.IInOutBLL bll3 = new BLL.InOutBLL();
var order = bll3.GetImportSSSheet();
this.txt_voucher_no.Invoke((MethodInvoker) delegate
{
this.txt_voucher_no.Bind(order, 350, 200, "sheet_no", "sheet_no:单据号:110,supcust:客户:100,branch:仓库:100,oper_date:日期:150", "sheet_no->Text");
});
this.txt_cust.Text = "";
this.txtbranch.GetDefaultValue();
this.txtsheet_no.Text = "";
this.txt_voucher_no.Text = "";
this.txtoper_date.Text = System.DateTime.Now.ToString("yyyy-MM-dd");
this.txt_pay_date.Text = System.DateTime.Now.ToString("yyyy-MM-dd");
this.txt_sale_man.Text = "";
this.txtapprove_man.Text = "";
this.txtoper_man.Text = Program.oper.oper_id + "/" + Program.oper.oper_name;
this.txtmemo.Text = "";
this.txtapprove_date.Text = "";
//
var tb = editGrid1.DataSource;
tb.Clear();
for (int i = 0; i < 1; i++)
{
tb.Rows.Add(tb.NewRow());
}
editGrid1.Refresh();
Dictionary <string, object> dic = this.Tag as Dictionary <string, object>;
this.Tag = Helper.Conv.ControlsAdds(this, dic);
}
catch (Exception ex)
{
MsgForm.ShowFrom(ex);
}
}
private void txt_voucher_no_TextChanged(object sender, EventArgs e)
{
try
{
if (string.IsNullOrEmpty(this.txt_voucher_no.Text))
{
return;
}
IBLL.IInOutBLL bll = new BLL.InOutBLL();
bll.GetInOut(this.txt_voucher_no.Text, "A", out in_master, out in_detail);
if (in_detail.Rows.Count > 0)
{
var tb = editGrid1.DataSource;
if (tb.Rows.Count > 0)
{
if (YesNoForm.ShowFrom("检测到表格中有数据，是否加载？(将覆盖数据)") == DialogResult.Yes)
{
tb.Clear();
}
}
foreach (DataRow dr in in_detail.Rows)
{
DataRow r = tb.NewRow();
r["item_no"] = dr["item_no"];
r["item_subno"] = dr["item_subno"];
r["item_name"] = dr["item_name"];
r["unit_no"] = dr["unit_no"];
r["item_size"] = dr["item_size"];
r["in_qty"] = dr["in_qty"];
r["valid_price"] = dr["valid_price"];
r["sub_amount"] = dr["sub_amount"];
r["other1"] = dr["other1"];
r["price"] = dr["price"];
tb.Rows.Add(r);
}
editGrid1.Refresh();
}
}
catch (Exception ex)
{
MsgForm.ShowFrom(ex);
}
}
private void dataGrid1_CurrentCellChange(object sender, string column_name, DataRow row)
{
try
{
if (sheet_no != row["sheet_no"].ToString())
{
Thread th = new Thread(() =>
{
Cursor.Current = Cursors.WaitCursor;
Helper.GlobalData.windows.ShowLoad(this);
try
{
sheet_no = row["sheet_no"].ToString();
trans_no = row["trans_no"].ToString();
IBLL.IInOutBLL bll = new BLL.InOutBLL();
System.Data.DataTable tb1;
System.Data.DataTable tb2;
bll.GetCGOrder(sheet_no, out tb1, out tb2);
this.dataGrid2.Invoke((MethodInvoker) delegate
{
this.dataGrid2.DataSource = tb2;
});
update_time = Helper.Conv.ToDateTime(tb1.Rows[0]["update_time"]);
}
catch (Exception ex)
{
LogHelper.writeLog("dataGrid1_CurrentCellChange", ex.ToString());
MsgForm.ShowFrom(ex);
}
Cursor.Current = Cursors.Default;
Helper.GlobalData.windows.CloseLoad(this);
});
th.Start();
}
}
catch (Exception ex)
{
MsgForm.ShowFrom(ex);
Helper.LogHelper.writeLog("frmCGInSheetList->dataGrid1_CurrentCellChange()", ex.ToString());
}
}
private void txt_voucher_no_TextChanged(object sender, EventArgs e)
{
if (string.IsNullOrEmpty(txt_voucher_no.Text))
{
return;
}
IBLL.IInOutBLL bll = new BLL.InOutBLL();
DataTable tb1;
DataTable tb2;
bll.GetSaleSheet(txt_voucher_no.Text, out tb1, out tb2);
if (tb2.Rows.Count > 0)
{
var tb = editGrid1.DataSource;
if (tb.Rows.Count > 0)
{
if (YesNoForm.ShowFrom("检测到表格中有数据，是否加载？(将覆盖数据)") == DialogResult.Yes)
{
tb.Clear();
}
}
foreach (DataRow dr in tb2.Rows)
{
DataRow r = tb.NewRow();
r["item_no"] = dr["item_no"];
r["item_subno"] = dr["item_subno"];
r["item_name"] = dr["item_name"];
r["unit_no"] = dr["unit_no"];
r["item_size"] = dr["item_size"];
r["in_qty"] = dr["sale_qnty"];
r["valid_price"] = dr["real_price"];
r["sub_amount"] = dr["sale_money"];
r["other1"] = dr["other1"];
r["price"] = dr["sale_price"];
tb.Rows.Add(r);
}
editGrid1.Refresh();
}
}
private void tsbCheck_Click(object sender, EventArgs e)
{
try
{
if (!MyLove.PermissionsBalidation(this.Text, "05"))
{
return;
}
if (sheet_no != null && sheet_no != "")
{
IBLL.IInOutBLL bll = new BLL.InOutBLL();
bll.CheckCGOrder(sheet_no, Program.oper.oper_id, update_time);
IOrder ins = this;
ins.ShowOrder(sheet_no);
}
}
catch (Exception ex)
{
MsgForm.ShowFrom("审核单据异常[" + ex.Message + "]");
Helper.LogHelper.writeLog("frmCGOrder->tsbCheck_Click()", ex.ToString(), sheet_no);
}
}
private void dataGrid1_CurrentCellChange(object sender, string column_name, DataRow row)
{
try
{
if (sheet_no != row["sheet_no"].ToString())
{
sheet_no = row["sheet_no"].ToString();
trans_no = row["trans_no"].ToString();
IBLL.IInOutBLL bll = new BLL.InOutBLL();
System.Data.DataTable tb1;
System.Data.DataTable tb2;
bll.GetInOut(sheet_no, trans_no, out tb1, out tb2);
this.dataGrid2.DataSource = tb2;
update_time = Helper.Conv.ToDateTime(tb1.Rows[0]["update_time"]);
}
}
catch (Exception ex)
{
MsgForm.ShowFrom(ex);
Helper.LogHelper.writeLog("frmIOMaster->dataGrid1_CurrentCellChange()", ex.ToString());
}
}
private void btnSelect_Click(object sender, EventArgs e)
{
IBLL.IInOutBLL bll = new BLL.InOutBLL();
var dt = new DataTable();
var supcust_no = txt_cust.Text.Trim().Split('/')[0];
if (supcust_no != "")
{
dt = bll.GetSimpleSaleSheetList(DateTime.Now.AddMonths(-2), DateTime.Now, supcust_no);
}
frmSelect frm = new frmSelect();
frm.dgv.AddColumn("oper_date", "操作时间", "", 100, 1, "yyyy-MM-dd");
frm.dgv.AddColumn("sheet_no", "单号", "", 150, 1, "");
frm.dgv.AddColumn("仓库", "仓库", "", 200, 1, "");
frm.dgv.AddColumn("客户", "客户", "", 200, 1, "");
frm.dgv.AddColumn("total_amount", "金额", "", 100, 3, "0.00");
frm.Text = "选择销售单";
frm.tb = dt;
frm.is_show_left = false;
this.txt_voucher_no.Text = frm.SelectData("单号:", "sheet_no");
}
void IOrder.ShowOrder(string sheet_no)
{
try
{
System.Windows.Forms.Cursor.Current = System.Windows.Forms.Cursors.WaitCursor;
//
RunType = 2;
IBLL.IInOutBLL bll = new BLL.InOutBLL();
DataTable tb1;
DataTable tb2;
bll.GetOtherInOut(sheet_no, out tb1, out tb2);
//
//
var r1 = tb1.Rows[0];
update_time = Helper.Conv.ToDateTime(r1["update_time"]);
this.sheet_no = sheet_no;
if (r1["branch_no"].ToString() == "")
{
txtbranch.Text = "";
}
else
{
txtbranch.Text = r1["branch_no"].ToString() + "/" + r1["branch_name"].ToString();
}
txtsheet_no.Text = r1["sheet_no"].ToString();
txtoper_date.Text = Helper.Conv.ToDateTime(r1["oper_date"].ToString()).ToString("yyyy-MM-dd");
if (r1["deal_man"].ToString() == "")
{
txt_deal_man.Text = "";
}
else
{
txt_deal_man.Text = r1["deal_man"].ToString() + "/" + r1["deal_man_name"].ToString();
}
if (r1["approve_man"].ToString() == "")
{
txtapprove_man.Text = "";
}
else
{
txtapprove_man.Text = r1["approve_man"].ToString() + "/" + r1["approve_man_name"].ToString();
}
if (r1["oper_id"].ToString() == "")
{
txtoper_man.Text = "";
}
else
{
txtoper_man.Text = r1["oper_id"] + "/" + r1["oper_name"];
}
txtapprove_date.Text = Helper.Conv.ToDateTime(r1["approve_date"]).ToString("yyyy-MM-dd");
var trans_name = "";
var trans_no = r1["trans_no"].ToString();
if (trans_no == "01")
{
trans_name = "其它入库";
}
else if (trans_no == "02")
{
trans_name = "归还";
}
else if (trans_no == "03")
{
trans_name = "其它出库";
}
else if (trans_no == "04")
{
trans_name = "领用出库";
}
else if (trans_no == "05")
{
trans_name = "报损出库";
}
else if (trans_no == "06")
{
trans_name = "借出";
}
else if (trans_no == "07")
{
trans_name = "报溢入库";
}
else if (trans_no == "09")
{
trans_name = "库存调整";
}
txt_trans_no.Text = trans_no + "/" + trans_name;
txt_other3.Text = r1["other3"].ToString();
txt_old_no.Text = r1["old_no"].ToString();
//
editGrid1.DataSource = tb2;
Dictionary <string, object> dic = this.Tag as Dictionary <string, object>;
this.Tag = Helper.Conv.ControlsAdds(this, dic);
}
catch (Exception ex)
{
MsgForm.ShowFrom("加载其它出入单异常[" + ex.Message + "]");
Helper.LogHelper.writeLog("frmOtherInOutSheet->ShowOrder()", ex.ToString(), sheet_no);
}
finally
{
System.Windows.Forms.Cursor.Current = System.Windows.Forms.Cursors.Default;
}
}
void IOrder.Save()
{
try
{
System.Windows.Forms.Cursor.Current = System.Windows.Forms.Cursors.WaitCursor;
//
if (txt_trans_no.Text.Trim().Contains("/") == false)
{
MsgForm.ShowFrom("业务类型必填!");
return;
}
if (txtbranch.Text.Trim().Contains("/") == false)
{
MsgForm.ShowFrom("机构必填!");
return;
}
if (txtoper_date.Text.Trim() == "")
{
MsgForm.ShowFrom("单据日期必填!");
return;
}
ic_t_inout_store_master ord = new ic_t_inout_store_master();
List <ic_t_inout_store_detail> lines = new List <ic_t_inout_store_detail>();
ord.sheet_no = txtsheet_no.Text.Trim();
ord.trans_no = txt_trans_no.Text.Trim().Split('/')[0];
ord.branch_no = txtbranch.Text.Trim().Split('/')[0];
ord.voucher_no = "";
ord.supcust_no = "";
ord.pay_way = "";
ord.discount = 1;
ord.coin_no = "RMB";
ord.tax_amount = 0;
ord.oper_date = Helper.Conv.ToDateTime(txtoper_date.Text.Trim());
ord.oper_id = txtoper_man.Text.Split('/')[0];
ord.deal_man = txt_deal_man.Text.Split('/')[0];
ord.cm_branch = "00";
ord.other1 = txt_other3.Text.Trim();
ord.other2 = "";
ord.other3 = txt_other3.Text.Trim();
ord.old_no = txt_old_no.Text;
ord.num1 = 0;
ord.num2 = 0;
ord.num3 = 0;
ord.sale_no = "";
ord.approve_flag = "0";
ord.approve_man = txtapprove_man.Text.Split('/')[0];
ord.approve_date = System.DateTime.MinValue;
ord.pay_date = System.DateTime.MinValue;
ord.update_time = update_time;
int flag = 0;
int index = 0;
decimal total_amt = 0;
foreach (DataRow row in editGrid1.DataSource.Rows)
{
++index;
if (row["item_no"].ToString() != "")
{
ic_t_inout_store_detail line = new ic_t_inout_store_detail();
lines.Add(line);
line.sheet_no = ord.sheet_no;
line.item_no = row["item_no"].ToString();
line.item_name = row["item_name"].ToString();
line.unit_no = row["unit_no"].ToString();
line.barcode = row["barcode"].ToString();
line.unit_factor = 1;
line.in_qty = Helper.Conv.ToDecimal(row["in_qty"].ToString());
line.orgi_price = 0;
line.valid_price = Helper.Conv.ToDecimal(row["valid_price"].ToString());
line.cost_price = 0;
line.sub_amount = Helper.Conv.ToDecimal(row["sub_amount"].ToString());
line.discount = 1;
line.tax = 0;
line.is_tax = "0";
line.valid_date = DateTime.MinValue;
line.other1 = row["other1"].ToString();
line.other2 = "";
line.other3 = "";
line.voucher_no = "";
line.sheet_sort = index;
line.ret_qnty = 0;
line.num1 = 0;
line.num2 = 0;
line.num3 = 0;
line.num4 = 0;
line.num5 = 0;
line.num6 = 0;
line.cost_notax = 0;
line.packqty = 0;
line.sgqty = 0;
flag = 1;
total_amt += line.in_qty * line.valid_price;
}
}
if (flag == 0)
{
MsgForm.ShowFrom("请输入表单明细");
return;
}
ord.inout_amount = total_amt;
ord.total_amount = total_amt;
IBLL.IInOutBLL bll = new BLL.InOutBLL();
if (runType == 1)
{
var sheet_no = "";
bll.AddInOut(ord, lines, out sheet_no);
IOrder ins = this;
ins.ShowOrder(sheet_no);
}
else if (runType == 2)
{
bll.ChangeInOut(ord, lines);
IOrder ins = this;
ins.ShowOrder(ord.sheet_no);
}
Dictionary <string, object> dic = this.Tag as Dictionary <string, object>;
this.Tag = Helper.Conv.ControlsAdds(this, dic);
IBLL.ISys sys = new BLL.SysBLL();
string isApprove = sys.Read("approve_at_ones");
if ("1".Equals(isApprove))
{
if (YesNoForm.ShowFrom("保存成功!是否立即审核") == DialogResult.Yes)
{
tsbCheck_Click(new object(), new EventArgs());
}
}
}
catch (Exception ex)
{
Helper.LogHelper.writeLog("frmOtherInOutSheet->Save()", ex.ToString(), txtsheet_no.Text);
MsgForm.ShowFrom("其它出入单保存异常[" + ex.Message + "]");
}
finally
{
System.Windows.Forms.Cursor.Current = System.Windows.Forms.Cursors.Default;
}
}
void IOrder.ShowOrder(string sheet_no)
{
try
{
System.Windows.Forms.Cursor.Current = System.Windows.Forms.Cursors.WaitCursor;
//
RunType = 2;
IBLL.IInOutBLL bll = new BLL.InOutBLL();
DataTable tb1;
DataTable tb2;
bll.GetInOut(sheet_no, "A", out tb1, out tb2);
//
//
var r1 = tb1.Rows[0];
update_time = Helper.Conv.ToDateTime(r1["update_time"]);
this.sheet_no = sheet_no;
if (r1["branch_no"].ToString() == "")
{
txtbranch.Text = "";
}
else
{
txtbranch.Text = r1["branch_no"].ToString() + "/" + r1["branch_name"].ToString();
}
txtsheet_no.Text = r1["sheet_no"].ToString();
txtoper_date.Text = Helper.Conv.ToDateTime(r1["oper_date"].ToString()).ToString("yyyy-MM-dd");
if (r1["deal_man"].ToString() == "")
{
txt_deal_man.Text = "";
}
else
{
txt_deal_man.Text = r1["deal_man"].ToString() + "/" + r1["deal_man_name"].ToString();
}
if (r1["approve_man"].ToString() == "")
{
txtapprove_man.Text = "";
}
else
{
txtapprove_man.Text = r1["approve_man"].ToString() + "/" + r1["approve_man_name"].ToString();
}
if (r1["oper_id"].ToString() == "")
{
txtoper_man.Text = "";
}
else
{
txtoper_man.Text = r1["oper_id"] + "/" + r1["oper_name"];
}
txtapprove_date.Text = Helper.Conv.ToDateTime(r1["approve_date"]).ToString("yyyy-MM-dd");
txt_pay_date.Text = Helper.Conv.ToDateTime(r1["pay_date"]).ToString("yyyy-MM-dd");
txt_voucher_no.Text = r1["voucher_no"].ToString();
txt_sup.Text = r1["supcust_no"].ToString() + "/" + r1["sup_name"].ToString();
var sale_name = "";
var sale_no = r1["sale_no"].ToString();
if (sale_no == "A")
{
sale_name = "购销";
}
else if (sale_no == "B")
{
sale_name = "代销";
}
else if (sale_no == "C")
{
sale_name = "联营";
}
else if (sale_no == "E")
{
sale_name = "联营进货";
}
else if (sale_no == "Z")
{
sale_name = "租赁";
}
txt_sale_no.Text = sale_no + "/" + sale_name;
txt_other1.Text = r1["other1"].ToString();
txt_other3.Text = r1["other3"].ToString();
txt_old_no.Text = r1["old_no"].ToString();
//
editGrid1.DataSource = tb2;
Dictionary <string, object> dic = this.Tag as Dictionary <string, object>;
this.Tag = Helper.Conv.ControlsAdds(this, dic);
}
catch (Exception ex)
{
MsgForm.ShowFrom("加载采购入库单异常[" + ex.Message + "]");
Helper.LogHelper.writeLog("frmCGInSheet->ShowOrder()", ex.ToString(), sheet_no);
}
finally
{
System.Windows.Forms.Cursor.Current = System.Windows.Forms.Cursors.Default;
}
}
private void SaveSheet()
{
if (curr_cust == null || string.IsNullOrEmpty(curr_cust.supcust_no))
{
MsgForm.ShowFrom("请选择客户!");
return;
}
if (sale_detail.Rows.Count < 1)
{
MsgForm.ShowFrom("请输入明细!");
return;
}
sm_t_salesheet ord = new sm_t_salesheet();
List <sm_t_salesheet_detail> lines = new List <sm_t_salesheet_detail>();
ord.sheet_no = "";
ord.branch_no = sale_master.branch_no;
ord.voucher_no = "";
ord.cust_no = sale_master.cust_no;
ord.pay_way = "";
ord.discount = 1;
ord.coin_no = "RMB";
ord.paid_amount = 0;
ord.oper_date = sale_master.oper_date;
ord.oper_id = Program.oper.oper_id;
ord.sale_man = "00";
ord.approve_flag = "0";
ord.other1 = sale_master.other1;
ord.other2 = "0";
ord.other3 = "";
ord.other4 = "";
ord.old_no = "";
ord.cm_branch = "00";
ord.psheet_no = "";
ord.pay_nowmark = "";
ord.payfee_memo = "";
ord.if_back = "0";
ord.approve_man = "";
ord.approve_date = System.DateTime.MinValue;
ord.num1 = 0;
ord.num2 = 0;
ord.num3 = 0;
ord.pay_date = sale_master.oper_date.AddMonths(1);
int index = 0;
decimal total_amt = 0;
foreach (DataRow row in sale_detail.Rows)
{
++index;
if (row["item_no"].ToString() != "")
{
sm_t_salesheet_detail line = new sm_t_salesheet_detail();
lines.Add(line);
line.sheet_no = ord.sheet_no;
line.item_no = row["item_no"].ToString();
line.item_name = row["item_name"].ToString();
line.unit_no = row["unit_no"].ToString();
line.barcode = row["barcode"].ToString();
line.unit_factor = 1;
line.sale_qnty = Helper.Conv.ToDecimal(row["sale_qnty"].ToString());
line.sale_price = Helper.Conv.ToDecimal(row["real_price"].ToString());
line.real_price = Helper.Conv.ToDecimal(row["real_price"].ToString());
line.cost_price = 0;
line.sale_money = Helper.Conv.ToDecimal(row["sale_money"].ToString());
line.discount = 1;
line.sale_tax = 0;
line.is_tax = "0";
line.other1 = row["other1"].ToString();
line.other2 = "";
line.other3 = "0";
line.other4 = "";
line.voucher_no = "";
line.sheet_sort = index;
line.ret_qnty = 0;
line.num1 = 0;
line.num2 = 0;
line.num3 = 0;
line.num4 = 0;
line.num5 = 0;
line.num6 = 0;
line.num7 = 0;
line.num8 = 0;
line.cost_notax = 0;
line.packqty = 0;
line.sgqty = 0;
total_amt += line.sale_qnty * line.real_price;
}
}
ord.real_amount = total_amt;
ord.total_amount = total_amt;
IBLL.IInOutBLL bll = new BLL.InOutBLL();
bll.AddSaleSheet(ord, lines, out string sheet_no);
NewSheet();
}
void IOrder.Save()
{
try
{
System.Windows.Forms.Cursor.Current = System.Windows.Forms.Cursors.WaitCursor;
//
if (txt_sup.Text.Trim().Contains("/") == false)
{
MsgForm.ShowFrom("客户编码必填!");
return;
}
if (txtbranch.Text.Trim().Contains("/") == false)
{
MsgForm.ShowFrom("机构必填!");
return;
}
if (txtoper_date.Text.Trim() == "")
{
MsgForm.ShowFrom("单据日期必填!");
return;
}
co_t_order_main ord = new co_t_order_main();
List <co_t_order_child> lines = new List <co_t_order_child>();
ord.sheet_no = txtsheet_no.Text.Trim();
ord.branch_no = txtbranch.Text.Trim().Split('/')[0];
ord.sup_no = txt_sup.Text.Trim().Split('/')[0];
ord.coin_code = lbl_coin_no.Text.Trim();
ord.paid_amount = Helper.Conv.ToDecimal(txt_paid_amount.Text);
ord.oper_date = Helper.Conv.ToDateTime(txtoper_date.Text.Trim());
ord.oper_id = txtoper_man.Text.Split('/')[0];
ord.order_man = txt_order_man.Text.Split('/')[0];
ord.trans_no = "S";
ord.order_status = "0";
ord.sale_way = "A";
ord.p_sheet_no = "";
ord.approve_flag = "0";
ord.other1 = "";
ord.cm_branch = "00";
ord.approve_man = txtapprove_man.Text.Split('/')[0];
ord.approve_date = System.DateTime.MinValue;
ord.num1 = 0;
ord.num2 = 0;
ord.num3 = 0;
ord.valid_date = dtvalid_date.Text.ToDateTime();
ord.memo = txtmemo1.Text;
ord.other2 = txtmemo2.Text;
int flag = 0;
int index = 0;
decimal total_amt = 0;
foreach (DataRow row in editGrid1.DataSource.Rows)
{
++index;
if (row["item_no"].ToString() != "")
{
co_t_order_child line = new co_t_order_child();
lines.Add(line);
line.sheet_no = ord.sheet_no;
line.item_no = row["item_no"].ToString();
line.unit_no = row["unit_no"].ToString();
line.barcode = row["barcode"].ToString();
line.unit_factor = 1;
line.discount = row["discount"].ToDecimal();
line.in_price = Helper.Conv.ToDecimal(row["in_price"].ToString());
line.order_qnty = Helper.Conv.ToDecimal(row["order_qnty"].ToString());
line.sub_amount = Helper.Conv.ToDecimal(row["sub_amount"].ToString());
line.discount = 1;
line.other1 = row["other1"].ToString();
line.other2 = "";
line.voucher_no = "";
line.sheet_sort = index;
line.num1 = 0;
line.num2 = 0;
line.num3 = 0;
line.packqty = 0;
line.sgqty = 0;
flag = 1;
total_amt += line.order_qnty * line.in_price;
}
}
if (flag == 0)
{
MsgForm.ShowFrom("请输入表单明细");
return;
}
ord.total_amount = total_amt;
if (runType == 1)
{
IBLL.IInOutBLL bll = new BLL.InOutBLL();
var sheet_no = "";
bll.AddSaleSSSheet(ord, lines, out sheet_no);
IOrder ins = this;
ins.ShowOrder(sheet_no);
}
else if (runType == 2)
{
IBLL.IInOutBLL bll = new BLL.InOutBLL();
bll.ChangeSaleSSSheet(ord, lines);
IOrder ins = this;
ins.ShowOrder(ord.sheet_no);
}
Dictionary <string, object> dic = this.Tag as Dictionary <string, object>;
this.Tag = Helper.Conv.ControlsAdds(this, dic);
IBLL.ISys sys = new BLL.SysBLL();
string isApprove = sys.Read("approve_at_ones");
if ("1".Equals(isApprove))
{
if (YesNoForm.ShowFrom("保存成功!是否立即审核") == DialogResult.Yes)
{
tsbCheck_Click(new object(), new EventArgs());
}
}
}
catch (Exception ex)
{
Helper.LogHelper.writeLog("frmSaleSheet->Save()", ex.ToString(), txtsheet_no.Text);
MsgForm.ShowFrom("销售订单保存异常[" + ex.Message + "]");
}
finally
{
System.Windows.Forms.Cursor.Current = System.Windows.Forms.Cursors.Default;
}
}
void IOrder.ShowOrder(string sheet_no)
{
try
{
System.Windows.Forms.Cursor.Current = System.Windows.Forms.Cursors.WaitCursor;
//
RunType = 2;
IBLL.IInOutBLL bll = new BLL.InOutBLL();
DataTable tb1;
DataTable tb2;
bll.GetSaleSheet(sheet_no, out tb1, out tb2);
//
//
var r1 = tb1.Rows[0];
update_time = Helper.Conv.ToDateTime(r1["update_time"]);
this.sheet_no = sheet_no;
if (r1["branch_no"].ToString() == "")
{
txtbranch.Text = "";
}
else
{
txtbranch.Text = r1["branch_no"].ToString() + "/" + r1["branch_name"].ToString();
}
txtsheet_no.Text = r1["sheet_no"].ToString();
txtoper_date.Text = Helper.Conv.ToDateTime(r1["oper_date"].ToString()).ToString("yyyy-MM-dd");
if (r1["sale_man"].ToString() == "")
{
txt_sale_man.Text = "";
}
else
{
txt_sale_man.Text = r1["sale_man"].ToString() + "/" + r1["sale_man_name"].ToString();
}
if (r1["approve_man"].ToString() == "")
{
txtapprove_man.Text = "";
}
else
{
txtapprove_man.Text = r1["approve_man"].ToString() + "/" + r1["approve_man_name"].ToString();
}
if (r1["oper_id"].ToString() == "")
{
txtoper_man.Text = "";
}
else
{
txtoper_man.Text = r1["oper_id"] + "/" + r1["oper_name"];
}
txtmemo.Text = r1["payfee_memo"].ToString();
txtapprove_date.Text = Helper.Conv.ToDateTime(r1["approve_date"]).ToString("yyyy-MM-dd");
txt_pay_date.Text = Helper.Conv.ToDateTime(r1["pay_date"]).ToString("yyyy-MM-dd");
txt_voucher_no.Text = r1["voucher_no"].ToString();
txt_cust.Text = r1["cust_no"].ToString() + "/" + r1["sup_name"].ToString();
txt_discount.Text = Helper.Conv.ToDecimal(r1["discount"]).ToString("F2");
txt_paid_amount.Text = Helper.Conv.ToDecimal(r1["paid_amount"]).ToString("F2");
txt_other2.Text = (r1["other2"].ToString() == "1" ? "是" : "否");
//
editGrid1.DataSource = tb2;
Dictionary <string, object> dic = this.Tag as Dictionary <string, object>;
this.Tag = Helper.Conv.ControlsAdds(this, dic);
}
catch (Exception ex)
{
MsgForm.ShowFrom("读取批发销售单异常[" + ex.Message + "]");
Helper.LogHelper.writeLog("frmSaleSheet->ShowOrder()", ex.ToString(), sheet_no);
}
finally
{
System.Windows.Forms.Cursor.Current = System.Windows.Forms.Cursors.Default;
}
}
public frmSaleSheet()
{
InitializeComponent();
//
Helper.GlobalData.InitForm(this);
//
var tb = new DataTable();
tb.Columns.Add("item_no");
tb.Columns.Add("item_subno");
tb.Columns.Add("barcode");
tb.Columns.Add("item_name");
tb.Columns.Add("unit_no");
tb.Columns.Add("other3");
tb.Columns.Add("sale_qnty", typeof(decimal));
tb.Columns.Add("real_price", typeof(decimal));
tb.Columns.Add("sale_money", typeof(decimal));
tb.Columns.Add("other5");
editGrid1.AddColumn("item_subno", "货号", "", 120, 1, "", true);
editGrid1.AddColumn("item_name", "商品名称", "", 150, 1, "", false);
editGrid1.AddColumn("other3", "赠送", "", 60, 2, "", false);
editGrid1.AddColumn("unit_no", "单位", "", 60, 2, "", false);
editGrid1.AddColumn("sale_qnty", "数量", "", 100, 3, "0.00", true);
editGrid1.AddColumn("real_price", "实际价", "", 100, 3, "0.00", true);
editGrid1.AddColumn("sale_money", "实际金额", "", 100, 3, "0.00", false);
editGrid1.AddColumn("other5", "备注明细", "", 150, 1, "", true);
editGrid1.SetTotalColumn("sale_qnty,sale_money");//合计项
editGrid1.DataSource = tb;
editGrid1.BindCheck("other3");
//
try
{
System.Windows.Forms.Cursor.Current = System.Windows.Forms.Cursors.WaitCursor;
//
System.Threading.Thread th = new System.Threading.Thread(() =>
{
Cursor.Current = Cursors.WaitCursor;
Helper.GlobalData.windows.ShowLoad(this);
try
{
IBLL.ICommonBLL bll2 = new BLL.CommonBLL();
var branch = bll2.GetBranchList();
this.txtbranch.Invoke((MethodInvoker) delegate
{
txtbranch.Bind(branch, 300, 200, "branch_no", "branch_no:机构号:80,branch_name:机构名:140", "branch_no/branch_name->Text");
});
var sale = bll2.GetPeopleList();
this.txt_sale_man.Invoke((MethodInvoker) delegate
{
txt_sale_man.Bind(sale, 250, 200, "oper_id", "oper_id:职员编号:80,oper_name:姓名:80", "oper_id/oper_name->Text");
});
var cust = bll2.GetAllCustList();
this.txt_cust.Invoke((MethodInvoker) delegate
{
txt_cust.Bind(cust, 350, 200, "supcust_no", "supcust_no:编号:80,sup_name:名称:200", "supcust_no/sup_name->Text");
});
IBLL.IInOutBLL bll3 = new BLL.InOutBLL();
var order = bll3.GetImportSSSheet();
this.txt_voucher_no.Invoke((MethodInvoker) delegate
{
this.txt_voucher_no.Bind(order, 350, 200, "sheet_no", "sheet_no:单据号:110,supcust:客户:100,branch:仓库:100,oper_date:日期:150", "sheet_no->Text");
});
this.Invoke((MethodInvoker) delegate
{
IOrder ins = this;
ins.Add();
});
}
catch (Exception ex)
{
IvyBack.Helper.LogHelper.writeLog("frmSaleSheet", ex.ToString());
MsgForm.ShowFrom(ex);
}
Cursor.Current = Cursors.Default;
Helper.GlobalData.windows.CloseLoad(this);
});
th.Start();
}
catch (Exception ex)
{
MsgForm.ShowFrom(ex);
Helper.LogHelper.writeLog("frmSaleSheet()", ex.ToString());
}
finally
{
System.Windows.Forms.Cursor.Current = System.Windows.Forms.Cursors.Default;
}
}
void IServiceBase.Request(string t, string pars, out string res)
{
try
{
ReadWriteContext.IReadContext r = new ReadWriteContext.ReadContextByJson(pars);
var kv = r.ToDictionary();
IBLL.IInOutBLL bll = new BLL.InOutBLL();
if (t == "get_salesheet_list")
{
string date1 = r.Read("date1");
string date2 = r.Read("date2");
string cust_id = r.Read("cust_id");
string sale_man = r.Read("sale_man");
var tb = bll.GetSaleSheetList(date1, date2, cust_id, sale_man);
ReadWriteContext.IWriteContext w = new ReadWriteContext.WriteContextByJson();
w.Append("errId", "0");
w.Append("errMsg", "");
w.Append("data", tb);
res = w.ToString();
}
else if (t == "get_simple_salesheet_list")
{
string date1 = r.Read("date1");
string date2 = r.Read("date2");
string cust_id = r.Read("cust_id");
var tb = bll.GetSimpleSaleSheetList(date1, date2, cust_id);
ReadWriteContext.IWriteContext w = new ReadWriteContext.WriteContextByJson();
w.Append("errId", "0");
w.Append("errMsg", "");
w.Append("data", tb);
res = w.ToString();
}
else if (t == "get_salesheet")
{
string sheet_no = r.Read("sheet_no");
System.Data.DataTable tb1;
System.Data.DataTable tb2;
bll.GetSaleSheet(sheet_no, out tb1, out tb2);
ReadWriteContext.IWriteContext w = new ReadWriteContext.WriteContextByJson();
w.Append("errId", "0");
w.Append("errMsg", "");
w.Append("tb1", tb1);
w.Append("tb2", tb2);
res = w.ToString();
}
else if (t == "add_salesheet")
{
var ord = new Model.sm_t_salesheet();
ord.sheet_no = r.Read("sheet_no");
ord.voucher_no = r.Read("voucher_no");
ord.branch_no = r.Read("branch_no");
ord.cust_no = r.Read("cust_no");
ord.pay_way = r.Read("pay_way");
ord.discount = Helper.Conv.ToDecimal(r.Read("discount"));
ord.coin_no = r.Read("coin_no");
ord.real_amount = Helper.Conv.ToDecimal(r.Read("real_amount"));
ord.total_amount = Helper.Conv.ToDecimal(r.Read("total_amount"));
ord.paid_amount = Helper.Conv.ToDecimal(r.Read("paid_amount"));
ord.approve_flag = "0";
ord.source_flag = "";
ord.oper_id = r.Read("oper_id");
ord.sale_man = r.Read("sale_man");
ord.oper_date = Helper.Conv.ToDateTime(r.Read("oper_date"));
ord.pay_date = Helper.Conv.ToDateTime(r.Read("pay_date"));
ord.other1 = r.Read("other1");
ord.other2 = r.Read("other2");
ord.other3 = r.Read("other3");
ord.cm_branch = r.Read("cm_branch");
ord.approve_man = "";
ord.approve_date = DateTime.MinValue;
ord.num1 = Helper.Conv.ToDecimal(r.Read("num1"));
ord.num2 = Helper.Conv.ToDecimal(r.Read("num2"));
ord.num3 = Helper.Conv.ToDecimal(r.Read("num3"));
ord.payfee_memo = r.Read("payfee_memo");
ord.old_no = "";
ord.psheet_no = r.Read("psheet_no");
ord.pay_nowmark = r.Read("pay_nowmark");
ord.if_back = r.Read("if_back");
ord.cust_cls = "";
ord.other4 = r.Read("other4");
List <Model.sm_t_salesheet_detail> lines = new List <Model.sm_t_salesheet_detail>();
foreach (ReadWriteContext.IReadContext r2 in r.ReadList("lines"))
{
var item = new Model.sm_t_salesheet_detail();
item.sheet_no = r2.Read("sheet_no");
item.item_no = r2.Read("item_no");
item.item_name = r2.Read("item_name");
item.unit_no = r2.Read("unit_no");
item.unit_factor = Helper.Conv.ToDecimal(r2.Read("unit_factor"));
item.sale_qnty = Helper.Conv.ToDecimal(r2.Read("sale_qnty"));
item.sale_price = Helper.Conv.ToDecimal(r2.Read("sale_price"));
item.real_price = Helper.Conv.ToDecimal(r2.Read("real_price"));
item.cost_price = Helper.Conv.ToDecimal(r2.Read("cost_price"));
item.sale_money = Helper.Conv.ToDecimal(r2.Read("sale_money"));
item.sale_tax = Helper.Conv.ToDecimal(r2.Read("sale_tax"));
item.is_tax = r2.Read("is_tax");
item.other1 = r2.Read("other1");
item.other2 = r2.Read("other2");
item.other3 = r2.Read("other3");
item.other4 = r2.Read("other4");
item.num1 = Helper.Conv.ToDecimal(r2.Read("num1"));
item.num2 = Helper.Conv.ToDecimal(r2.Read("num2"));
item.num3 = Helper.Conv.ToDecimal(r2.Read("num3"));
item.num4 = Helper.Conv.ToDecimal(r2.Read("num4"));
item.num5 = Helper.Conv.ToDecimal(r2.Read("num5"));
item.num6 = Helper.Conv.ToDecimal(r2.Read("num6"));
item.barcode = r2.Read("barcode");
item.sheet_sort = Helper.Conv.ToInt(r2.Read("sheet_sort"));
item.ret_qnty = Helper.Conv.ToDecimal(r2.Read("ret_qnty"));
item.discount = Helper.Conv.ToDecimal(r2.Read("discount"));
item.voucher_no = r2.Read("voucher_no");
item.cost_notax = Helper.Conv.ToDecimal(r2.Read("cost_notax"));
item.packqty = Helper.Conv.ToInt(r2.Read("packqty"));
item.sgqty = Helper.Conv.ToDecimal(r2.Read("sgqty"));
item.branch_no_d = "";
item.ly_sup_no = "";
item.ly_rate = 0M;
item.num7 = Helper.Conv.ToDecimal(r2.Read("num7"));
item.other5 = r2.Read("other5");
item.num8 = Helper.Conv.ToDecimal(r2.Read("num8"));
item.produce_day = DateTime.MinValue;
lines.Add(item);
}
string sheet_no = "";
bll.AddSaleSheet(ord, lines, out sheet_no);
ReadWriteContext.IWriteContext w = new ReadWriteContext.WriteContextByJson();
w.Append("errId", "0");
w.Append("errMsg", "");
w.Append("sheet_no", sheet_no);
res = w.ToString();
}
else if (t == "change_salesheet")
{
var ord = new Model.sm_t_salesheet();
ord.sheet_no = r.Read("sheet_no");
ord.voucher_no = r.Read("voucher_no");
ord.branch_no = r.Read("branch_no");
ord.cust_no = r.Read("cust_no");
ord.pay_way = r.Read("pay_way");
ord.discount = Helper.Conv.ToDecimal(r.Read("discount"));
ord.coin_no = r.Read("coin_no");
ord.real_amount = Helper.Conv.ToDecimal(r.Read("real_amount"));
ord.total_amount = Helper.Conv.ToDecimal(r.Read("total_amount"));
ord.paid_amount = Helper.Conv.ToDecimal(r.Read("paid_amount"));
ord.approve_flag = "0";
ord.source_flag = "";
ord.oper_id = r.Read("oper_id");
ord.sale_man = r.Read("sale_man");
ord.oper_date = Helper.Conv.ToDateTime(r.Read("oper_date"));
ord.pay_date = DateTime.MinValue;
ord.other1 = r.Read("other1");
ord.other2 = r.Read("other2");
ord.other3 = r.Read("other3");
ord.cm_branch = r.Read("cm_branch");
ord.approve_man = "";
ord.approve_date = DateTime.MinValue;
ord.num1 = Helper.Conv.ToDecimal(r.Read("num1"));
ord.num2 = Helper.Conv.ToDecimal(r.Read("num2"));
ord.num3 = Helper.Conv.ToDecimal(r.Read("num3"));
ord.payfee_memo = r.Read("payfee_memo");
ord.old_no = "";
ord.psheet_no = r.Read("psheet_no");
ord.pay_nowmark = r.Read("pay_nowmark");
ord.if_back = r.Read("if_back");
ord.cust_cls = "";
ord.other4 = r.Read("other4");
ord.update_time = Helper.Conv.ToDateTime(r.Read("update_time"));
List <Model.sm_t_salesheet_detail> lines = new List <Model.sm_t_salesheet_detail>();
foreach (ReadWriteContext.IReadContext r2 in r.ReadList("lines"))
{
var item = new Model.sm_t_salesheet_detail();
item.sheet_no = r2.Read("sheet_no");
item.item_no = r2.Read("item_no");
item.item_name = r2.Read("item_name");
item.unit_no = r2.Read("unit_no");
item.unit_factor = Helper.Conv.ToDecimal(r2.Read("unit_factor"));
item.sale_qnty = Helper.Conv.ToDecimal(r2.Read("sale_qnty"));
item.sale_price = Helper.Conv.ToDecimal(r2.Read("sale_price"));
item.real_price = Helper.Conv.ToDecimal(r2.Read("real_price"));
item.cost_price = Helper.Conv.ToDecimal(r2.Read("cost_price"));
item.sale_money = Helper.Conv.ToDecimal(r2.Read("sale_money"));
item.sale_tax = Helper.Conv.ToDecimal(r2.Read("sale_tax"));
item.is_tax = r2.Read("is_tax");
item.other1 = r2.Read("other1");
item.other2 = r2.Read("other2");
item.other3 = r2.Read("other3");
item.other4 = r2.Read("other4");
item.num1 = Helper.Conv.ToDecimal(r2.Read("num1"));
item.num2 = Helper.Conv.ToDecimal(r2.Read("num2"));
item.num3 = Helper.Conv.ToDecimal(r2.Read("num3"));
item.num4 = Helper.Conv.ToDecimal(r2.Read("num4"));
item.num5 = Helper.Conv.ToDecimal(r2.Read("num5"));
item.num6 = Helper.Conv.ToDecimal(r2.Read("num6"));
item.barcode = r2.Read("barcode");
item.sheet_sort = Helper.Conv.ToInt(r2.Read("sheet_sort"));
item.ret_qnty = Helper.Conv.ToDecimal(r2.Read("ret_qnty"));
item.discount = Helper.Conv.ToDecimal(r2.Read("discount"));
item.voucher_no = r2.Read("voucher_no");
item.cost_notax = Helper.Conv.ToDecimal(r2.Read("cost_notax"));
item.packqty = Helper.Conv.ToInt(r2.Read("packqty"));
item.sgqty = Helper.Conv.ToDecimal(r2.Read("sgqty"));
item.branch_no_d = "";
item.ly_sup_no = "";
item.ly_rate = 0M;
item.num7 = Helper.Conv.ToDecimal(r2.Read("num7"));
item.other5 = r2.Read("other5");
item.num8 = Helper.Conv.ToDecimal(r2.Read("num8"));
item.produce_day = DateTime.MinValue;
lines.Add(item);
}
bll.ChangeSaleSheet(ord, lines);
ReadWriteContext.IWriteContext w = new ReadWriteContext.WriteContextByJson();
w.Append("errId", "0");
w.Append("errMsg", "");
res = w.ToString();
}
else if (t == "delete_salesheet")
{
string sheet_no = r.Read("sheet_no");
var update_time = Helper.Conv.ToDateTime(r.Read("update_time"));
bll.DeleteSaleSheet(sheet_no, update_time);
ReadWriteContext.IWriteContext w = new ReadWriteContext.WriteContextByJson();
w.Append("errId", "0");
w.Append("errMsg", "");
res = w.ToString();
}
else if (t == "check_salesheet")
{
string sheet_no = r.Read("sheet_no");
string approve_man = r.Read("approve_man");
var update_time = Helper.Conv.ToDateTime(r.Read("update_time"));
bll.CheckSaleSheet(sheet_no, approve_man, update_time);
ReadWriteContext.IWriteContext w = new ReadWriteContext.WriteContextByJson();
w.Append("errId", "0");
w.Append("errMsg", "");
res = w.ToString();
}
else if (t == "get_inout_list")
{
string date1 = r.Read("date1");
string date2 = r.Read("date2");
string supcust_no = r.Read("supcust_no");
string trans_no = r.Read("trans_no");
var tb = bll.GetInOutList(date1, date2, supcust_no, trans_no);
ReadWriteContext.IWriteContext w = new ReadWriteContext.WriteContextByJson();
w.Append("errId", "0");
w.Append("errMsg", "");
w.Append("data", tb);
res = w.ToString();
}
else if (t == "get_simple_inout_list")
{
string date1 = r.Read("date1");
string date2 = r.Read("date2");
string supcust_no = r.Read("supcust_no");
string trans_no = r.Read("trans_no");
var tb = bll.GetSimpleInOutList(date1, date2, supcust_no, trans_no);
ReadWriteContext.IWriteContext w = new ReadWriteContext.WriteContextByJson();
w.Append("errId", "0");
w.Append("errMsg", "");
w.Append("data", tb);
res = w.ToString();
}
else if (t == "get_other_inout_list")
{
string date1 = r.Read("date1");
string date2 = r.Read("date2");
string trans_no = r.Read("trans_no");
var tb = bll.GetOtherInOutList(date1, date2, trans_no);
ReadWriteContext.IWriteContext w = new ReadWriteContext.WriteContextByJson();
w.Append("errId", "0");
w.Append("errMsg", "");
w.Append("data", tb);
res = w.ToString();
}
else if (t == "get_inout")
{
string sheet_no = r.Read("sheet_no");
string trans_no = r.Read("trans_no");
System.Data.DataTable tb1;
System.Data.DataTable tb2;
bll.GetInOut(sheet_no, trans_no, out tb1, out tb2);
ReadWriteContext.IWriteContext w = new ReadWriteContext.WriteContextByJson();
w.Append("errId", "0");
w.Append("errMsg", "");
w.Append("tb1", tb1);
w.Append("tb2", tb2);
res = w.ToString();
}
else if (t == "get_other_inout")
{
string sheet_no = r.Read("sheet_no");
System.Data.DataTable tb1;
System.Data.DataTable tb2;
bll.GetInOut(sheet_no, out tb1, out tb2);
ReadWriteContext.IWriteContext w = new ReadWriteContext.WriteContextByJson();
w.Append("errId", "0");
w.Append("errMsg", "");
w.Append("tb1", tb1);
w.Append("tb2", tb2);
res = w.ToString();
}
else if (t == "add_inout")
{
var ord = new Model.ic_t_inout_store_master();
ord.sheet_no = r.Read("sheet_no");
ord.trans_no = r.Read("trans_no");
ord.branch_no = r.Read("branch_no");
ord.d_branch_no = r.Read("d_branch_no");
ord.voucher_no = r.Read("voucher_no");
ord.supcust_no = r.Read("supcust_no");
ord.total_amount = Helper.Conv.ToDecimal(r.Read("total_amount"));
ord.inout_amount = Helper.Conv.ToDecimal(r.Read("inout_amount"));
ord.coin_no = r.Read("coin_no");
ord.pay_way = r.Read("pay_way");
ord.tax_amount = Helper.Conv.ToDecimal(r.Read("tax_amount"));
ord.discount = Helper.Conv.ToDecimal(r.Read("discount"));
ord.pay_date = Helper.Conv.ToDateTime(r.Read("pay_date"));
ord.approve_flag = "0";
ord.oper_date = Helper.Conv.ToDateTime(r.Read("oper_date"));
ord.oper_id = r.Read("oper_id");
ord.display_flag = "1";
ord.other1 = r.Read("other1");
ord.other2 = r.Read("other2");
ord.other3 = r.Read("other3");
ord.cm_branch = r.Read("cm_branch"); //不确定
ord.deal_man = r.Read("deal_man");
ord.old_no = "";
ord.approve_man = r.Read("approve_man");
ord.approve_date = DateTime.MinValue;
ord.num1 = Helper.Conv.ToDecimal(r.Read("num1"));
ord.num2 = Helper.Conv.ToDecimal(r.Read("num2"));
ord.num3 = Helper.Conv.ToDecimal(r.Read("num3"));
ord.max_change = 0m; //不确定
ord.sale_no = r.Read("sale_no");
ord.lock_man = "";
ord.lock_date = DateTime.MinValue;
List <Model.ic_t_inout_store_detail> lines = new List <Model.ic_t_inout_store_detail>();
foreach (ReadWriteContext.IReadContext r2 in r.ReadList("lines"))
{
var item = new Model.ic_t_inout_store_detail();
item.sheet_no = r2.Read("sheet_no");
item.item_no = r2.Read("item_no");
item.item_name = r2.Read("item_name");
item.unit_no = r2.Read("unit_no");
item.unit_factor = Helper.Conv.ToDecimal(r2.Read("unit_factor"));
item.in_qty = Helper.Conv.ToDecimal(r2.Read("in_qty"));
item.orgi_price = Helper.Conv.ToDecimal(r2.Read("orgi_price"));
item.valid_price = Helper.Conv.ToDecimal(r2.Read("valid_price"));
item.cost_price = Helper.Conv.ToDecimal(r2.Read("cost_price"));
item.sub_amount = Helper.Conv.ToDecimal(r2.Read("sub_amount"));
item.tax = Helper.Conv.ToDecimal(r2.Read("tax"));
item.is_tax = r2.Read("is_tax");
item.valid_date = Helper.Conv.ToDateTime(r2.Read("valid_date"));
item.other1 = r2.Read("other1");
item.other2 = r2.Read("other2");
item.other3 = r2.Read("other3");
item.num1 = Helper.Conv.ToDecimal(r2.Read("num1"));
item.num2 = Helper.Conv.ToDecimal(r2.Read("num2"));
item.num3 = Helper.Conv.ToDecimal(r2.Read("num3"));
item.num4 = Helper.Conv.ToDecimal(r2.Read("num4"));
item.num5 = Helper.Conv.ToDecimal(r2.Read("num5"));
item.num6 = Helper.Conv.ToDecimal(r2.Read("num6"));
item.barcode = r2.Read("barcode");
item.sheet_sort = Helper.Conv.ToInt(r2.Read("sheet_sort"));
item.ret_qnty = Helper.Conv.ToDecimal(r2.Read("ret_qnty"));
item.discount = Helper.Conv.ToDecimal(r2.Read("discount"));
item.voucher_no = r2.Read("voucher_no");
item.cost_notax = 0m; //不确定
item.packqty = Helper.Conv.ToInt(r2.Read("packqty"));
item.sgqty = Helper.Conv.ToDecimal(r2.Read("sgqty"));
item.branch_no_d = "";
item.ly_sup_no = "";
item.ly_rate = 0m;
lines.Add(item);
}
string sheet_no = "";
bll.AddInOut(ord, lines, out sheet_no);
ReadWriteContext.IWriteContext w = new ReadWriteContext.WriteContextByJson();
w.Append("errId", "0");
w.Append("errMsg", "");
w.Append("sheet_no", sheet_no);
res = w.ToString();
}
else if (t == "change_inout")
{
var ord = new Model.ic_t_inout_store_master();
ord.sheet_no = r.Read("sheet_no");
ord.trans_no = r.Read("trans_no");
ord.branch_no = r.Read("branch_no");
ord.d_branch_no = "";
ord.db_no = r.Read("db_no");
ord.voucher_no = r.Read("voucher_no");
ord.supcust_no = r.Read("supcust_no");
ord.total_amount = Helper.Conv.ToDecimal(r.Read("total_amount"));
ord.inout_amount = Helper.Conv.ToDecimal(r.Read("inout_amount"));
ord.coin_no = "RMB";
ord.pay_way = r.Read("pay_way");
ord.tax_amount = Helper.Conv.ToDecimal(r.Read("tax_amount"));
ord.discount = Helper.Conv.ToDecimal(r.Read("discount"));
ord.pay_date = Helper.Conv.ToDateTime(r.Read("pay_date"));
ord.approve_flag = "0";
ord.oper_date = Helper.Conv.ToDateTime(r.Read("oper_date"));
ord.oper_id = r.Read("oper_id");
ord.display_flag = "1";
ord.other1 = r.Read("other1");
ord.other2 = r.Read("other2");
ord.other3 = r.Read("other3");
ord.cm_branch = r.Read("cm_branch"); //不确定
ord.deal_man = r.Read("deal_man");
ord.old_no = "";
ord.approve_man = r.Read("approve_man");
ord.approve_date = DateTime.MinValue;
ord.num1 = Helper.Conv.ToDecimal(r.Read("num1"));
ord.num2 = Helper.Conv.ToDecimal(r.Read("num2"));
ord.num3 = Helper.Conv.ToDecimal(r.Read("num3"));
ord.max_change = 0m; //不确定
ord.sale_no = r.Read("sale_no");
ord.lock_man = "";
ord.lock_date = DateTime.MinValue;
ord.update_time = Helper.Conv.ToDateTime(r.Read("update_time"));
List <Model.ic_t_inout_store_detail> lines = new List <Model.ic_t_inout_store_detail>();
foreach (ReadWriteContext.IReadContext r2 in r.ReadList("lines"))
{
var item = new Model.ic_t_inout_store_detail();
item.sheet_no = r2.Read("sheet_no");
item.item_no = r2.Read("item_no");
item.item_name = r2.Read("item_name");
item.unit_no = r2.Read("unit_no");
item.unit_factor = Helper.Conv.ToDecimal(r2.Read("unit_factor"));
item.in_qty = Helper.Conv.ToDecimal(r2.Read("in_qty"));
item.orgi_price = Helper.Conv.ToDecimal(r2.Read("orgi_price"));
item.valid_price = Helper.Conv.ToDecimal(r2.Read("valid_price"));
item.cost_price = Helper.Conv.ToDecimal(r2.Read("cost_price"));
item.sub_amount = Helper.Conv.ToDecimal(r2.Read("sub_amount"));
item.tax = Helper.Conv.ToDecimal(r2.Read("tax"));
item.is_tax = r2.Read("is_tax");
item.valid_date = Helper.Conv.ToDateTime(r2.Read("valid_date"));
item.other1 = r2.Read("other1");
item.other2 = r2.Read("other2");
item.other3 = r2.Read("other3");
item.num1 = Helper.Conv.ToDecimal(r2.Read("num1"));
item.num2 = Helper.Conv.ToDecimal(r2.Read("num2"));
item.num3 = Helper.Conv.ToDecimal(r2.Read("num3"));
item.num4 = Helper.Conv.ToDecimal(r2.Read("num4"));
item.num5 = Helper.Conv.ToDecimal(r2.Read("num5"));
item.num6 = Helper.Conv.ToDecimal(r2.Read("num6"));
item.barcode = r2.Read("barcode");
item.sheet_sort = Helper.Conv.ToInt(r2.Read("sheet_sort"));
item.ret_qnty = Helper.Conv.ToDecimal(r2.Read("ret_qnty"));
item.discount = Helper.Conv.ToDecimal(r2.Read("discount"));
item.voucher_no = r2.Read("voucher_no");
item.cost_notax = 0m; //不确定
item.packqty = Helper.Conv.ToInt(r2.Read("packqty"));
item.sgqty = Helper.Conv.ToDecimal(r2.Read("sgqty"));
item.branch_no_d = "";
item.ly_sup_no = "";
item.ly_rate = 0m;
lines.Add(item);
}
bll.ChangeInOut(ord, lines);
ReadWriteContext.IWriteContext w = new ReadWriteContext.WriteContextByJson();
w.Append("errId", "0");
w.Append("errMsg", "");
res = w.ToString();
}
else if (t == "delete_inout")
{
string sheet_no = r.Read("sheet_no");
var update_time = Helper.Conv.ToDateTime(r.Read("update_time"));
bll.DeleteInOut(sheet_no, update_time);
ReadWriteContext.IWriteContext w = new ReadWriteContext.WriteContextByJson();
w.Append("errId", "0");
w.Append("errMsg", "");
res = w.ToString();
}
else if (t == "check_inout")
{
string sheet_no = r.Read("sheet_no");
string approve_man = r.Read("approve_man");
var update_time = Helper.Conv.ToDateTime(r.Read("update_time"));
bll.CheckInOut(sheet_no, approve_man, update_time);
ReadWriteContext.IWriteContext w = new ReadWriteContext.WriteContextByJson();
w.Append("errId", "0");
w.Append("errMsg", "");
res = w.ToString();
}
else
{
throw new Exception("未找到方法[" + t + "]");
}
}
catch (Exception ex)
{
ReadWriteContext.IWriteContext w = new ReadWriteContext.WriteContextByJson();
w.Append("errId", "-1");
w.Append("errMsg", ex.Message);
LogHelper.writeLog("inout()", ex.ToString(), t, pars);
res = w.ToString();
}
}
private void refreshData()
{
try
{
System.Windows.Forms.Cursor.Current = System.Windows.Forms.Cursors.WaitCursor;
//
DateTime date1 = Helper.Conv.ToDateTime(dateTextBox1.Text.Trim());
DateTime date2 = Helper.Conv.ToDateTime(dateTextBox2.Text.Trim());
string txt_sup = txt_sup_id.Text.Split('/')[0].Trim();
Thread th = new Thread(() =>
{
Helper.GlobalData.windows.ShowLoad(this);
try
{
IBLL.IInOutBLL bll = new BLL.InOutBLL();
if (date1 == DateTime.MinValue)
{
throw new Exception("期间不正确");
}
if (date2 == DateTime.MinValue)
{
throw new Exception("期间不正确");
}
var tb = bll.GetCGOrderList(date1, date2, txt_sup, "");
this.dataGrid1.Invoke((MethodInvoker) delegate
{
this.dataGrid1.DataSource = tb;
if (tb.Rows.Count > 0)
{
sheet_no = tb.Rows[0]["sheet_no"].ToString();
trans_no = tb.Rows[0]["trans_no"].ToString();
System.Data.DataTable tb1;
System.Data.DataTable tb2;
bll.GetCGOrder(sheet_no, out tb1, out tb2);
this.dataGrid2.DataSource = tb2;
update_time = Helper.Conv.ToDateTime(tb1.Rows[0]["update_time"]);
}
});
}
catch (Exception ex)
{
LogHelper.writeLog("refreshData", ex.ToString());
MsgForm.ShowFrom(ex);
}
Helper.GlobalData.windows.CloseLoad(this);
});
th.Start();
}
catch (Exception ex)
{
MsgForm.ShowFrom(ex);
Helper.LogHelper.writeLog("frmCGInSheetList->refreshData()", ex.ToString());
}
finally
{
System.Windows.Forms.Cursor.Current = System.Windows.Forms.Cursors.Default;
}
}
void IOrder.ShowOrder(string sheet_no)
{
try
{
System.Windows.Forms.Cursor.Current = System.Windows.Forms.Cursors.WaitCursor;
//
RunType = 2;
IBLL.IInOutBLL bll = new BLL.InOutBLL();
DataTable tb1;
DataTable tb2;
bll.GetCGOrder(sheet_no, out tb1, out tb2);
//
//
var r1 = tb1.Rows[0];
update_time = Helper.Conv.ToDateTime(r1["update_time"]);
this.sheet_no = sheet_no;
if (r1["branch_no"].ToString() == "")
{
txtbranch.Text = "";
}
else
{
txtbranch.Text = r1["branch_no"].ToString() + "/" + r1["branch_name"].ToString();
}
txtsheet_no.Text = r1["sheet_no"].ToString();
txtoper_date.Text = Helper.Conv.ToDateTime(r1["oper_date"].ToString()).ToString("yyyy-MM-dd");
if (r1["order_man"].ToString() == "")
{
txt_order_man.Text = "";
}
else
{
txt_order_man.GetValue("oper_id", r1["order_man"].ToString());
}
if (r1["approve_man"].ToString() == "")
{
txtapprove_man.Text = "";
}
else
{
txtapprove_man.Text = r1["approve_man"].ToString() + "/" + r1["approve_man_name"].ToString();
}
if (r1["oper_id"].ToString() == "")
{
txtoper_man.Text = "";
}
else
{
txtoper_man.Text = r1["oper_id"] + "/" + r1["oper_name"];
}
txtapprove_date.Text = Helper.Conv.ToDateTime(r1["approve_date"]).ToString("yyyy-MM-dd");
txt_valid_date.Text = Helper.Conv.ToDateTime(r1["valid_date"]).ToString("yyyy-MM-dd");
txt_sup.Text = r1["sup_no"].ToString() + "/" + r1["sup_name"].ToString();
txt_memo.Text = r1["memo"].ToString();
//
editGrid1.DataSource = tb2;
Dictionary <string, object> dic = this.Tag as Dictionary <string, object>;
this.Tag = Helper.Conv.ControlsAdds(this, dic);
}
catch (Exception ex)
{
MsgForm.ShowFrom("加载采购订单异常[" + ex.Message + "]");
Helper.LogHelper.writeLog("frmCGOrder->ShowOrder()", ex.ToString(), sheet_no);
}
finally
{
System.Windows.Forms.Cursor.Current = System.Windows.Forms.Cursors.Default;
}
}
private void SaveSheet()
{
if (curr_cust == null || string.IsNullOrEmpty(curr_cust.supcust_no))
{
MsgForm.ShowFrom("请选择客户!");
return;
}
if (sale_detail.Rows.Count < 1)
{
MsgForm.ShowFrom("请输入明细!");
return;
}
co_t_order_main ord = new co_t_order_main();
List <co_t_order_child> lines = new List <co_t_order_child>();
ord.sheet_no = "";
ord.trans_no = "S";
ord.order_status = "0";
ord.sale_way = "A";
ord.coin_code = "RMB";
ord.branch_no = sale_master.branch_no;
ord.p_sheet_no = "";
ord.sup_no = sale_master.sup_no;
ord.paid_amount = 0;
ord.oper_date = sale_master.oper_date;
ord.oper_id = Program.oper.oper_id;
ord.order_man = "00";
ord.approve_flag = "0";
ord.other1 = "";
ord.other2 = "";
ord.cm_branch = "00";
ord.approve_man = "";
ord.approve_date = System.DateTime.MinValue;
ord.num1 = 0;
ord.num2 = 0;
ord.num3 = 0;
ord.valid_date = sale_master.oper_date.AddMonths(1);
ord.memo = sale_master.memo;
int index = 0;
decimal total_amt = 0;
foreach (DataRow row in sale_detail.Rows)
{
++index;
if (row["item_no"].ToString() != "")
{
co_t_order_child line = new co_t_order_child();
lines.Add(line);
line.sheet_no = ord.sheet_no;
line.item_no = row["item_no"].ToString();
line.unit_no = row["unit_no"].ToString();
line.barcode = row["barcode"].ToString();
line.unit_factor = 1;
line.order_qnty = Helper.Conv.ToDecimal(row["order_qnty"].ToString());
line.in_price = Helper.Conv.ToDecimal(row["in_price"].ToString());
line.real_qty = 0;
line.sub_amount = Helper.Conv.ToDecimal(row["sub_amount"].ToString());
line.sheet_sort = index;
line.discount = 1;
line.other1 = row["other1"].ToString();
line.other2 = "";
line.other3 = "0";
line.voucher_no = "";
line.sheet_sort = index;
line.num1 = 0;
line.num2 = 0;
line.num3 = 0;
line.packqty = 0;
line.sgqty = 0;
total_amt += line.in_price * line.order_qnty;
}
}
ord.total_amount = total_amt;
ord.paid_amount = 0;
string sheet_no;
IBLL.IInOutBLL bll = new BLL.InOutBLL();
bll.AddSaleSSSheet(ord, lines, out sheet_no);
NewSheet();
}
public frmCGInSheet()
{
InitializeComponent();
//
Helper.GlobalData.InitForm(this);
//
var tb = new DataTable();
tb.Columns.Add("item_no");
tb.Columns.Add("item_subno");
tb.Columns.Add("barcode");
tb.Columns.Add("item_name");
tb.Columns.Add("unit_no");
tb.Columns.Add("item_size");
tb.Columns.Add("other3");
tb.Columns.Add("in_qty", typeof(decimal));
tb.Columns.Add("valid_price", typeof(decimal));
tb.Columns.Add("discount", typeof(decimal));
tb.Columns.Add("sub_amount", typeof(decimal));
tb.Columns.Add("other1");
tb.Columns.Add("valid_date", typeof(DateTime));
tb.Columns.Add("price", typeof(decimal));//参考进价
editGrid1.AddColumn("item_subno", "货号", "", 100, 1, "", true);
editGrid1.AddColumn("item_name", "商品名称", "", 150, 1, "", false);
editGrid1.AddColumn("unit_no", "单位", "", 60, 2, "", false);
editGrid1.AddColumn("item_size", "规格", "", 80, 1, "", false);
editGrid1.AddColumn("in_qty", "数量", "", 100, 3, "0.00", true);
editGrid1.AddColumn("valid_price", "单价", "", 100, 3, "0.00", true);
editGrid1.AddColumn("discount", "折扣", "", 100, 3, "0.00", true);
editGrid1.AddColumn("sub_amount", "金额", "", 100, 3, "0.00", false);
editGrid1.AddColumn("other1", "备注", "", 150, 1, "", true);
editGrid1.AddColumn("valid_date", "有效期", "", 100, 1, "yyyy-MM-dd", true);
editGrid1.AddColumn("price", "参考进价", "", 100, 3, "0.00", false);
editGrid1.SetTotalColumn("in_qty,sub_amount");//合计项
editGrid1.DataSource = tb;
editGrid1.IsShowIco = true;
//
try
{
System.Windows.Forms.Cursor.Current = System.Windows.Forms.Cursors.WaitCursor;
//
Thread th = new Thread(() =>
{
Helper.GlobalData.windows.ShowLoad(this);
try
{
IBLL.ICommonBLL bll2 = new BLL.CommonBLL();
var branch_tb = bll2.GetBranchList();
this.txtbranch.Invoke((MethodInvoker) delegate
{
txtbranch.Bind(branch_tb, 300, 200, "branch_no", "branch_no:编号:80,branch_name:名称:140", "branch_no/branch_name->Text");
});
DataTable dt2 = new DataTable();
dt2.Columns.Add("sale_no");
dt2.Columns.Add("sale_name");
dt2.Rows.Add("A", "购销");
dt2.Rows.Add("B", "代销");
dt2.Rows.Add("C", "联营");
dt2.Rows.Add("E", "联营进货");
dt2.Rows.Add("Z", "租赁");
this.txt_sale_no.Invoke((MethodInvoker) delegate
{
txt_sale_no.Bind(dt2, 250, 200, "sale_no", "sale_no:编码:80,sale_name:代销方式:100", "sale_no/sale_name->Text");
});
var sup_tb = bll2.GetAllSupList();
this.txt_sup.Invoke((MethodInvoker) delegate
{
txt_sup.Bind(sup_tb, 350, 200, "supcust_no", "supcust_no:编号:80,sup_name:名称:200", "supcust_no/sup_name->Text");
});
var deal_tb = bll2.GetPeopleList();
this.txt_deal_man.Invoke((MethodInvoker) delegate
{
txt_deal_man.Bind(deal_tb, 250, 200, "oper_id", "oper_id:编号:80,oper_name:姓名:100", "oper_id/oper_name->Text");
});
IBLL.IInOutBLL bll3 = new BLL.InOutBLL();
var order = bll3.GetImportCGOrder();
this.txt_voucher_no.Invoke((MethodInvoker) delegate
{
this.txt_voucher_no.Bind(order, 350, 200, "sheet_no", "sheet_no:单据号:110,supcust:供应商:100,branch:仓库:100,oper_date:日期:150", "sheet_no->Text");
});
this.Invoke((MethodInvoker) delegate
{
IOrder ins = this;
ins.Add();
});
}
catch (Exception ex)
{
LogHelper.writeLog("frmCGInSheet", ex.ToString());
MsgForm.ShowFrom(ex);
}
Helper.GlobalData.windows.CloseLoad(this);
});
th.Start();
}
catch (Exception ex)
{
MsgForm.ShowFrom(ex);
Helper.LogHelper.writeLog("frmCGInSheet()", ex.ToString());
}
finally
{
System.Windows.Forms.Cursor.Current = System.Windows.Forms.Cursors.Default;
}
}
