| | |
| | | string sSql = ""; |
| | | string sWhere = ""; |
| | | |
| | | if (chkWJieAn.Checked == true) |
| | | { |
| | | sWhere = " and HBillStatus<>3 "; |
| | | } |
| | | |
| | | if (frmCondition.SqlStr.Trim().Length == 0) |
| | | { |
| | | sSql = "Select top 5000 * from " + ViewName + " Where 1=1 " + sWhere + sDlgWhere + " order by æ¥æ desc,åæ®å· desc "; |
| | |
| | | oSumGrid.ogrdMain = grdMain; //åå§å new |
| | | oSumGrid.oGridsum = grdSum; |
| | | initGrid(); |
| | | chkWJieAn.Checked = true; |
| | | } |
| | | |
| | | private void grdMain_DblClick(object sender, EventArgs e) |
| | |
| | | // 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; |
| | | } |
| | | |
| | | |
| | | |
| | | SQLHelper.ClsCN oCn = new SQLHelper.ClsCN(); |
| | | DataSet ds; |