public frmGatheringBillBalance()
{
InitializeComponent();
TJSystem.Public.PublicStatic.setBackgroundImg(this.panel1, this.panel1.GetType().ToString(), "images\\bg.gif");
TJSystem.Public.PublicStatic.setBackgroundImg(this.panel2, this.panel1.GetType().ToString(), "");
TJSystem.Public.PublicStatic.setBackgroundImg(this.panel3, this.panel1.GetType().ToString(), "");
TJSystem.Public.PublicStatic.setBackgroundImg(this.panel4, this.panel1.GetType().ToString(), "");
InitialFormData();
System.Text.StringBuilder sb = new System.Text.StringBuilder();
sb.Append("select pba_code,pba_date,supplier_id,supplier_name,Currency,");
sb.Append("remark,CreateOn,CreateBy,modifyOn,modifyBy");
sb.Append(" from finance_rba_master");
sb.Append(" order by pba_code");
this.InitialGrid(sb.ToString());
priToolBar1.setCurrentForm = this;
priToolBar1.Initial("finance_rba_master", "pba_code", sb.ToString());
priToolBar1.BeforeButtonClickEvent += new TJSystem.UC.PriToolBar.BeforeButotnClick(this.BeforeButtonClick);
priToolBar1.AfterButtonClickEvent += new TJSystem.UC.PriToolBar.AfterButtonClick(this.AfterButtonClick);
this.priToolBar1.setButtonVisibleFalse();;
this.priToolBar1.setButtonVisible("012345689");
}
public frmBrmProcess()
{
//
// Windows 窗体设计器支持所必需的
//
InitializeComponent();
TJSystem.Public.PublicStatic.setBackgroundImg(this.panel1, this.panel1.GetType().ToString(), "images\\bg.gif");
TJSystem.Public.PublicStatic.setBackgroundImg(this.panel2, this.panel1.GetType().ToString(), "");
TJSystem.Public.PublicStatic.setBackgroundImg(this.panel3, this.panel1.GetType().ToString(), "");
TJSystem.Public.PublicStatic.setBackgroundImg(this.panel4, this.panel1.GetType().ToString(), "");
InitialFormData();
System.Text.StringBuilder sb = new System.Text.StringBuilder();
sb.Append("select proc_no,proc_name,proc_desc,confirm_flag,createby,createon,modifyby,modifyon from brm_process order by proc_no");
priToolBar1.setCurrentForm = this;
_table = "brm_process";
_PK = "proc_no";
this.InitialGrid(sb.ToString());
priToolBar1.Initial(_table, _PK, sb.ToString());
priToolBar1.BeforeButtonClickEvent += new TJSystem.UC.PriToolBar.BeforeButotnClick(this.BeforeButtonClick);
priToolBar1.AfterButtonClickEvent += new TJSystem.UC.PriToolBar.AfterButtonClick(this.AfterButtonClick);
this.priToolBar1.setButtonVisibleFalse();;
this.priToolBar1.setButtonVisible("012345689");
setDisable();
//
// TODO: 在 InitializeComponent 调用后添加任何构造函数代码
//
}
public frmStockChangeINList(string ti_code)
{
//
// Windows 窗体设计器支持所必需的
//
InitializeComponent();
_statusType = "stock";
_eventtype = "MOVEI";
this.txt1.Text = ti_code;
TJSystem.Public.PublicStatic.setBackgroundImg(this.panel1, this.panel1.GetType().ToString(), "images\\bg.gif");
TJSystem.Public.PublicStatic.setBackgroundImg(this.panel2, this.panel1.GetType().ToString(), "");
TJSystem.Public.PublicStatic.setBackgroundImg(this.panel3, this.panel1.GetType().ToString(), "");
TJSystem.Public.PublicStatic.setBackgroundImg(this.panel4, this.panel1.GetType().ToString(), "");
InitialFormData();
System.Text.StringBuilder sb = new System.Text.StringBuilder();
sb.Append("select a.stock_code,a.seq_no,a.event_type,a.PSO_code,a.item_code,a.item_name_cn,a.item_desc_cn,a.unit,a.item_Qty,d.unit_name_cn, ");
sb.Append(" a.outsiepacktype,b.pack_method_name as pack_method_name, ");
sb.Append(" a.insidepacktype,c.pack_namecn as pack_namecn, ");
sb.Append(" a.remark,a.unit_price ");
sb.Append(" from wip_stock_det a ");
sb.Append(" left join p_packmethod b on a.outsiepacktype=b.pack_method_id ");
sb.Append(" left join p_packtype c on a.insidepacktype=c.pack_code ");
sb.Append(" left join p_unit d on a.unit=d.unit_id");
sb.Append(" where 1=1");
sb.Append(" and a.event_type=");
sb.Append("'");
sb.Append(this._eventtype);
sb.Append("'");
sb.Append(" and a.stock_code=");
sb.Append("'");
sb.Append(ti_code);
sb.Append("'");
sb.Append(" order by a.stock_code,a.seq_no");
this.InitialGrid(sb.ToString());
priToolBar1.setCurrentForm = this;
_PK = "stock_code,event_type,seq_no,PSO_code";
_table = "wip_stock_det";
priToolBar1.Initial(_table, _PK, sb.ToString());
priToolBar1.BeforeButtonClickEvent += new TJSystem.UC.PriToolBar.BeforeButotnClick(this.BeforeButtonClick);
priToolBar1.AfterButtonClickEvent += new TJSystem.UC.PriToolBar.AfterButtonClick(this.AfterButtonClick);
this.priToolBar1.setButtonVisibleFalse();;
this.priToolBar1.setButtonVisible("12345689");
setDisable();
//
// TODO: 在 InitializeComponent 调用后添加任何构造函数代码
//
}
public frmStockChange()
{
//
// Windows 窗体设计器支持所必需的
//
InitializeComponent();
_statusType = "stock";
_eventtype = "MOVE";
TJSystem.Public.PublicStatic.setBackgroundImg(this.panel1, this.panel1.GetType().ToString(), "images\\bg.gif");
TJSystem.Public.PublicStatic.setBackgroundImg(this.panel2, this.panel1.GetType().ToString(), "");
TJSystem.Public.PublicStatic.setBackgroundImg(this.panel3, this.panel1.GetType().ToString(), "");
TJSystem.Public.PublicStatic.setBackgroundImg(this.panel4, this.panel1.GetType().ToString(), "");
InitialFormData();
System.Text.StringBuilder sb = new System.Text.StringBuilder();
sb.Append("select a.stock_code,a.stock_date,a.event_type,a.status,c.status_name,a.wh_code,b.wh_name,a.reason,a.remark,a.approvedby,a.approvedon,");
sb.Append(" a.createby, a.createon,a.modifyby,a.modifyon");
sb.Append(" from wip_stock_mstr a");
sb.Append(" left join basic_whouse b on a.wh_code=b.wh_code");
sb.Append(" left join p_status c on a.status=c.status_id and c.status_type=");
sb.Append("'");
sb.Append(_statusType);
sb.Append("'");
sb.Append(" where 1=1");
sb.Append(" and a.event_type=");
sb.Append("'");
sb.Append(this._eventtype);
sb.Append("'");
sb.Append(" order by a.stock_code");
this.InitialGrid(sb.ToString());
priToolBar1.setCurrentForm = this;
_PK = "stock_code,event_type";
_table = "wip_stock_mstr";
priToolBar1.Initial(_table, _PK, sb.ToString());
priToolBar1.BeforeButtonClickEvent += new TJSystem.UC.PriToolBar.BeforeButotnClick(this.BeforeButtonClick);
priToolBar1.AfterButtonClickEvent += new TJSystem.UC.PriToolBar.AfterButtonClick(this.AfterButtonClick);
this.priToolBar1.setButtonVisibleFalse();;
this.priToolBar1.setButtonVisible("012345689");
setDisable();
//
// TODO: 在 InitializeComponent 调用后添加任何构造函数代码
//
}
public frmWorkRpt()
{
//
// Windows 窗体设计器支持所必需的
//
InitializeComponent();
InitialFormData();
TJSystem.Public.PublicStatic.setBackgroundImg(this.panel1, this.panel1.GetType().ToString(), "images\\bg.gif");
TJSystem.Public.PublicStatic.setBackgroundImg(this.panel2, this.panel1.GetType().ToString(), "");
TJSystem.Public.PublicStatic.setBackgroundImg(this.panel3, this.panel1.GetType().ToString(), "");
TJSystem.Public.PublicStatic.setBackgroundImg(this.panel4, this.panel1.GetType().ToString(), "");
System.Text.StringBuilder sb = new System.Text.StringBuilder();
sb.Append("select start_time,end_time,items,item_desc,pj_code,pre_content,wk_hours,wk_rate,total_rate,");
sb.Append(" emp_id,emp_name from tj_workreport ");
sb.Append(" where start_time >=");
sb.Append("'");
sb.Append(this.priDateTimePicker3.Value.ToString("yyyy-MM-dd HH:mm:ss"));
sb.Append("'");
sb.Append(" and end_time <=");
sb.Append("'");
sb.Append(this.priDateTimePicker1.Value.ToString("yyyy-MM-dd HH:mm:ss"));
sb.Append("'");
sb.Append(" and emp_id=");
sb.Append("'");
sb.Append(TJSystem.Public.PublicStatic.LoginUser);
sb.Append("'");
sb.Append(" order by start_time,items");
priToolBar1.setCurrentForm = this;
_PK = "start_time,items,emp_id";
_table = "tj_workreport";
this.InitialGrid(sb.ToString());
priToolBar1.Initial(_table, _PK, sb.ToString());
priToolBar1.BeforeButtonClickEvent += new TJSystem.UC.PriToolBar.BeforeButotnClick(this.BeforeButtonClick);
priToolBar1.AfterButtonClickEvent += new TJSystem.UC.PriToolBar.AfterButtonClick(this.AfterButtonClick);
this.priToolBar1.setButtonVisibleFalse();;
this.priToolBar1.setButtonVisible("012345689");
setDisable();
//
// TODO: 在 InitializeComponent 调用后添加任何构造函数代码
//
}
public frmClientSuplierItem(string supplier)
{
//
// Windows 窗体设计器支持所必需的
//
InitializeComponent();
TJSystem.Public.PublicStatic.setBackgroundImg(this.panel2, this.panel2.GetType().ToString(), "");
TJSystem.Public.PublicStatic.setBackgroundImg(this.panel3, this.panel2.GetType().ToString(), "");
TJSystem.Public.PublicStatic.setBackgroundImg(this.panel4, this.panel2.GetType().ToString(), "");
_supplier = supplier;
this.priTextBox1.Text = supplier;
if (!InitialFormData())
{
return;
}
System.Text.StringBuilder sb = new System.Text.StringBuilder();
sb.Append("select a.supplier_id,a.seq_no,a.item_code,a.item_name,a.item_name_cn,a.item_desc,a.item_desc_cn,");
sb.Append(" a.minorder,a.unit,b.unit_name_cn as unit_name_cn,a.ref_price,a.sale_price,a.remark ");
sb.Append(" from basic_suppitemlist a");
sb.Append(" left join p_unit b on a.unit=b.unit_id");
sb.Append(" where a.supplier_id='");
sb.Append(supplier);
sb.Append("' order by a.seq_no");
this.InitialGrid(sb.ToString());
// this.textBox1.DataField = "PNO";
priToolBar1.setCurrentForm = this;
_table = "basic_suppitemlist";
_PK = "supplier_id,seq_no";
priToolBar1.Initial(_table, _PK, sb.ToString());
priToolBar1.BeforeButtonClickEvent += new TJSystem.UC.PriToolBar.BeforeButotnClick(this.BeforeButtonClick);
priToolBar1.AfterButtonClickEvent += new TJSystem.UC.PriToolBar.AfterButtonClick(this.AfterButtonClick);
this.priToolBar1.setButtonVisibleFalse();;
this.priToolBar1.setButtonVisible("012345689");
setDisable();
//
// TODO: 在 InitializeComponent 调用后添加任何构造函数代码
//
}
public frmClientSuplierItemType(string supplier)
{
//
// Windows 窗体设计器支持所必需的
//
InitializeComponent();
_statusType = "item";
this.txt1.Text = supplier;
InitialFormData();
System.Text.StringBuilder sb = new System.Text.StringBuilder();
sb.Append("select a.supplier_id,a.seq_no,a.item_type,b.typenamecn as typenamecn,a.status,c.status_name as status_name ");
sb.Append("from basic_supplier_itemsort a ");
sb.Append("left join p_itemtype b on a.item_type=b.itemtype ");
sb.Append("left join p_status c on a.status=c.status_id and c.status_type=");
sb.Append("'");
sb.Append(_statusType);
sb.Append("'");
sb.Append("where a.supplier_id=");
sb.Append("'");
sb.Append(supplier);
sb.Append("'");
sb.Append(" order by a.seq_no");
this.InitialGrid(sb.ToString());
// this.textBox1.DataField = "PNO";
priToolBar1.setCurrentForm = this;
_table = "basic_supplier_itemsort";
_PK = "supplier_id,seq_no";
priToolBar1.Initial(_table, _PK, sb.ToString());
priToolBar1.BeforeButtonClickEvent += new TJSystem.UC.PriToolBar.BeforeButotnClick(this.BeforeButtonClick);
priToolBar1.AfterButtonClickEvent += new TJSystem.UC.PriToolBar.AfterButtonClick(this.AfterButtonClick);
this.priToolBar1.setButtonVisibleFalse();;
this.priToolBar1.setButtonVisible("012345689");
setDisable();
//
// TODO: 在 InitializeComponent 调用后添加任何构造函数代码
//
}
public frmBasicItemPack(string itemcode)
{
//
// Windows 窗体设计器支持所必需的
//
InitializeComponent();
_statusType = "";
this.txt1.Text = itemcode;
InitialFormData();
System.Text.StringBuilder sb = new System.Text.StringBuilder();
sb.Append("select a.item_code,a.seq_no,a.pack_code,a.description,a.qtyprepack,a.unit,a.outsiepacktype,a.length,a.width,a.height,a.volumn,");
sb.Append(" a.grossweight,a.netweight,a.remark,b.unit_name_cn,c.pack_namecn");
sb.Append(" from basic_item_packing a");
sb.Append(" left join p_unit b on a.unit=b.unit_id");
sb.Append(" left join p_packtype c on c.pack_code=a.outsiepacktype");
sb.Append(" where a.item_code=");
sb.Append("'");
sb.Append(itemcode);
sb.Append("'");
sb.Append(" order by a.item_code,a.seq_no");
priToolBar1.setCurrentForm = this;
_table = "basic_item_packing";
_PK = "item_code,seq_no";
this.InitialGrid(sb.ToString());
priToolBar1.Initial(_table, _PK, sb.ToString());
priToolBar1.BeforeButtonClickEvent += new TJSystem.UC.PriToolBar.BeforeButotnClick(this.BeforeButtonClick);
priToolBar1.AfterButtonClickEvent += new TJSystem.UC.PriToolBar.AfterButtonClick(this.AfterButtonClick);
priToolBar1.setButtonVisibleFalse();
priToolBar1.setButtonVisible("01234569");
setDisable();
//
// TODO: 在 InitializeComponent 调用后添加任何构造函数代码
//
}
public frmClientTransContact(string forwarder_id)
{
//
// Windows 窗体设计器支持所必需的
//
InitializeComponent();
TJSystem.Public.PublicStatic.setBackgroundImg(this.panel1, this.panel1.GetType().ToString(), "images\\bg.gif");
TJSystem.Public.PublicStatic.setBackgroundImg(this.panel2, this.panel1.GetType().ToString(), "");
TJSystem.Public.PublicStatic.setBackgroundImg(this.panel3, this.panel1.GetType().ToString(), "");
TJSystem.Public.PublicStatic.setBackgroundImg(this.panel4, this.panel1.GetType().ToString(), "");
_statusType = "person";
this.priTextBox2.Text = forwarder_id;
InitialFormData();
System.Text.StringBuilder sb = new System.Text.StringBuilder();
sb.Append("select a.forwarder_id,a.contact_id,a.contact_name,a.gender,a.department,a.position,a.tel,a.fax,a.mobile,a.email,a.status,b.status_name as status_name,a.qq_no ");
sb.Append(" from basic_forwarder_contact a");
sb.Append(" left join p_status b on a.status=b.status_id and b.status_type='person' ");
sb.Append("where a.forwarder_id='");
sb.Append(forwarder_id);
sb.Append("' order by a.contact_id");
this.InitialGrid(sb.ToString());
// this.textBox1.DataField = "PNO";
priToolBar1.setCurrentForm = this;
_table = "basic_forwarder_contact";
_PK = "forwarder_id,contact_id";
priToolBar1.Initial(_table, _PK, sb.ToString());
priToolBar1.BeforeButtonClickEvent += new TJSystem.UC.PriToolBar.BeforeButotnClick(this.BeforeButtonClick);
priToolBar1.AfterButtonClickEvent += new TJSystem.UC.PriToolBar.AfterButtonClick(this.AfterButtonClick);
this.priToolBar1.setButtonVisibleFalse();;
this.priToolBar1.setButtonVisible("012345689");
setDisable();
//
// TODO: 在 InitializeComponent 调用后添加任何构造函数代码
//
}
public frmBasicItemProperty(string itemcode)
{
//
// Windows 窗体设计器支持所必需的
//
InitializeComponent();
_statusType = "";
this.txt1.Text = itemcode;
InitialFormData();
System.Text.StringBuilder sb = new System.Text.StringBuilder();
sb.Append("select property_id,seq_no,property_value from basic_item_property_value ");
sb.Append("where property_id=");
sb.Append("'");
sb.Append(itemcode);
sb.Append("'");
sb.Append(" order by property_id,seq_no");
// this.textBox1.DataField = "PNO";
priToolBar1.setCurrentForm = this;
_table = "basic_item_property_value";
_PK = "property_id,seq_no";
this.InitialGrid(sb.ToString());
priToolBar1.Initial(_table, _PK, sb.ToString());
priToolBar1.BeforeButtonClickEvent += new TJSystem.UC.PriToolBar.BeforeButotnClick(this.BeforeButtonClick);
priToolBar1.AfterButtonClickEvent += new TJSystem.UC.PriToolBar.AfterButtonClick(this.AfterButtonClick);
priToolBar1.setButtonVisibleFalse();
priToolBar1.setButtonVisible("01234569");
setDisable();
//
// TODO: 在 InitializeComponent 调用后添加任何构造函数代码
//
}
public frmBasicItemClientCode(string itemcode)
{
//
// Windows 窗体设计器支持所必需的
//
InitializeComponent();
_statusType = "";
this.txt1.Text = itemcode;
InitialFormData();
System.Text.StringBuilder sb = new System.Text.StringBuilder();
sb.Append("select a.item_code,a.client_id,b.client_name as client_name,a.client_itemcode ");
sb.Append(" from basic_clientitemcode a");
sb.Append(" left join basic_client b on a.client_id=b.client_id ");
sb.Append("where a.item_code=");
sb.Append("'");
sb.Append(itemcode);
sb.Append("'");
sb.Append(" order by a.item_code");
this.InitialGrid(sb.ToString());
// this.textBox1.DataField = "PNO";
priToolBar1.setCurrentForm = this;
_table = "basic_clientitemcode";
_PK = "item_code,client_id";
priToolBar1.Initial(_table, _PK, sb.ToString());
priToolBar1.BeforeButtonClickEvent += new TJSystem.UC.PriToolBar.BeforeButotnClick(this.BeforeButtonClick);
priToolBar1.AfterButtonClickEvent += new TJSystem.UC.PriToolBar.AfterButtonClick(this.AfterButtonClick);
priToolBar1.setButtonVisibleFalse();
priToolBar1.setButtonVisible("01234569");
setDisable();
//
// TODO: 在 InitializeComponent 调用后添加任何构造函数代码
//
}
public frmSysRoleRight()
{
//
// Windows 窗体设计器支持所必需的
//
InitializeComponent();
TJSystem.Public.PublicStatic.setBackgroundImg(this.panel1, this.panel1.GetType().ToString(), "images\\bg.gif");
TJSystem.Public.PublicStatic.setBackgroundImg(this.panel2, this.panel1.GetType().ToString(), "");
TJSystem.Public.PublicStatic.setBackgroundImg(this.panel3, this.panel1.GetType().ToString(), "");
TJSystem.Public.PublicStatic.setBackgroundImg(this.panel4, this.panel1.GetType().ToString(), "");
InitialFormData();
System.Text.StringBuilder sb = new System.Text.StringBuilder();
sb.Append("select a.userid,b.name_cn as user_name,a.role_name,a.group_id,c.xf_programname as group_name,a.createby,a.createon,a.modifyby,a.modifyon ");
sb.Append(" from sys_user_role a");
sb.Append(" left join basic_employee b on a.userid=b.employee_id");
sb.Append(" left join xf_menutree c on a.group_id=c.xf_currenthandle");
sb.Append(" order by a.userid");
priToolBar1.setCurrentForm = this;
strPK = "userid,group_id";
strTable = "sys_user_role";
this.InitialGrid(sb.ToString());
priToolBar1.Initial(strTable, strPK, sb.ToString());
priToolBar1.BeforeButtonClickEvent += new TJSystem.UC.PriToolBar.BeforeButotnClick(this.BeforeButtonClick);
priToolBar1.AfterButtonClickEvent += new TJSystem.UC.PriToolBar.AfterButtonClick(this.AfterButtonClick);
this.priToolBar1.setButtonVisibleFalse();;
this.priToolBar1.setButtonVisible("012345689");
setDisable();
//
// TODO: 在 InitializeComponent 调用后添加任何构造函数代码
//
}
private void treeView1_DoubleClick(object sender, System.EventArgs e)
{
System.Windows.Forms.DataGridTableStyle dgstyle = null;
System.Text.StringBuilder sb = new System.Text.StringBuilder();
setVisibleFalse();
int counts = this.treeView1.Nodes.Count;
foreach (TJSystem.Classes.PriTreeNode tnSubP in this.treeView1.Nodes)
{
foreach (TJSystem.Classes.PriTreeNode tn in tnSubP.Nodes)
{
counts = tn.Nodes.Count;
if (tn.IsSelected && tn.GetNodeCount(true) == 0)
{
this.dataGrid1.CaptionText = tn.Text.Trim();
sb.Append("select a.parent_hs_code,a.hs_code,a.item_name,a.unit,b.unit_name_cn as unit_name_cn,a.backtaxrate,a.comtaxrate,a.exptaxrate,");
sb.Append("a.consumetaxrate,a.addtaxrate,a.remark,a.watchcert ");
sb.Append("from p_hscode a ");
sb.Append("left join p_unit b on a.unit=b.unit_id ");
sb.Append("where substring(a.hs_code ,1,2)='");
sb.Append(tn.Text.Substring(0, 3).Trim());
sb.Append("' ");
sb.Append("order by a.hs_code");
}
}
}
if (this.dgsty1 == null && sb.ToString().Length > 0)
{
return;
}
this.InitialGrid(sb.ToString(), dgsty1);
priToolBar2.setCurrentForm = this;
_PK = this.txt1.DataField;
_table = dgsty1.MappingName;
priToolBar2.Initial(_table, _PK, sb.ToString());
priToolBar2.BeforeButtonClickEvent += new TJSystem.UC.PriToolBar.BeforeButotnClick(this.BeforeButtonClick);
priToolBar2.AfterButtonClickEvent += new TJSystem.UC.PriToolBar.AfterButtonClick(this.AfterButtonClick);
}
public frmClientTransBank(string forward_id)
{
//
// Windows 窗体设计器支持所必需的
//
InitializeComponent();
TJSystem.Public.PublicStatic.setBackgroundImg(this.panel1, this.panel1.GetType().ToString(), "images\\bg.gif");
TJSystem.Public.PublicStatic.setBackgroundImg(this.panel2, this.panel1.GetType().ToString(), "");
TJSystem.Public.PublicStatic.setBackgroundImg(this.panel3, this.panel1.GetType().ToString(), "");
TJSystem.Public.PublicStatic.setBackgroundImg(this.panel4, this.panel1.GetType().ToString(), "");
this.priTextBox1.Text = forward_id;
System.Text.StringBuilder sb = new System.Text.StringBuilder();
sb.Append("select forward_id,bank_id,bank_name,account,country,province,city,postcode,address,swift_code ");
sb.Append("from basic_forwarder_bank ");
sb.Append("where forward_id='");
sb.Append(forward_id);
sb.Append("' order by bank_id");
this.InitialGrid(sb.ToString());
// this.textBox1.DataField = "PNO";
priToolBar1.setCurrentForm = this;
_table = "basic_forwarder_bank";
_PK = "forward_id,bank_id";
priToolBar1.Initial(_table, _PK, sb.ToString());
priToolBar1.BeforeButtonClickEvent += new TJSystem.UC.PriToolBar.BeforeButotnClick(this.BeforeButtonClick);
priToolBar1.AfterButtonClickEvent += new TJSystem.UC.PriToolBar.AfterButtonClick(this.AfterButtonClick);
this.priToolBar1.setButtonVisibleFalse();;
this.priToolBar1.setButtonVisible("012345689");
setDisable();
//
// TODO: 在 InitializeComponent 调用后添加任何构造函数代码
//
}
public frmPaymentBillDetail(string pa_code)
{
//
// Windows 窗体设计器支持所必需的
//
InitializeComponent();
_statusType = "";
this.txt1.Text = pa_code;
InitialFormData();
System.Text.StringBuilder sb = new System.Text.StringBuilder();
sb.Append("select pa_code,seq_no,ref_code,amount,remark ");
sb.Append(" from finance_payment_detail a");
sb.Append(" where a.pa_code=");
sb.Append("'");
sb.Append(pa_code);
sb.Append("'");
sb.Append(" order by a.seq_no");
this.InitialGrid(sb.ToString());
// this.textBox1.DataField = "PNO";
priToolBar1.setCurrentForm = this;
_table = "finance_payment_detail";
_PK = "pa_code,seq_no";
priToolBar1.Initial(_table, _PK, sb.ToString());
priToolBar1.BeforeButtonClickEvent += new TJSystem.UC.PriToolBar.BeforeButotnClick(this.BeforeButtonClick);
priToolBar1.AfterButtonClickEvent += new TJSystem.UC.PriToolBar.AfterButtonClick(this.AfterButtonClick);
priToolBar1.setButtonVisibleFalse();
priToolBar1.setButtonVisible("01234569");
setDisable();
//
// TODO: 在 InitializeComponent 调用后添加任何构造函数代码
//
}
public frmGatheringPaymentBill()
{
_statusType = "account";
InitializeComponent();
InitialFormData();
TJSystem.Public.PublicStatic.setBackgroundImg(this.panel1, this.panel1.GetType().ToString(), "images\\bg.gif");
TJSystem.Public.PublicStatic.setBackgroundImg(this.panel2, this.panel1.GetType().ToString(), "");
TJSystem.Public.PublicStatic.setBackgroundImg(this.panel3, this.panel1.GetType().ToString(), "");
TJSystem.Public.PublicStatic.setBackgroundImg(this.panel4, this.panel1.GetType().ToString(), "");
System.Text.StringBuilder sb = new System.Text.StringBuilder();
sb.Append("select a.doc_type,d.feetype_name as feetype_name,a.payrec_type,a.bearing,");
sb.Append(" case when a.payrec_type='P' then '付款' when a.payrec_type='R' then '收款' else '' end as payrec_type_desc,");
sb.Append(" case when a.bearing='P' then '逆向（付）' when a.bearing='R' then '正向（收）' else '' end as bearing_desc,");
sb.Append(" a.doc_no,a.Currency,c.CURRENCY_NAMECN as CURRENCY_NAMECN,a.Amount,a.Status,b.STATUS_NAME as STATUS_NAME,");
sb.Append(" a.crm_type,a.crm_id,a.voucher_no,a.remark,CreateOn,CreateBy,modifyOn,modifyBy ");
sb.Append(" from finance_doc a");
sb.Append(" left join p_status b on a.status=b.status_id and b.status_type=");
sb.Append("'");
sb.Append(this._statusType);
sb.Append("'"); //'account'
sb.Append(" left join p_currency c on a.Currency=c.CURRENCY_CODE");
sb.Append(" left join p_feetype d on a.doc_type=d.feetype_id");
sb.Append(" order by a.doc_no");
this.InitialGrid(sb.ToString());
_table = "finance_doc";
_PK = "payrec_type,doc_no";
priToolBar1.setCurrentForm = this;
priToolBar1.Initial(_table, _PK, sb.ToString());
priToolBar1.BeforeButtonClickEvent += new TJSystem.UC.PriToolBar.BeforeButotnClick(this.BeforeButtonClick);
priToolBar1.AfterButtonClickEvent += new TJSystem.UC.PriToolBar.AfterButtonClick(this.AfterButtonClick);
this.priToolBar1.setButtonVisibleFalse();;
this.priToolBar1.setButtonVisible("012345689");
setDisable();
}
public frmBasicItemPic2()
{
//
// Windows 窗体设计器支持所必需的
//
InitializeComponent();
TJSystem.Public.PublicStatic.setBackgroundImg(this.panel1, this.panel1.GetType().ToString(), "images\\bg.gif");
TJSystem.Public.PublicStatic.setBackgroundImg(this.panel2, this.panel1.GetType().ToString(), "");
TJSystem.Public.PublicStatic.setBackgroundImg(this.panel3, this.panel1.GetType().ToString(), "");
TJSystem.Public.PublicStatic.setBackgroundImg(this.panel4, this.panel1.GetType().ToString(), "");
InitialFormData();
System.Text.StringBuilder sb = new System.Text.StringBuilder();
sb.Append("select a.WH_CODE,a.WH_NAME,a.WH_DESC,a.TEL,a.FAX,a.CITY,a.ADDRESS,a.EMPLOYEE_ID,a.WH_TYPE,b.whtype_namecn as WHTYPE_NAMECN,a.CREATEBY,a.CREATEON, ");
sb.Append("a.MODIFYBY,a.MODIFYON ");
sb.Append("from BASIC_WHOUSE a ");
sb.Append("left join p_whousetype b on a.wh_type = b.whtype_id ");
sb.Append("ORDER BY a.WH_CODE");
this.InitialGrid(sb.ToString());
priToolBar1.setCurrentForm = this;
_table = "BASIC_WHOUSE";
_PK = "WH_CODE";
priToolBar1.Initial(_table, _PK, sb.ToString());
priToolBar1.BeforeButtonClickEvent += new TJSystem.UC.PriToolBar.BeforeButotnClick(this.BeforeButtonClick);
priToolBar1.AfterButtonClickEvent += new TJSystem.UC.PriToolBar.AfterButtonClick(this.AfterButtonClick);
this.priToolBar1.setButtonVisibleFalse();;
this.priToolBar1.setButtonVisible("012345689");
this.setDisable();
//
// TODO: 在 InitializeComponent 调用后添加任何构造函数代码
//
}
public frmBrmFlowMstr()
{
//
// Windows 窗体设计器支持所必需的
//
InitializeComponent();
TJSystem.Public.PublicStatic.setBackgroundImg(this.panel1, this.panel1.GetType().ToString(), "images\\bg.gif");
TJSystem.Public.PublicStatic.setBackgroundImg(this.panel2, this.panel1.GetType().ToString(), "");
TJSystem.Public.PublicStatic.setBackgroundImg(this.panel3, this.panel1.GetType().ToString(), "");
TJSystem.Public.PublicStatic.setBackgroundImg(this.panel4, this.panel1.GetType().ToString(), "");
InitialFormData();
System.Text.StringBuilder sb = new System.Text.StringBuilder();
sb.Append("select a.flow_id,b.flow_name,a.proc_no,c.proc_name,a.seq_no,a.modifyby,a.modifyon,a.createby,a.createon,");
sb.Append(" a.priority,case when a.priority='0' then '正常' else '关闭' end as FLAG_DESC ");
sb.Append(" from brm_flow_mstr a");
sb.Append(" left join brm_flow_det b on a.flow_id=b.flow_id");
sb.Append(" left join brm_process c on a.proc_no=c.proc_no");
priToolBar1.setCurrentForm = this;
_table = "brm_flow_mstr";
_PK = "flow_id,seq_no";
this.InitialGrid(sb.ToString());
priToolBar1.Initial(_table, _PK, sb.ToString());
priToolBar1.BeforeButtonClickEvent += new TJSystem.UC.PriToolBar.BeforeButotnClick(this.BeforeButtonClick);
priToolBar1.AfterButtonClickEvent += new TJSystem.UC.PriToolBar.AfterButtonClick(this.AfterButtonClick);
this.priToolBar1.setButtonVisibleFalse();;
this.priToolBar1.setButtonVisible("012345689");
setDisable();
//
// TODO: 在 InitializeComponent 调用后添加任何构造函数代码
//
}
public frmSysUserMenu()
{
//
// Windows 窗体设计器支持所必需的
//
InitializeComponent();
TJSystem.Public.PublicStatic.setBackgroundImg(this.panel1, this.panel1.GetType().ToString(), "images\\bg.gif");
TJSystem.Public.PublicStatic.setBackgroundImg(this.panel2, this.panel1.GetType().ToString(), "");
TJSystem.Public.PublicStatic.setBackgroundImg(this.panel3, this.panel1.GetType().ToString(), "");
TJSystem.Public.PublicStatic.setBackgroundImg(this.panel4, this.panel1.GetType().ToString(), "");
InitialFormData();
System.Text.StringBuilder sb = new System.Text.StringBuilder();
sb.Append("select a.employee_id,a.menu_id,b.XF_PROGRAMNAME as XF_PROGRAMNAME,a.insert_flag,a.update_flag, ");
sb.Append("a.delete_flag,a.export_flag,a.confirm_flag,a.createBy,a.createon,a.modifyBy,a.modifyon ");
sb.Append("from sys_user_menu a ");
sb.Append("left join XF_MENUTREE b on a.menu_id=b.XF_CURRENTHANDLE and b.XF_HANDLELEVEL='1' ");
sb.Append("order by employee_id,menu_id");
this.InitialGrid(sb.ToString());
// this.textBox1.DataField = "PNO";
priToolBar1.setCurrentForm = this;
_table = "sys_user_menu";
_PK = "employee_id,menu_id";
priToolBar1.Initial(_table, _PK, sb.ToString());
priToolBar1.BeforeButtonClickEvent += new TJSystem.UC.PriToolBar.BeforeButotnClick(this.BeforeButtonClick);
priToolBar1.AfterButtonClickEvent += new TJSystem.UC.PriToolBar.AfterButtonClick(this.AfterButtonClick);
this.priToolBar1.setButtonVisibleFalse();;
this.priToolBar1.setButtonVisible("012345689");
setDisable();
//
// TODO: 在 InitializeComponent 调用后添加任何构造函数代码
//
}
public frmBasicDocTerm()
{
//
// Windows 窗体设计器支持所必需的
//
InitializeComponent();
TJSystem.Public.PublicStatic.setBackgroundImg(this.panel1, this.panel1.GetType().ToString(), "images\\bg.gif");
TJSystem.Public.PublicStatic.setBackgroundImg(this.panel2, this.panel1.GetType().ToString(), "");
TJSystem.Public.PublicStatic.setBackgroundImg(this.panel3, this.panel1.GetType().ToString(), "");
TJSystem.Public.PublicStatic.setBackgroundImg(this.panel4, this.panel1.GetType().ToString(), "");
InitialFormData();
System.Text.StringBuilder sb = new System.Text.StringBuilder();
sb.Append("select a.term_id,a.term_name,a.term_desc,a.createby,a.createon, ");
sb.Append("a.MODIFYBY,a.MODIFYON ");
sb.Append("from BASIC_docterm a ");
sb.Append("ORDER BY a.term_id");
this.InitialGrid(sb.ToString());
priToolBar1.setCurrentForm = this;
_table = "BASIC_docterm";
_PK = "term_id";
priToolBar1.Initial(_table, _PK, sb.ToString());
priToolBar1.BeforeButtonClickEvent += new TJSystem.UC.PriToolBar.BeforeButotnClick(this.BeforeButtonClick);
priToolBar1.AfterButtonClickEvent += new TJSystem.UC.PriToolBar.AfterButtonClick(this.AfterButtonClick);
this.priToolBar1.setButtonVisibleFalse();;
this.priToolBar1.setButtonVisible("012345689");
this.setDisable();
//
// TODO: 在 InitializeComponent 调用后添加任何构造函数代码
//
}
public frmStockCycleINList(string ti_code, string stock_id)
{
//
// Windows 窗体设计器支持所必需的
//
InitializeComponent();
_statusType = "stock";
_stockid = stock_id;
this.txt1.Text = ti_code;
string sql = "select WH_CODE+' '+WH_NAME as WH_NAME from basic_whouse where WH_CODE='" + _stockid + "'";
DataTable dt = TJSystem.Public.PublicStatic.db.GetDataTable(sql);
if (dt.Rows.Count == 1)
{
this.textBox1.Text = dt.Rows[0][0].ToString();
}
else
{
this.textBox1.Text = "";
}
TJSystem.Public.PublicStatic.setBackgroundImg(this.panel1, this.panel1.GetType().ToString(), "images\\bg.gif");
TJSystem.Public.PublicStatic.setBackgroundImg(this.panel2, this.panel1.GetType().ToString(), "");
TJSystem.Public.PublicStatic.setBackgroundImg(this.panel3, this.panel1.GetType().ToString(), "");
TJSystem.Public.PublicStatic.setBackgroundImg(this.panel4, this.panel1.GetType().ToString(), "");
InitialFormData();
System.Text.StringBuilder sb = new System.Text.StringBuilder();
sb.Append("select a.it_code,a.item_code,a.item_name_cn,a.item_desc_cn,a.unit,d.unit_name_cn,");
sb.Append(" a.item_qty,a.actual_qty,a.discount_qty,a.remark,a.unit_price");
sb.Append(" from wip_stock_cycle_det a");
sb.Append(" left join p_unit d on a.unit=d.unit_id");
sb.Append(" where a.it_code =");
sb.Append("'");
sb.Append(ti_code);
sb.Append("'");
sb.Append(" order by a.it_code,a.item_code");
this.InitialGrid(sb.ToString());
priToolBar1.setCurrentForm = this;
_PK = "it_code,item_code";
_table = "wip_stock_cycle_det";
priToolBar1.Initial(_table, _PK, sb.ToString());
priToolBar1.BeforeButtonClickEvent += new TJSystem.UC.PriToolBar.BeforeButotnClick(this.BeforeButtonClick);
priToolBar1.AfterButtonClickEvent += new TJSystem.UC.PriToolBar.AfterButtonClick(this.AfterButtonClick);
this.priToolBar1.setButtonVisibleFalse();;
this.priToolBar1.setButtonVisible("012345689");
setDisable();
//
// TODO: 在 InitializeComponent 调用后添加任何构造函数代码
//
}