private void tsbDel_Click(object sender, EventArgs e)
{
try
{
if (!MyLove.PermissionsBalidation(this.Text, "02"))
{
return;
}
if (txtsheet_no.Text.Trim() != "")
{
string sheet_no = txtsheet_no.Text.Trim();
if (YesNoForm.ShowFrom("确认删除单据" + sheet_no + "?") == DialogResult.Yes)
{
IBLL.ISupSettle bll = new BLL.SupSettle();
bll.Delete(sheet_no);
IOrder ins = this;
ins.Add();
}
}
}
catch (Exception ex)
{
MsgForm.ShowFrom(ex);
}
}
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.ISupSettle bll = new BLL.SupSettle();
bll.Check(sheet_no, Program.oper.oper_id);
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);
}
}
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.ISupSettle bll = new BLL.SupSettle();
bll.Delete(sheet_no);
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);
}
}
public void GetPrintTb()
{
if (string.IsNullOrEmpty(this.txtsheet_no.Text))
{
throw new Exception("请选择单据!");
}
IBLL.ISupSettle bll = new BLL.SupSettle();
DataTable tb1;
DataTable tb2;
bll.GetOrder(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())
{
System.Threading.Thread th = new System.Threading.Thread(() =>
{
Cursor.Current = Cursors.WaitCursor;
Helper.GlobalData.windows.ShowLoad(this);
try
{
sheet_no = row["sheet_no"].ToString();
IBLL.ISupSettle bll = new BLL.SupSettle();
System.Data.DataTable tb1;
System.Data.DataTable tb2;
bll.GetOrder(sheet_no, out tb1, out tb2);
this.dataGrid2.Invoke((MethodInvoker) delegate
{
this.dataGrid2.DataSource = tb2;
this.dataGrid2.Refresh();
});
}
catch (Exception ex)
{
IvyBack.Helper.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);
}
}
private void tsbCheck_Click(object sender, EventArgs e)
{
try
{
if (!MyLove.PermissionsBalidation(this.Text, "05"))
{
return;
}
if (txtsheet_no.Text.Trim() != "")
{
string sheet_no = txtsheet_no.Text.Trim();
IBLL.ISupSettle bll = new BLL.SupSettle();
bll.Check(sheet_no, Program.oper.oper_id);
IOrder ins = this;
ins.ShowOrder(sheet_no);
}
}
catch (Exception ex)
{
MsgForm.ShowFrom(ex);
}
}
void IOrder.ShowOrder(string sheet_no)
{
try
{
System.Windows.Forms.Cursor.Current = System.Windows.Forms.Cursors.WaitCursor;
//
RunType = 2;
IBLL.ISupSettle bll = new BLL.SupSettle();
DataTable tb1;
DataTable tb2;
bll.GetOrder(sheet_no, out tb1, out tb2);
//
//
var r1 = tb1.Rows[0];
if (r1["sup_no"].ToString() == "")
{
txtsup.Text = "";
}
else
{
txtsup.Text = r1["sup_no"].ToString() + "/" + r1["sup_name"].ToString();
}
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() == "")
{
txtpeople.Text = "";
}
else
{
txtpeople.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"];
}
txtmemo.Text = r1["other1"].ToString();
DateTime dt;
if (DateTime.TryParse(r1["approve_date"].ToString(), out dt) == true)
{
txtapprove_date.Text = dt.ToString("yyyy-MM-dd");
}
else
{
txtapprove_date.Text = "";
}
txttotal_amount.Text = Helper.Conv.ToDecimal(r1["total_amount"].ToString()).ToString("0.00");
txtfree_money.Text = Helper.Conv.ToDecimal(r1["free_money"].ToString()).ToString("0.00");
if (r1["pay_way"].ToString() == "")
{
txtpay_way.Text = "";
}
else
{
txtpay_way.Text = r1["pay_way"].ToString() + "/" + r1["pay_name"].ToString();
}
if (r1["visa_id"].ToString() == "")
{
txtvisa.Text = "";
}
else
{
txtvisa.Text = r1["visa_id"].ToString() + "/" + r1["visa_name"].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);
}
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 (txtsup.Text.Trim().Contains("/") == false)
{
throw new Exception("货商必填!");
}
if (txtbranch.Text.Trim().Contains("/") == false)
{
throw new Exception("机构必填!");
}
if (txtoper_date.Text.Trim() == "")
{
throw new Exception("单据日期必填!");
}
if (txtpay_way.Text.Trim().Contains("/") == false)
{
throw new Exception("付款方式必填");
}
if (txtvisa.Text.Trim().Contains("/") == false)
{
throw new Exception("账户必填");
}
Model.rp_t_recpay_record_info ord = new Model.rp_t_recpay_record_info();
ord.sheet_no = txtsheet_no.Text.Trim();
ord.supcust_no = txtsup.Text.Split('/')[0];
ord.supcust_flag = "S";
ord.flag_post = "1";
ord.total_amount = Helper.Conv.ToDecimal(txttotal_amount.Text.Trim());
ord.free_money = Helper.Conv.ToDecimal(txtfree_money.Text.Trim());
ord.coin_no = "RMB";
ord.coin_rate = 1;
ord.pay_way = txtpay_way.Text.Split('/')[0];
ord.approve_flag = "0";
ord.oper_id = txtoper_man.Text.Trim().Split('/')[0];
ord.oper_date = Helper.Conv.ToDateTime(txtoper_date.Text.Trim());
ord.deal_man = txtpeople.Text.Split('/')[0];
ord.approve_man = "";
ord.approve_date = DateTime.MinValue;
ord.other1 = txtmemo.Text.Trim();
ord.other2 = "";
ord.other3 = "";
ord.visa_id = txtvisa.Text.Split('/')[0];
ord.num1 = 0;
ord.num2 = 0;
ord.num3 = 0;
ord.cm_branch = "00";
ord.branch_no = txtbranch.Text.Split('/')[0];
ord.from_date = DateTime.MinValue;
ord.to_date = DateTime.MinValue;
ord.rc_sheet_no = "";
int flag = 0;
List <Model.rp_t_recpay_record_detail> lines = new List <Model.rp_t_recpay_record_detail>();
int index = 0;
decimal pay_amt = ord.total_amount;
decimal free_money = ord.free_money;
decimal get_amt = 0;
//应还客户金额
foreach (DataRow row in editGrid1.DataSource.Rows)
{
if (row["voucher_no"].ToString() != "" && row["select_flag"].ToString() == "1" && row["path"].ToString() == "-1")
{
get_amt += Conv.ToDecimal(row["pay_amount"]);
}
}
pay_amt += get_amt;
foreach (DataRow row in editGrid1.DataSource.Rows)
{
index++;
if (row["voucher_no"].ToString() != "" && pay_amt >= 0 && row["select_flag"].ToString() == "1")
{
/*
* if (Helper.Conv.ToDecimal(row["pay_amount"].ToString()) < 0)
* {
* throw new Exception("第i行付款金额不正确！".Replace("i", index.ToString()));
* }
* if (Helper.Conv.ToDecimal(row["pay_free"].ToString()) < 0)
* {
* throw new Exception("第i行免付金额不正确！".Replace("i", index.ToString()));
* }
*/
decimal need_pay = Conv.ToDecimal(row["pay_amount"]);
decimal repay_amt = 0;
decimal pay_fee = 0;
if (row["path"].ToString() == "-1")
{
repay_amt = need_pay;
pay_fee = 0;
}
else
{
if (free_money > need_pay)
{
pay_fee = need_pay;
}
else
{
pay_fee = free_money;
if (pay_amt > need_pay - pay_fee)
{
repay_amt = need_pay - pay_fee;
}
else
{
repay_amt = pay_amt;
}
}
free_money -= pay_fee;
pay_amt -= repay_amt;
}
Model.rp_t_recpay_record_detail line = new Model.rp_t_recpay_record_detail();
lines.Add(line);
line.sheet_no = ord.sheet_no;
line.voucher_no = row["voucher_no"].ToString();
line.sheet_amount = Helper.Conv.ToDecimal(row["sheet_amount"].ToString());
line.pay_amount = repay_amt; // Helper.Conv.ToDecimal(row["pay_amount"].ToString());
line.pay_free = pay_fee; // Helper.Conv.ToDecimal(row["pay_free"].ToString());
line.memo = row["memo"].ToString();
line.other1 = "";
line.other2 = "";
line.other3 = "";
line.num1 = 0;
line.num2 = 0;
line.num3 = 0;
line.pay_date = System.DateTime.Now;
line.item_no = "";
line.path = ((row["path"].ToString() == "1" || row["path"].ToString() == "+") ? "+" : "-");
line.select_flag = row["select_flag"].ToString();
line.voucher_type = row["voucher_type"].ToString();
line.oper_date = DateTime.Now;
line.voucher_other1 = "";
line.voucher_other2 = "";
line.order_no = "";
flag = 1;
}
}
if (flag == 0)
{
throw new Exception("无可结算明细！");
}
if (runType == 1)
{
IBLL.ISupSettle bll = new BLL.SupSettle();
string sheet_no = "";
bll.Add(ord, lines, out sheet_no);
IOrder ins = this;
ins.ShowOrder(sheet_no);
}
else if (runType == 2)
{
IBLL.ISupSettle bll = new BLL.SupSettle();
bll.Change(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)
{
MsgForm.ShowFrom(ex);
}
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.ISupSettle bll = new BLL.SupSettle();
if (t == "get_list")
{
DateTime date1 = Helper.Conv.ToDateTime(r.Read("date1"));
DateTime date2 = Helper.Conv.ToDateTime(r.Read("date2"));
string sup_no = r.Read("sup_no");
var tb = bll.GetList(date1, date2, sup_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_order")
{
string sheet_no = r.Read("sheet_no");
System.Data.DataTable tb1;
System.Data.DataTable tb2;
bll.GetOrder(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 == "max_code")
{
string code = bll.MaxCode();
ReadWriteContext.IWriteContext w = new ReadWriteContext.WriteContextByJson();
w.Append("errId", "0");
w.Append("errMsg", "");
w.Append("code", code);
res = w.ToString();
}
else if (t == "add")
{
Model.rp_t_recpay_record_info ord = new Model.rp_t_recpay_record_info();
ord.sheet_no = r.Read("sheet_no");
ord.supcust_no = r.Read("supcust_no");
ord.supcust_flag = "S";
ord.flag_post = "1";
ord.total_amount = Helper.Conv.ToDecimal(r.Read("total_amount"));
ord.free_money = Helper.Conv.ToDecimal(r.Read("free_money"));
ord.coin_no = "RMB";
ord.coin_rate = 1;
ord.pay_way = r.Read("pay_way");
ord.approve_flag = "0";
ord.oper_id = r.Read("oper_id");
ord.oper_date = Helper.Conv.ToDateTime(r.Read("oper_date"));
ord.deal_man = r.Read("deal_man");
ord.approve_man = "";
ord.approve_date = System.DateTime.MinValue;
ord.other1 = r.Read("other1");
ord.other2 = r.Read("other2");
ord.other3 = r.Read("other3");
ord.visa_id = r.Read("visa_id");
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.cm_branch = "00";
ord.branch_no = r.Read("branch_no");
ord.from_date = System.DateTime.MinValue;
ord.to_date = System.DateTime.MinValue;
ord.rc_sheet_no = r.Read("rc_sheet_no");
List <Model.rp_t_recpay_record_detail> lines = new List <Model.rp_t_recpay_record_detail>();
foreach (ReadWriteContext.IReadContext r2 in r.ReadList("lines"))
{
Model.rp_t_recpay_record_detail line = new Model.rp_t_recpay_record_detail();
lines.Add(line);
line.sheet_no = ord.sheet_no;
line.voucher_no = r2.Read("voucher_no");
line.sheet_amount = Helper.Conv.ToDecimal(r2.Read("sheet_amount"));
line.paid_amount = Helper.Conv.ToDecimal(r2.Read("paid_amount"));
line.paid_free = Helper.Conv.ToDecimal(r2.Read("paid_free"));
line.pay_amount = Helper.Conv.ToDecimal(r2.Read("pay_amount"));
line.pay_free = Helper.Conv.ToDecimal(r2.Read("pay_free"));
line.memo = r2.Read("memo");
line.other1 = r2.Read("other1");
line.other2 = r2.Read("other2");
line.other3 = r2.Read("other3");
line.num1 = Helper.Conv.ToDecimal(r2.Read("num1"));
line.num2 = Helper.Conv.ToDecimal(r2.Read("num2"));
line.num3 = Helper.Conv.ToDecimal(r2.Read("num3"));
line.pay_date = Helper.Conv.ToDateTime(r2.Read("pay_date"));
line.item_no = r2.Read("item_no");
line.path = r2.Read("path");
line.select_flag = r2.Read("select_flag");
line.voucher_type = r2.Read("voucher_type");
line.oper_date = Helper.Conv.ToDateTime(r2.Read("oper_date"));
line.voucher_other1 = r2.Read("voucher_other1");
line.voucher_other2 = r2.Read("voucher_other2");
line.order_no = r2.Read("order_no");
}
string sheet_no = "";
bll.Add(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")
{
Model.rp_t_recpay_record_info ord = new Model.rp_t_recpay_record_info();
ord.sheet_no = r.Read("sheet_no");
ord.supcust_no = r.Read("supcust_no");
ord.supcust_flag = "S";
ord.flag_post = "1";
ord.total_amount = Helper.Conv.ToDecimal(r.Read("total_amount"));
ord.free_money = Helper.Conv.ToDecimal(r.Read("free_money"));
ord.coin_no = "RMB";
ord.coin_rate = 1;
ord.pay_way = r.Read("pay_way");
ord.approve_flag = "0";
ord.oper_id = r.Read("oper_id");
ord.oper_date = Helper.Conv.ToDateTime(r.Read("oper_date"));
ord.deal_man = r.Read("deal_man");
ord.approve_man = "";
ord.approve_date = System.DateTime.MinValue;
ord.other1 = r.Read("other1");
ord.other2 = r.Read("other2");
ord.other3 = r.Read("other3");
ord.visa_id = r.Read("visa_id");
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.cm_branch = "00";
ord.branch_no = r.Read("branch_no");
ord.from_date = System.DateTime.MinValue;
ord.to_date = System.DateTime.MinValue;
ord.rc_sheet_no = r.Read("rc_sheet_no");
List <Model.rp_t_recpay_record_detail> lines = new List <Model.rp_t_recpay_record_detail>();
foreach (ReadWriteContext.IReadContext r2 in r.ReadList("lines"))
{
Model.rp_t_recpay_record_detail line = new Model.rp_t_recpay_record_detail();
lines.Add(line);
line.sheet_no = ord.sheet_no;
line.voucher_no = r2.Read("voucher_no");
line.sheet_amount = Helper.Conv.ToDecimal(r2.Read("sheet_amount"));
line.paid_amount = Helper.Conv.ToDecimal(r2.Read("paid_amount"));
line.paid_free = Helper.Conv.ToDecimal(r2.Read("paid_free"));
line.pay_amount = Helper.Conv.ToDecimal(r2.Read("pay_amount"));
line.pay_free = Helper.Conv.ToDecimal(r2.Read("pay_free"));
line.memo = r2.Read("memo");
line.other1 = r2.Read("other1");
line.other2 = r2.Read("other2");
line.other3 = r2.Read("other3");
line.num1 = Helper.Conv.ToDecimal(r2.Read("num1"));
line.num2 = Helper.Conv.ToDecimal(r2.Read("num2"));
line.num3 = Helper.Conv.ToDecimal(r2.Read("num3"));
line.pay_date = Helper.Conv.ToDateTime(r2.Read("pay_date"));
line.item_no = r2.Read("item_no");
line.path = r2.Read("path");
line.select_flag = r2.Read("select_flag");
line.voucher_type = r2.Read("voucher_type");
line.oper_date = Helper.Conv.ToDateTime(r2.Read("oper_date"));
line.voucher_other1 = r2.Read("voucher_other1");
line.voucher_other2 = r2.Read("voucher_other2");
line.order_no = r2.Read("order_no");
}
bll.Change(ord, lines);
ReadWriteContext.IWriteContext w = new ReadWriteContext.WriteContextByJson();
w.Append("errId", "0");
w.Append("errMsg", "");
res = w.ToString();
}
else if (t == "delete")
{
string sheet_no = r.Read("sheet_no");
bll.Delete(sheet_no);
ReadWriteContext.IWriteContext w = new ReadWriteContext.WriteContextByJson();
w.Append("errId", "0");
w.Append("errMsg", "");
res = w.ToString();
}
else if (t == "check")
{
string sheet_no = r.Read("sheet_no");
string approve_man = r.Read("approve_man");
bll.Check(sheet_no, approve_man);
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("", ex.ToString());
res = w.ToString();
}
}
private void refreshData()
{
try
{
System.Windows.Forms.Cursor.Current = System.Windows.Forms.Cursors.WaitCursor;
//
DateTime date1;
DateTime date2;
DateTime.TryParse(dateTextBox1.Text.Trim(), out date1);
DateTime.TryParse(dateTextBox2.Text.Trim(), out date2);
string text = myTextBox1.Text.Split('/')[0];
System.Threading.Thread th = new System.Threading.Thread(() =>
{
Cursor.Current = Cursors.WaitCursor;
Helper.GlobalData.windows.ShowLoad(this);
try
{
IBLL.ISupSettle bll = new BLL.SupSettle();
if (date1 == DateTime.MinValue)
{
throw new Exception("期间不正确");
}
if (date2 == DateTime.MinValue)
{
throw new Exception("期间不正确");
}
DataTable tb = bll.GetList(date1, date2, text);
this.dataGrid1.Invoke((MethodInvoker) delegate
{
this.dataGrid1.DataSource = tb;
if (tb.Rows.Count > 0)
{
sheet_no = tb.Rows[0]["sheet_no"].ToString();
System.Data.DataTable tb1;
System.Data.DataTable tb2;
bll.GetOrder(sheet_no, out tb1, out tb2);
this.dataGrid2.Invoke((MethodInvoker) delegate
{
this.dataGrid2.DataSource = tb2;
this.dataGrid2.Refresh();
});
}
});
}
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);
}
finally
{
System.Windows.Forms.Cursor.Current = System.Windows.Forms.Cursors.Default;
}
}