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 调用后添加任何构造函数代码 // }