| | |
| | | //è¿æ»¤æ¡ä»¶ |
| | | if (frmCondition.SqlStr.Trim().Length == 0) |
| | | { |
| | | sSql = "Select * from " + ViewName + " Where 1=1 " + sWhere + sDlgWhere + " order by æ¥æ desc,hsubid "; |
| | | sSql = "Select * from " + ViewName + " Where 1=1 " + sWhere + sDlgWhere + " and HPRDORGID=" + DBUtility.ClsPub.HOrgID + " order by æ¥æ desc,hsubid "; |
| | | } |
| | | else |
| | | { |
| | | sSql = frmCondition.SqlStr + sWhere + sDlgWhere + " order by æ¥æ desc,hsubid "; |
| | | sSql = frmCondition.SqlStr + sWhere + sDlgWhere + " and HPRDORGID=" + DBUtility.ClsPub.HOrgID + " order by æ¥æ desc,hsubid "; |
| | | } |
| | | // |
| | | DSet = SubCn.RunProcReturn(sSql, ViewName, ref DBUtility.ClsPub.sExeReturnInfo); |
| | |
| | | Report.FieldByName("æµè½¬å¡æ°é").AsString = DBUtility.ClsPub.isStrNull(grdMain.SelectedRows[selectRow].Cells[Fun_GetCol("æµè½¬å¡æ°é")].Value); |
| | | Report.FieldByName("产å代ç ").AsString = DBUtility.ClsPub.isStrNull(grdMain.SelectedRows[selectRow].Cells[Fun_GetCol("产å代ç ")].Value); |
| | | Report.FieldByName("产ååç§°").AsString = DBUtility.ClsPub.isStrNull(grdMain.SelectedRows[selectRow].Cells[Fun_GetCol("产ååç§°")].Value); |
| | | Report.FieldByName("产åè§æ ¼").AsString = DBUtility.ClsPub.isStrNull(grdMain.SelectedRows[selectRow].Cells[Fun_GetCol("è§æ ¼åå·")].Value); |
| | | Report.FieldByName("产åè§æ ¼").AsString = DBUtility.ClsPub.isStrNull(grdMain.SelectedRows[selectRow].Cells[Fun_GetCol("产åè§æ ¼")].Value); |
| | | Report.FieldByName("计åå¼å·¥æ¥æ").AsString = DBUtility.ClsPub.isStrNull(grdMain.SelectedRows[selectRow].Cells[Fun_GetCol("计åå¼å·¥æ¥æ")].Value); |
| | | Report.FieldByName("计åå®å·¥æ¥æ").AsString = DBUtility.ClsPub.isStrNull(grdMain.SelectedRows[selectRow].Cells[Fun_GetCol("计åå®å·¥æ¥æ")].Value); |
| | | Report.FieldByName("订åè·è¸ªå·").AsString = DBUtility.ClsPub.isStrNull(grdMain.SelectedRows[selectRow].Cells[Fun_GetCol("订åè·è¸ªå·")].Value); |
| | | Report.FieldByName("åææ¹æ¬¡").AsString = DBUtility.ClsPub.isStrNull(grdMain.SelectedRows[selectRow].Cells[Fun_GetCol("åææ¹æ¬¡")].Value); |
| | | Report.FieldByName("模å
·è®¾å¤").AsString = DBUtility.ClsPub.isStrNull(grdMain.SelectedRows[selectRow].Cells[Fun_GetCol("模å
·è®¾å¤")].Value); |
| | | Report.FieldByName("项ç®å·").AsString = DBUtility.ClsPub.isStrNull(grdMain.SelectedRows[selectRow].Cells[Fun_GetCol("项ç®å·")].Value); |
| | | Report.FieldByName("å¾å·çæ¬").AsString = DBUtility.ClsPub.isStrNull(grdMain.SelectedRows[selectRow].Cells[Fun_GetCol("å¾å·çæ¬")].Value); |
| | | Report.FieldByName("æ»è£
å¾å·").AsString = DBUtility.ClsPub.isStrNull(grdMain.SelectedRows[selectRow].Cells[Fun_GetCol("æ»è£
å¾å·")].Value); |
| | | Report.FieldByName("æè´¨").AsString = DBUtility.ClsPub.isStrNull(grdMain.SelectedRows[selectRow].Cells[Fun_GetCol("æè´¨")].Value); |
| | | Report.FieldByName("æåç¼å·").AsString = DBUtility.ClsPub.isStrNull(grdMain.SelectedRows[selectRow].Cells[Fun_GetCol("æåç¼å·")].Value); |
| | | Report.FieldByName("çæ¬").AsString = DBUtility.ClsPub.isStrNull(grdMain.SelectedRows[selectRow].Cells[Fun_GetCol("çæ¬")].Value); |
| | | } |
| | | catch (Exception e) |
| | | { |
| | | MessageBox.Show("æå°å¤±è´¥ï¼[项ç®å·],[æµè½¬å¡ç¼å·],[æµè½¬å¡æ°é],[产å代ç ],[产ååç§°],[产åè§æ ¼],[计åå¼å·¥æ¥æ],[计åå®å·¥æ¥æ],[订åè·è¸ªå·],[åææ¹æ¬¡]ï¼[模å
·è®¾å¤]." + e.Message); |
| | | MessageBox.Show("æå°å¤±è´¥ï¼[项ç®å·],[æµè½¬å¡ç¼å·],[æµè½¬å¡æ°é],[产å代ç ],[产ååç§°],[产åè§æ ¼],[计åå¼å·¥æ¥æ],[计åå®å·¥æ¥æ],[订åè·è¸ªå·],[åææ¹æ¬¡]ï¼[模å
·è®¾å¤]ï¼[å¾å·çæ¬]ï¼[æ»è£
å¾å·]ï¼[æè´¨]ï¼[æåç¼å·]ï¼[çæ¬]." + e.Message); |
| | | } |
| | | } |
| | | |
| | |
| | | |
| | | private void cf_Click(object sender, EventArgs e) |
| | | { |
| | | //æºè§ç¹å«æ§å¶ |
| | | MessageBox.Show("åæ®æååè½å·²æ§å¶ï¼è¯·ä¸ç®¡çåèç³»", "æç¤º"); |
| | | return; |
| | | // |
| | | Int64 lngBillKey = 0; |
| | | if (grdMain.CurrentRow == null) |
| | | return; |