| | |
| | | using DBUtility; |
| | | using System.IO; |
| | | using System.Reflection; |
| | | using Pub_Class; |
| | | |
| | | namespace WorkM |
| | | { |
| | |
| | | DataSet DSet; |
| | | string sSql = ""; |
| | | string sWhere = ""; |
| | | |
| | | if (chkWJieAn.Checked == true) |
| | | { |
| | | sWhere = " and HBillStatus<>3 "; |
| | | } |
| | | |
| | | if (frmCondition.SqlStr.Trim().Length == 0) |
| | | { |
| | |
| | | oSumGrid.ogrdMain = grdMain; //åå§å new |
| | | oSumGrid.oGridsum = grdSum; |
| | | initGrid(); |
| | | chkWJieAn.Checked = true; |
| | | } |
| | | |
| | | private void grdMain_DblClick(object sender, EventArgs e) |
| | |
| | | { |
| | | if (MessageBox.Show("ç¡®å®è¦å é¤å½ååæ®ï¼", "æç¤º", MessageBoxButtons.OKCancel)==DialogResult.OK) |
| | | { |
| | | if (oBill.omodel.HMaker != ClsPub.CurUserName && (ClsPub.CurUserName != "admin" && ClsPub.CurUserName != "Admin")) |
| | | ClsXt_SystemParameter oClsXt_SystemParameter = new ClsXt_SystemParameter(); |
| | | string DeleteCtl = oClsXt_SystemParameter.GetSingleSystemParameter("MES_StationOutBill_DeleteCtl", ref DBUtility.ClsPub.sExeReturnInfo); |
| | | |
| | | if (DeleteCtl == "Y" && oBill.omodel.HMaker != DBUtility.ClsPub.CurUserName && DBUtility.ClsPub.CurUserName != "admin" && DBUtility.ClsPub.CurUserName != "Admin") |
| | | { |
| | | MessageBox.Show("åªè½å 餿¬äººçåæ®ï¼", "æç¤º"); |
| | | MessageBox.Show("ç»å½ç¨æ·ä¸å¶å人ä¸ä¸è´ï¼ä¸å
许å é¤", "æç¤º"); |
| | | return; |
| | | } |
| | | |
| | | //夿ä¼è®¡ææ¯å¦åç |
| | | string s = ""; |
| | | int sYear = 0; |
| | | int sPeriod = 0; |
| | | if (DBUtility.Xt_BaseBillFun.Fun_AllowYearPeriod(DBUtility.ClsPub.isDate(oBill.omodel.HDate), ref sYear, ref sPeriod, ref s) == false) |
| | | { |
| | | MessageBox.Show(s, "æç¤º"); |
| | | return; |
| | | } |
| | | |
| | | |
| | | string c = ""; |
| | | |
| | | SQLHelper.ClsCN oCn = new SQLHelper.ClsCN(); |
| | |
| | | for (int i = 0; i < grdMain.SelectedRows.Count; i++) |
| | | { |
| | | BillSelect oSelect = new BillSelect(); |
| | | oSelect.BillNo = ClsPub.isStrNull(grdMain.Rows[grdMain.SelectedRows[i].Index].Cells[BillNoCol].Value); |
| | | oSelect.BillMainID = ClsPub.isLong(grdMain.Rows[grdMain.SelectedRows[i].Index].Cells[MainIDCol].Value); |
| | | oSelect.BillSubID = ClsPub.isLong(grdMain.Rows[grdMain.SelectedRows[i].Index].Cells[SubIDCol].Value); |
| | | oSelect.BillNo = DBUtility.ClsPub.isStrNull(grdMain.Rows[grdMain.SelectedRows[i].Index].Cells[BillNoCol].Value); |
| | | oSelect.BillMainID = DBUtility.ClsPub.isLong(grdMain.Rows[grdMain.SelectedRows[i].Index].Cells[MainIDCol].Value); |
| | | oSelect.BillSubID = DBUtility.ClsPub.isLong(grdMain.Rows[grdMain.SelectedRows[i].Index].Cells[SubIDCol].Value); |
| | | oSelect.BillTitle = "å·¥åºåºç«æ±æ¥å"; |
| | | oSelect.BillType = ModName; |
| | | oBillSelectColl.Add(oSelect); |
| | |
| | | DBUtility.Gy_BaseFun.DataGridViewToExcel2(grdMain, this.Text, this.Text); |
| | | |
| | | } |
| | | |
| | | private void fj_Click(object sender, EventArgs e) |
| | | { |
| | | if (grdMain.CurrentRow == null) |
| | | return; |
| | | string sBillNo = DBUtility.ClsPub.isStrNull(grdMain.Rows[grdMain.CurrentRow.Index].Cells[Fun_GetCol("åæ®å·")].Value); |
| | | if (sBillNo.Trim() != "") |
| | | { |
| | | BLL.Xt_File oFile = new BLL.Xt_File(); |
| | | oFile.HBillType = ModName; |
| | | oFile.HBillNo = sBillNo; |
| | | oFile.ShowDialog(); |
| | | } |
| | | } |
| | | } |
| | | } |