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();
}
public void GetPrintTb()
{
if (string.IsNullOrEmpty(this.txtsheet_no.Text))
{
throw new Exception("请选择单据!");
}
IBLL.IInOutBLL bll = new BLL.InOutBLL();
DataTable tb1;
DataTable tb2;
bll.GetCGOrder(this.txtsheet_no.Text, out tb1, out tb2);
PrintForm.PrintHelper.tb_main = tb1;
PrintForm.PrintHelper.tb_detail = tb2;
}
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());
}
}
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 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;
}
}
