private void tsbDel_Click(object sender, EventArgs e)
{
if (!MyLove.PermissionsBalidation(this.Text, "02"))
{
return;
}
DataRow dr = this.dgvSup.CurrentRow();
if (dr == null)
{
return;
}
if (YesNoForm.ShowFrom("确认要删除吗？") == DialogResult.Yes)
{
if (_runType == 0)
{
IBLL.ISup bll = new BLL.SupBLL();
var sup = DB.ReflectionHelper.DataRowToModel <bi_t_supcust_info>(dr);
bll.Del(sup);
}
else if (_runType == 1)
{
IBLL.ICus bll = new BLL.CusBLL();
var sup = DB.ReflectionHelper.DataRowToModel <bi_t_supcust_info>(dr);
bll.Del(sup);
}
LoadSup();
}
}
public frmCusSettleList()
{
InitializeComponent();
//
Helper.GlobalData.InitForm(this);
//
dataGrid1.AddColumn("sheet_no", "单据号", "", 130, 1, "");
dataGrid1.AddColumn("cus_no", "客户编号", "", 80, 1, "");
dataGrid1.AddColumn("cus_name", "客户名称", "", 150, 1, "");
dataGrid1.AddColumn("total_amount", "结算金额", "", 90, 3, "0.00");
dataGrid1.AddColumn("free_money", "免付金额", "", 90, 3, "0.00");
dataGrid1.AddColumn("pay_way_a", "付款方式", "", 120, 1, "");
dataGrid1.AddColumn("branch_no_a", "发生机构", "", 130, 1, "");
dataGrid1.AddColumn("deal_man_a", "经办人", "", 100, 1, "");
dataGrid1.AddColumn("approve_man_a", "审核人", "", 110, 1, "");
dataGrid1.AddColumn("approve_date", "审核日期", "", 100, 1, "yyyy-MM-dd");
dataGrid1.AddColumn("oper_id_a", "操作员", "", 100, 1, "");
dataGrid1.AddColumn("oper_date", "操作日期", "", 100, 1, "yyyy-MM-dd");
dataGrid1.DataSource = new DataTable();
dataGrid1.SetTotalColumn("total_amount,free_money");
//
dataGrid2.AddColumn("select_flag", "核销", "", 50, 2, "{0:,1:√}");
dataGrid2.AddColumn("path", "方向", "", 50, 2, "{0:-,1:+}");
dataGrid2.AddColumn("voucher_no", "业务单号", "", 150, 1, "");
dataGrid2.AddColumn("voucher_first", "业务类型", "", 90, 2, IvyTransFunction.tran_no_str);
dataGrid2.AddColumn("sheet_amount", "单据金额", "", 100, 3, "0.00");
dataGrid2.AddColumn("paid_amount", "已付金额", "", 100, 3, "0.00");
dataGrid2.AddColumn("paid_free", "已免付金额", "", 100, 3, "0.00");
dataGrid2.AddColumn("yf_amount", "应付金额", "", 100, 3, "0.00");
dataGrid2.AddColumn("pay_amount", "本次付款金额", "", 120, 3, "0.00");
dataGrid2.AddColumn("pay_free", "免付金额", "", 100, 3, "0.00");
dataGrid2.AddColumn("memo", "备注", "", 180, 1, "");
dataGrid2.AddColumn("voucher_type", "业务描述", "", 100, 1, "");
dataGrid2.DataSource = new DataTable();
//
this.dateTextBox1.Text = System.DateTime.Now.AddDays(-30).ToString("yyyy-MM-dd");
this.dateTextBox2.Text = System.DateTime.Now.ToString("yyyy-MM-dd");
IBLL.ICus bll = new BLL.CusBLL();
int tmp;
this.myTextBox1.Bind(bll.GetDataTable("", "", 1, 1, 20000, out tmp), 300, 200, "supcust_no", "supcust_no:客户编码:100,sup_name:客户名称:150",
"supcust_no/sup_name->Text");
}
private void txt_cust_Leave(object sender, EventArgs e)
{
if (string.IsNullOrEmpty(txt_cust.Text.Trim()))
{
errMsg = "请输入客户";
return;
}
else
{
errMsg = "";
}
string cust = this.txt_cust.Text.Trim();
IBLL.ICus bll = new BLL.CusBLL();
var supcust = bll.GetItem(cust);
if (supcust == null || string.IsNullOrEmpty(supcust.supcust_no))
{
var frm = new frmSelect("2", cust);
frm.ShowDialog();
if (frm.item_no != "")
{
supcust = bll.GetItem(frm.item_no);
}
}
this.supcust = supcust;
if (supcust == null)
{
errMsg = "客户不存在";
this.lbl_cust_name.Text = "";
this.txt_cust.Text = "";
}
else
{
this.lbl_cust_name.Text = supcust.sup_name;
this.txt_cust.Text = supcust.supcust_no;
}
}
private void OK()
{
if (_runType == 0)
{
IBLL.ISup bll = new BLL.SupBLL();
if (supcust == null || string.IsNullOrEmpty(supcust.supcust_no))
{
//添加
bi_t_supcust_info sup = new bi_t_supcust_info()
{
supcust_flag = "S",
sup_man = txtSupMan.Text,
sup_type = cbSupType.SelectedValue.ToString(),
sup_tel = txtTel.Text,
sup_name = txtSupName.Text,
supcust_no = txtSupNo.Text,
sup_addr = txtAddress.Text,
sup_email = txtEmail.Text,
credit_amt = Conv.ToDecimal(txtCredit_amt.Text),
sale_man = this.txtPeo.Text.Split('/')[0],
display_flag = "1",
region_no = this.txtRegion.Text.Split('/')[0],
cust_level = this.cbPriceLevel.SelectedValue.ToString(),
update_time = DateTime.Now,
sup_pyname = this.txtPyname.Text,
is_retail = this.cbIsRetail.Checked ? "1" : "0",
login_no = this.txt_login_no.Text,
pwd = string.IsNullOrEmpty(this.txt_pwd.Text) ? "123456" : this.txt_pwd.Text,
is_branch = this.cb_is_branch.Checked ? "1" : "0",
supcust_group = cb_supcust_group.SelectedValue.ToString(),
};
bll.Add(sup);
}
else
{
//修改
supcust.sup_man = txtSupMan.Text;
supcust.sup_type = cbSupType.SelectedValue.ToString();
supcust.sup_tel = txtTel.Text;
supcust.sup_name = txtSupName.Text;
supcust.supcust_no = txtSupNo.Text;
supcust.sup_addr = txtAddress.Text;
supcust.sup_email = txtEmail.Text;
supcust.credit_amt = Conv.ToDecimal(txtCredit_amt.Text);
supcust.sale_man = this.txtPeo.Text.Split('/')[0];
supcust.display_flag = this.mycbStop.Checked ? "0" : "1";
supcust.region_no = this.txtRegion.Text.Split('/')[0];
supcust.cust_level = this.cbPriceLevel.SelectedValue.ToString();
supcust.update_time = DateTime.Now;
supcust.sup_pyname = this.txtPyname.Text;
supcust.is_retail = this.cbIsRetail.Checked ? "1" : "0";
supcust.login_no = this.txt_login_no.Text;
supcust.pwd = string.IsNullOrEmpty(this.txt_pwd.Text) ? "123456" : this.txt_pwd.Text;
supcust.is_branch = this.cb_is_branch.Checked ? "1" : "0";
supcust.supcust_group = cb_supcust_group.SelectedValue.ToString();
bll.Update(supcust);
}
}
else if (_runType == 1)
{
IBLL.ICus bll = new BLL.CusBLL();
if (supcust == null || string.IsNullOrEmpty(supcust.supcust_no))
{
//添加
bi_t_supcust_info sup = new bi_t_supcust_info()
{
supcust_flag = "C",
sup_man = txtSupMan.Text,
sup_type = cbSupType.SelectedValue.ToString(),
sup_tel = txtTel.Text,
sup_name = txtSupName.Text,
supcust_no = txtSupNo.Text,
sup_addr = txtAddress.Text,
sup_email = txtEmail.Text,
credit_amt = Conv.ToDecimal(txtCredit_amt.Text),
sale_man = this.txtPeo.Text.Split('/')[0],
display_flag = "1",
cust_level = this.cbPriceLevel.SelectedValue.ToString(),
region_no = this.txtRegion.Text.Split('/')[0],
update_time = DateTime.Now,
sup_pyname = this.txtPyname.Text,
is_retail = this.cbIsRetail.Checked ? "1" : "0",
login_no = this.txt_login_no.Text,
pwd = string.IsNullOrEmpty(this.txt_pwd.Text) ? "123456" : this.txt_pwd.Text,
is_branch = this.cb_is_branch.Checked ? "1" : "0",
supcust_group = cb_supcust_group.SelectedValue.ToString(),
};
bll.Add(sup);
}
else
{
//修改
supcust.sup_man = txtSupMan.Text;
supcust.sup_type = cbSupType.SelectedValue.ToString();
supcust.sup_tel = txtTel.Text;
supcust.sup_name = txtSupName.Text;
supcust.supcust_no = txtSupNo.Text;
supcust.sup_addr = txtAddress.Text;
supcust.sup_email = txtEmail.Text;
supcust.credit_amt = Conv.ToDecimal(txtCredit_amt.Text);
supcust.sale_man = this.txtPeo.Text.Split('/')[0];
supcust.display_flag = this.mycbStop.Checked ? "0" : "1";
supcust.region_no = this.txtRegion.Text.Split('/')[0];
supcust.cust_level = this.cbPriceLevel.SelectedValue.ToString();
supcust.update_time = DateTime.Now;
supcust.sup_pyname = this.txtPyname.Text;
supcust.is_retail = this.cbIsRetail.Checked ? "1" : "0";
supcust.login_no = this.txt_login_no.Text;
supcust.pwd = string.IsNullOrEmpty(this.txt_pwd.Text) ? "123456" : this.txt_pwd.Text;
supcust.is_branch = this.cb_is_branch.Checked ? "1" : "0";
supcust.supcust_group = cb_supcust_group.SelectedValue.ToString();
bll.Update(supcust);
}
}
}
private void LoadSup()
{
if (!MyLove.PermissionsBalidation(this.Text, "18"))
{
return;
}
page.PageSize = this.dgvSup.MaxDisplayRowCount();
Thread th = new Thread(() =>
{
Helper.GlobalData.windows.ShowLoad(this);
try
{
Cursor.Current = Cursors.WaitCursor;
string cls_no = "";
this.tv.Invoke((MethodInvoker) delegate
{
if (this.tv.SelectedNode != null)
{
if (this.tv.SelectedNode.Tag != null)
{
var item = (Model.bi_t_region_info) this.tv.SelectedNode.Tag;
cls_no = item.region_no;
}
}
});
string SelectedNode = "";
string Keyword = "";
int ShowStopSup = 0;
this.Invoke((MethodInvoker) delegate
{
SelectedNode = this.tv.SelectedNode == null ? "" : cls_no;
Keyword = this.txtKeyword.Text.Trim();
ShowStopSup = this.cbShowStopSup.Checked ? 1 : 0;
});
if (_runType == 0)
{
IBLL.ISup bll = new BLL.SupBLL();
page = bll.GetDataTable(
SelectedNode,
Keyword,
ShowStopSup,
page
);
}
else if (_runType == 1)
{
IBLL.ICus bll = new BLL.CusBLL();
page = bll.GetDataTable(
SelectedNode,
Keyword,
ShowStopSup,
page
);
}
Conv.AddColorTable(page.tb, "display_flag");
this.Invoke((MethodInvoker) delegate
{
this.dgvSup.DataSource = page.tb;
this.lblMaxIndex.Text = page.PageMax.ToString();
this.lblIndex.Text = page.PageIndex.ToString();
});
Cursor.Current = Cursors.Default;
}
catch (Exception ex)
{
LogHelper.writeLog("LoadSup", "获取商品分类出错!");
MsgForm.ShowFrom(ex);
}
Helper.GlobalData.windows.CloseLoad(this);
});
th.Start();
}
private void LoadItem()
{
string keyword = this.txtKeyword.Text.Trim();
DataTable dt = new DataTable();
if (this.op_type == "1")
{
//商品
IBLL.IItem bll = new BLL.ItemBLL();
dt = bll.QuickSearchList(keyword);
if (dt.Rows.Count == 0)
{
}
else if (dt.Rows.Count == 1)
{
this.item_no = dt.Rows[0]["item_subno"].ToString();
DialogResult = System.Windows.Forms.DialogResult.OK;
this.Close();
}
}
else if (this.op_type == "2")
{
//客户
IBLL.ICus bll = new BLL.CusBLL();
dt = bll.QuickSearchList(keyword);
if (dt.Rows.Count == 1)
{
this.item_no = dt.Rows[0]["supcust_no"].ToString();
DialogResult = System.Windows.Forms.DialogResult.OK;
this.Close();
}
}
else if (this.op_type == "3")
{
//供应商
IBLL.ISup bll = new BLL.SupBLL();
dt = bll.QuickSearchList(keyword);
if (dt.Rows.Count == 1)
{
this.item_no = dt.Rows[0]["supcust_no"].ToString();
DialogResult = System.Windows.Forms.DialogResult.OK;
this.Close();
}
}
else if (this.op_type == "4")
{
//业务员
IBLL.IPeople bll = new BLL.PeopleBLL();
dt = bll.QuickSearchList("02", keyword);
if (dt.Rows.Count == 1)
{
this.item_no = dt.Rows[0]["oper_id"].ToString();
DialogResult = System.Windows.Forms.DialogResult.OK;
this.Close();
}
}
else if (this.op_type == "5")
{
//仓库
IBLL.IBranch bll = new BLL.BranchBLL();
dt = bll.QuickSearchList(keyword);
if (dt.Rows.Count == 1)
{
this.item_no = dt.Rows[0]["branch_no"].ToString();
DialogResult = System.Windows.Forms.DialogResult.OK;
this.Close();
}
}
this.dgvItem.DataSource = dt;
if (dt.Rows.Count > 0)
{
this.dgvItem.Focus();
}
else
{
this.txtKeyword.Focus();
}
}