| | |
| | | //æå½ååæ®ID åå°ä¸ä¸ªæé®éé¢ å·æ°æ¶æ¯æ¬¡åä¸é |
| | | if (DSet.Tables[0].Rows.Count > 0) |
| | | { |
| | | txtHMaterID.Tag = DBUtility.ClsPub.isInt(grdMain.Rows[0].Cells["HInterID"].Value); |
| | | txtHMaterID.Tag = DBUtility.ClsPub.isLong(grdMain.Rows[0].Cells["HInterID"].Value); |
| | | txtHMiniQty.Text = DBUtility.ClsPub.isStrNull(grdMain.Rows[0].Cells["æ åè£
ç®±"].Value); |
| | | //txtHMaterID.Text = DBUtility.ClsPub.isStrNull(grdMain.Rows[0].Cells["ç©æç¼ç "].Value); |
| | | txtHMaterModel.Text = DBUtility.ClsPub.isStrNull(grdMain.Rows[0].Cells["è§æ ¼åå·"].Value); |
| | | txtHMaterName.Text = DBUtility.ClsPub.isStrNull(grdMain.Rows[0].Cells["ç©æåç§°"].Value); |
| | | } |
| | | else |
| | | { |
| | |
| | | // } |
| | | //} |
| | | //å»ç» |
| | | //int FrCol = DBUtility.ClsPub.isInt(frmCondition.txtFrozenCol.Text); |
| | | //int FrCol = DBUtility.ClsPub.isLong(frmCondition.txtFrozenCol.Text); |
| | | //string s = frmCondition.cmbHComplete.Text; |
| | | //DBUtility.Xt_BaseBillFun.DisplayGrid(grdMain, this.Name, s,FrCol); |
| | | //ç»çº¿ |
| | |
| | | string HUserName = ""; |
| | | HUserName = ClsPub.isStrNull(DBUtility.ClsPub.CurUserName); |
| | | Int64 HUserID = 0; |
| | | HUserID = ClsPub.isInt(DBUtility.ClsPub.CurUserID); |
| | | HUserID = ClsPub.isLong(DBUtility.ClsPub.CurUserID); |
| | | |
| | | DataSet DSet; |
| | | |
| | |
| | | |
| | | private void cmdHSaveBill_Click(object sender, EventArgs e) |
| | | { |
| | | |
| | | Display(); |
| | | } |
| | | |
| | |
| | | string HTMNumber = ""; |
| | | string HOrgNumber = ""; |
| | | DataSet Ds; |
| | | int LSH = 0; //æµæ°´å· |
| | | Int64 LSH = 0; //æµæ°´å· |
| | | string LSH2 = ""; //æµæ°´å·è½¬æ¢æå符 |
| | | |
| | | |
| | |
| | | //ç®±å· |
| | | string HXH = ""; |
| | | //ç®±å·æµæ°´å· |
| | | int LSH3 = 0; //æµæ°´å· |
| | | Int64 LSH3 = 0; //æµæ°´å· |
| | | string LSH4 = ""; //æµæ°´å·è½¬æ¢æå符 |
| | | //æºå° |
| | | string HJT = ""; |
| | |
| | | a = a + 1; |
| | | } |
| | | DataSet DsTM = oCn.RunProcReturn("exec h_p_WMS_GetMaxNo '" + sPackStr + "'", "h_p_WMS_GetMaxNo"); //è·åæå¤§æµæ°´å· //oCn.RunProc("exec h_p_WMS_SetMaxNo '" + sTMNumber + "'"); |
| | | Int64 TTM_LSH = ClsPub.isInt(DsTM.Tables[0].Rows[0][0]) + 1; |
| | | Int64 TTM_LSH = ClsPub.isLong(DsTM.Tables[0].Rows[0][0]) + 1; |
| | | |
| | | |
| | | sPackBarCode = sPackStr + TTM_LSH.ToString(); |
| | |
| | | // HTMaterID = ClsPub.isLong(grdMain.Rows[0].Cells[Fun_GetCol("HMaterID")].Value); |
| | | // string sPackStr = "ZXM" + HYear + HPeriod + HDay + HTMaterID; //å¤ç®±ç åç¼ |
| | | // DataSet DsTM = oCn.RunProcReturn("exec h_p_WMS_GetMaxNo '" + sPackStr + "'", "h_p_WMS_GetMaxNo"); //è·åæå¤§æµæ°´å· //oCn.RunProc("exec h_p_WMS_SetMaxNo '" + sTMNumber + "'"); |
| | | // Int64 TTM_LSH = ClsPub.isInt(DsTM.Tables[0].Rows[0][0]) + 1; |
| | | // Int64 TTM_LSH = ClsPub.isLong(DsTM.Tables[0].Rows[0][0]) + 1; |
| | | // sPackBarCode = sPackStr + TTM_LSH.ToString(); |
| | | // oCn.RunProc("exec h_p_WMS_SetMaxNo '" + sPackStr + "'"); |
| | | // } |
| | |
| | | // HTMaterID = ClsPub.isLong(grdMain.Rows[0].Cells[Fun_GetCol("HMaterID")].Value); |
| | | // string sPackStr = "ZXM" + HYear + HPeriod + HDay + HTMaterID; //å¤ç®±ç åç¼ |
| | | // DataSet DsTM = oCn.RunProcReturn("exec h_p_WMS_GetMaxNo '" + sPackStr + "'", "h_p_WMS_GetMaxNo"); //è·åæå¤§æµæ°´å· //oCn.RunProc("exec h_p_WMS_SetMaxNo '" + sTMNumber + "'"); |
| | | // Int64 TTM_LSH = ClsPub.isInt(DsTM.Tables[0].Rows[0][0]) + 1; |
| | | // Int64 TTM_LSH = ClsPub.isLong(DsTM.Tables[0].Rows[0][0]) + 1; |
| | | // sPackBarCode = sPackStr + TTM_LSH.ToString() + "+" ; |
| | | // oCn.RunProc("exec h_p_WMS_SetMaxNo '" + sPackStr + "'"); |
| | | // } |
| | |
| | | //HTMaterID = ClsPub.isLong(grdMain.Rows[0].Cells[Fun_GetCol("HMaterID")].Value); |
| | | //string sPackStr = "ZXM" + HYear + HPeriod + HDay + HTMaterID; //å¤ç®±ç åç¼ |
| | | //DataSet DsTM = oCn.RunProcReturn("exec h_p_WMS_GetMaxNo '" + sPackStr + "'", "h_p_WMS_GetMaxNo"); //è·åæå¤§æµæ°´å· //oCn.RunProc("exec h_p_WMS_SetMaxNo '" + sTMNumber + "'"); |
| | | //Int64 TTM_LSH = ClsPub.isInt(DsTM.Tables[0].Rows[0][0]) + 1; |
| | | //Int64 TTM_LSH = ClsPub.isLong(DsTM.Tables[0].Rows[0][0]) + 1; |
| | | //string sPackBarCode = sPackStr + TTM_LSH.ToString(); |
| | | //oCn.RunProc("exec h_p_WMS_SetMaxNo '" + sPackStr + "'"); |
| | | |
| | |
| | | |
| | | |
| | | //ç®±å·çæè§å æ¥æ + æºå° + çæ¬¡ + ç©æ åªè¦è·åæå¤§çæµæ°´å· |
| | | string sBoxYear; |
| | | string sBoxPeriod; |
| | | string sBoxDay; |
| | | DateTime HBoxDate = DBUtility.ClsPub.isDate(DBUtility.ClsPub.GetServerDate(0)); |
| | | sBoxYear = HBoxDate.Year.ToString().Substring(2, 2); |
| | | sBoxPeriod = "0" + HBoxDate.Month.ToString(); |
| | | sBoxPeriod = HPeriod.Substring(HPeriod.Length - 2, 2); |
| | | sBoxDay = "0" + HBoxDate.Day.ToString(); |
| | | sBoxDay = HDay.Substring(HDay.Length - 2, 2); |
| | | HJT = DBUtility.ClsPub.isStrNull(grdMain.Rows[j].Cells[Fun_GetCol("设å¤")].Value); |
| | | HXH = HYear + HPeriod + HDay + HBC + HJT + HMaterNumber; |
| | | HXH = sBoxYear + sBoxPeriod + sBoxDay + HBC + HJT + HMaterNumber; |
| | | Ds99 = oCn.RunProcReturn("exec h_p_WMS_GetMaxNo '" + HXH + "'", "h_p_WMS_GetMaxNo"); //è·åæå¤§æµæ°´å· |
| | | LSH3 = ClsPub.isInt(Ds99.Tables[0].Rows[0][0]) + 1; |
| | | LSH3 = ClsPub.isLong(Ds99.Tables[0].Rows[0][0]) + 1; |
| | | LSH4 = LSH3.ToString(); |
| | | |
| | | |
| | | |
| | | //HBQty = HBQty + ClsPub.isInt(txtHBQty.Text); |
| | | //HBQty = HBQty + ClsPub.isLong(txtHBQty.Text); |
| | | HZXQty = DBUtility.ClsPub.isDoule(grdMain.Rows[j].Cells[Fun_GetCol("æ¬æ¬¡æ°é")].Value); |
| | | HDDQty = DBUtility.ClsPub.isDoule(grdMain.Rows[j].Cells[Fun_GetCol("çäº§è®¢åæ°é")].Value); |
| | | HICMOBillNo = DBUtility.ClsPub.isStrNull(grdMain.Rows[j].Cells[Fun_GetCol("ç产订åå·")].Value); |
| | | |
| | | HTMNumber = HOrgNumber + HMaterNumber + HYear + HPeriod + HDay; |
| | | Ds = oCn.RunProcReturn("exec h_p_WMS_GetMaxNo '" + HTMNumber + "'", "h_p_WMS_GetMaxNo"); //è·åæå¤§æµæ°´å· |
| | | LSH = ClsPub.isInt(Ds.Tables[0].Rows[0][0]); |
| | | LSH = ClsPub.isLong(Ds.Tables[0].Rows[0][0]); |
| | | n = 0; |
| | | LSH2 = LSH.ToString(); |
| | | while (LSH2.Length < LSHlen) //å¦ææµæ°´å·å°äº6使°åé¢è¡¥0 |
| | |
| | | HWorkLineName = ""; |
| | | HSeOrderBillNo = ""; |
| | | HInnerBillNo = sPackBarCode; |
| | | HSourceID = ClsPub.isInt(txtHSourceID.Tag); |
| | | HSourceID = ClsPub.isLong(txtHSourceID.Tag); |
| | | oCn.RunProc("insert into Gy_BarCodeBill (HBarCode,HBarCodeType,HMaterID,HUnitID,HQty,HMaterialMQty" + |
| | | ",HBatchNo,HSupID,HGroupID,HMaker,HMakeDate,HPrintQty,HinitQty" + |
| | | ",HSourceInterID,HSourceEntryID,HSourceBillNo,HSourceBillType,HEndQty " + |
| | |
| | | //Sub_SaveBarCode(); |
| | | //// |
| | | |
| | | |
| | | |
| | | //bool flag = this.txtHZXQty.Text.Trim() != ""; |
| | | //double num; |
| | | //double HICMOQty = 0; |
| | | //if (flag) |
| | | //{ |
| | | // num = Pub_Class.ClsPub.isDoule(this.txtHZXQty.Text); |
| | | //} |
| | | //else |
| | | //{ |
| | | // num = Pub_Class.ClsPub.isDoule(this.txtHMiniQty.Text); |
| | | //} |
| | | //bool flag2 = num <= 0.0; |
| | | //if (flag2) |
| | | //{ |
| | | // MessageBox.Show("请è¾å
¥æ´ç®±æ°éï¼"); |
| | | //} |
| | | //else |
| | | //{ |
| | | // for (int i = 0; i < this.grdMain.Rows.Count; i++) |
| | | // { |
| | | // for (int i1 = 0; i1 < this.grdMain.Rows.Count; i1++) |
| | | // { |
| | | |
| | | // HICMOQty += Pub_Class.ClsPub.isDoule(this.grdMain.Rows[i1].Cells["çäº§è®¢åæ°é"].Value); |
| | | // } |
| | | // if (HICMOQty < num) |
| | | // { |
| | | // MessageBox.Show("请ç¹å»è¶
é¢ç产æé®çææ¡ç ï¼"); |
| | | // break; |
| | | // } |
| | | |
| | | // bool flag3 = num > 0.0; |
| | | // if (!flag3) |
| | | // { |
| | | // break; |
| | | // } |
| | | // bool flag4 = num > Pub_Class.ClsPub.isDoule(this.grdMain.Rows[i].Cells["çäº§è®¢åæ°é"].Value); |
| | | // if (!flag4) |
| | | // { |
| | | // this.grdMain.Rows[i].Cells["æ¬æ¬¡æ°é"].Value = num; |
| | | // break; |
| | | // } |
| | | // num -= Pub_Class.ClsPub.isDoule(this.grdMain.Rows[i].Cells["çäº§è®¢åæ°é"].Value); |
| | | // this.grdMain.Rows[i].Cells["æ¬æ¬¡æ°é"].Value = Pub_Class.ClsPub.isDoule(this.grdMain.Rows[i].Cells["çäº§è®¢åæ°é"].Value); |
| | | // } |
| | | // this.Sub_SaveBarCode(); |
| | | |
| | | bool flag = this.txtHZXQty.Text.Trim() != ""; |
| | | double HICMOQty = 0.0; |
| | | bool flag5 = flag; |
| | | double num; |
| | | double HICMOQty = 0; |
| | | if (flag) |
| | | if (flag5) |
| | | { |
| | | num = Pub_Class.ClsPub.isDoule(this.txtHZXQty.Text); |
| | | num = ClsPub.isDoule(this.txtHZXQty.Text); |
| | | } |
| | | else |
| | | { |
| | | num = Pub_Class.ClsPub.isDoule(this.txtHMiniQty.Text); |
| | | num = ClsPub.isDoule(this.txtHMiniQty.Text); |
| | | } |
| | | bool flag2 = num <= 0.0; |
| | | if (flag2) |
| | | bool flag6 = flag2; |
| | | if (flag6) |
| | | { |
| | | MessageBox.Show("请è¾å
¥æ´ç®±æ°éï¼"); |
| | | } |
| | |
| | | { |
| | | for (int i = 0; i < this.grdMain.Rows.Count; i++) |
| | | { |
| | | for (int i1 = 0; i1 < this.grdMain.Rows.Count; i1++) |
| | | for (int i2 = 0; i2 < this.grdMain.Rows.Count; i2++) |
| | | { |
| | | |
| | | HICMOQty += Pub_Class.ClsPub.isDoule(this.grdMain.Rows[i1].Cells["çäº§è®¢åæ°é"].Value); |
| | | HICMOQty += ClsPub.isDoule(this.grdMain.Rows[i2].Cells["çäº§è®¢åæ°é"].Value); |
| | | } |
| | | if (HICMOQty < num) |
| | | bool flag7 = HICMOQty < num; |
| | | if (flag7) |
| | | { |
| | | MessageBox.Show("请ç¹å»è¶
é¢ç产æé®çææ¡ç ï¼"); |
| | | break; |
| | | } |
| | | |
| | | bool flag3 = num > 0.0; |
| | | if (!flag3) |
| | | bool flag8 = !flag3; |
| | | if (flag8) |
| | | { |
| | | break; |
| | | } |
| | | bool flag4 = num > Pub_Class.ClsPub.isDoule(this.grdMain.Rows[i].Cells["çäº§è®¢åæ°é"].Value); |
| | | if (!flag4) |
| | | bool flag4 = num > ClsPub.isDoule(this.grdMain.Rows[i].Cells["çäº§è®¢åæ°é"].Value); |
| | | bool flag9 = !flag4; |
| | | if (flag9) |
| | | { |
| | | this.grdMain.Rows[i].Cells["æ¬æ¬¡æ°é"].Value = num; |
| | | break; |
| | | } |
| | | num -= Pub_Class.ClsPub.isDoule(this.grdMain.Rows[i].Cells["çäº§è®¢åæ°é"].Value); |
| | | this.grdMain.Rows[i].Cells["æ¬æ¬¡æ°é"].Value = Pub_Class.ClsPub.isDoule(this.grdMain.Rows[i].Cells["çäº§è®¢åæ°é"].Value); |
| | | num -= ClsPub.isDoule(this.grdMain.Rows[i].Cells["çäº§è®¢åæ°é"].Value); |
| | | this.grdMain.Rows[i].Cells["æ¬æ¬¡æ°é"].Value = ClsPub.isDoule(this.grdMain.Rows[i].Cells["çäº§è®¢åæ°é"].Value); |
| | | } |
| | | this.Sub_SaveBarCode(); |
| | | } |
| | |
| | | string HTMNumber = ""; |
| | | string HOrgNumber = ""; |
| | | DataSet Ds; |
| | | int LSH = 0; //æµæ°´å· |
| | | Int64 LSH = 0; //æµæ°´å· |
| | | string LSH2 = ""; //æµæ°´å·è½¬æ¢æå符 |
| | | double HZXQty = 0; //è£
ç®±æ°é |
| | | double HDDQty = 0; //è®¢åæ°é |
| | |
| | | HOrgNumber = ClsPub.HOrgNumber; |
| | | |
| | | |
| | | //HBQty = HBQty + ClsPub.isInt(txtHBQty.Text); |
| | | //HBQty = HBQty + ClsPub.isLong(txtHBQty.Text); |
| | | HZXQty = ClsPub.isDoule(txtHZXQty.Text); |
| | | HDDQty = DBUtility.ClsPub.isDoule(grdMain.Rows[j].Cells[Fun_GetCol("è®¢åæ°é")].Value); |
| | | |
| | |
| | | { |
| | | HTMNumber = HOrgNumber + HMaterNumber + HYear + HPeriod + HDay; |
| | | Ds = oCn.RunProcReturn("exec h_p_WMS_GetMaxNo '" + HTMNumber + "'", "h_p_WMS_GetMaxNo"); //è·åæå¤§æµæ°´å· |
| | | LSH = ClsPub.isInt(Ds.Tables[0].Rows[0][0]); |
| | | LSH = ClsPub.isLong(Ds.Tables[0].Rows[0][0]); |
| | | } |
| | | else if (cmbHBarCodeType.Text == "æ¹æ¬¡æ¡ç ") |
| | | { |
| | |
| | | string HTMNumber = ""; |
| | | string HOrgNumber = ""; |
| | | DataSet Ds; |
| | | int LSH = 0; //æµæ°´å· |
| | | Int64 LSH = 0; //æµæ°´å· |
| | | string LSH2 = ""; //æµæ°´å·è½¬æ¢æå符 |
| | | double HZXQty = 0; //è£
ç®±æ°é |
| | | double HDDQty = 0; //è®¢åæ°é |
| | |
| | | HOrgNumber = ClsPub.HOrgNumber; |
| | | |
| | | |
| | | //HBQty = HBQty + ClsPub.isInt(txtHBQty.Text); |
| | | //HBQty = HBQty + ClsPub.isLong(txtHBQty.Text); |
| | | HZXQty = ClsPub.isDoule(txtHZXQty.Text); |
| | | HDDQty = DBUtility.ClsPub.isDoule(grdMain.Rows[j].Cells[Fun_GetCol("è®¢åæ°é")].Value); |
| | | HICMOBillNo = DBUtility.ClsPub.isStrNull(grdMain.Rows[j].Cells[Fun_GetCol("ç产订åå·")].Value); |
| | |
| | | { |
| | | HTMNumber = HOrgNumber + HMaterNumber + HYear + HPeriod + HDay; |
| | | Ds = oCn.RunProcReturn("exec h_p_WMS_GetMaxNo '" + HTMNumber + "'", "h_p_WMS_GetMaxNo"); //è·åæå¤§æµæ°´å· |
| | | LSH = ClsPub.isInt(Ds.Tables[0].Rows[0][0]); |
| | | LSH = ClsPub.isLong(Ds.Tables[0].Rows[0][0]); |
| | | } |
| | | else if (cmbHBarCodeType.Text == "æ¹æ¬¡æ¡ç ") |
| | | { |
| | |
| | | HDay = HDay.Substring(HDay.Length - 2, 2); |
| | | HTMNumber = HOrgNumber + HMaterNumber + HYear + HPeriod + HDay; |
| | | Ds = oCn.RunProcReturn("exec h_p_WMS_GetMaxNo '" + HTMNumber + "'", "h_p_WMS_GetMaxNo"); //è·åæå¤§æµæ°´å· |
| | | LSH = ClsPub.isInt(Ds.Tables[0].Rows[0][0]); |
| | | LSH = ClsPub.isLong(Ds.Tables[0].Rows[0][0]); |
| | | TM = HTMNumber + LSH2; |
| | | } |
| | | else |
| | |
| | | HDay = HDay.Substring(HDay.Length - 2, 2); |
| | | HTMNumber = HOrgNumber + HMaterNumber + HYear + HPeriod + HDay; |
| | | Ds = oCn.RunProcReturn("exec h_p_WMS_GetMaxNo '" + HTMNumber + "'", "h_p_WMS_GetMaxNo"); //è·åæå¤§æµæ°´å· |
| | | LSH = ClsPub.isInt(Ds.Tables[0].Rows[0][0]); |
| | | LSH = ClsPub.isLong(Ds.Tables[0].Rows[0][0]); |
| | | TM = HTMNumber + LSH2 + "+"; |
| | | } |
| | | //HYear = ClsPub.isDate(HDate).Year.ToString().Substring(2, 2); |
| | |
| | | //HDay = HDay.Substring(HDay.Length - 2, 2); |
| | | //HTMNumber = HOrgNumber + HMaterNumber + HYear + HPeriod + HDay; |
| | | //Ds = oCn.RunProcReturn("exec h_p_WMS_GetMaxNo '" + HTMNumber + "'", "h_p_WMS_GetMaxNo"); //è·åæå¤§æµæ°´å· |
| | | //LSH = ClsPub.isInt(Ds.Tables[0].Rows[0][0]); |
| | | //LSH = ClsPub.isLong(Ds.Tables[0].Rows[0][0]); |
| | | } |
| | | //if (cmbHBarCodeType.Text == "å¯ä¸æ¡ç ") |
| | | //{ |
| | |
| | | |
| | | private void DisplayTM() |
| | | { |
| | | //HInterID = DBUtility.ClsPub.isInt(txtHMaterID.Tag); |
| | | //HInterID = DBUtility.ClsPub.isLong(txtHMaterID.Tag); |
| | | DataSet DSet = oCn.RunProcReturn("select * from h_v_IF_BarCodeBillList_test Where HinterID=" + HInterID.ToString() + " and æ¡ç ç±»å = 'æçæ¡ç ' order by HItemID", "h_v_IF_BarCodeBillList_test", ref DBUtility.ClsPub.sExeReturnInfo); |
| | | //çæé¦è¡æ é¢ |
| | | if (DSet == null) |
| | |
| | | // |
| | | grdSub.DataSource = DSet.Tables[0].DefaultView; |
| | | //å»ç» |
| | | //int FrCol = DBUtility.ClsPub.isInt(frmCondition.txtFrozenCol.Text); |
| | | //int FrCol = DBUtility.ClsPub.isLong(frmCondition.txtFrozenCol.Text); |
| | | //string s = frmCondition.cmbHComplete.Text; |
| | | //DBUtility.Xt_BaseBillFun.DisplayGrid(grdSub, this.Name, s, FrCol); |
| | | //ç»çº¿ |
| | |
| | | { |
| | | //è·åç½æ ¼ç¬¬ä¸è¡HInterIDçå¼ |
| | | Int64 HInterID = 0; |
| | | HInterID = DBUtility.ClsPub.isInt(txtHMaterID.Tag); |
| | | HInterID = DBUtility.ClsPub.isLong(txtHMaterID.Tag); |
| | | DataSet DSBefore; |
| | | DSBefore = SubCn.RunProcReturn("exec h_p_PreviousMater "+ HInterID, "h_p_PreviousMater", ref DBUtility.ClsPub.sExeReturnInfo); |
| | | grdMain.DataSource = DSBefore.Tables[0].DefaultView; |
| | | //if (DSBefore.Tables[0].Rows.Count > 0) |
| | | //{ |
| | | // txtHMaterID.Tag = DBUtility.ClsPub.isInt(grdMain.Rows[0].Cells["HInterID"].Value); |
| | | // txtHMaterID.Tag = DBUtility.ClsPub.isLong(grdMain.Rows[0].Cells["HInterID"].Value); |
| | | //} |
| | | //else |
| | | //{ |
| | |
| | | else |
| | | { |
| | | grdMain.DataSource = DSBefore.Tables[0].DefaultView; |
| | | txtHMaterID.Tag = DBUtility.ClsPub.isInt(grdMain.Rows[0].Cells["HInterID"].Value); |
| | | txtHMaterID.Tag = DBUtility.ClsPub.isLong(grdMain.Rows[0].Cells["HInterID"].Value); |
| | | txtHMiniQty.Text = DBUtility.ClsPub.isStrNull(grdMain.Rows[0].Cells["æ åè£
ç®±"].Value); |
| | | txtHMaterModel.Text = DBUtility.ClsPub.isStrNull(grdMain.Rows[0].Cells["è§æ ¼åå·"].Value); |
| | | txtHMaterName.Text = DBUtility.ClsPub.isStrNull(grdMain.Rows[0].Cells["ç©æåç§°"].Value); |
| | | } |
| | | |
| | | |
| | |
| | | { |
| | | //æ ¹æ® |
| | | Int64 HInterID = 0; |
| | | //HInterID = DBUtility.ClsPub.isInt(grdMain.Rows[0].Cells[Fun_GetCol("HInterID")].Value); |
| | | HInterID = DBUtility.ClsPub.isInt(txtHMaterID.Tag); |
| | | //HInterID = DBUtility.ClsPub.isLong(grdMain.Rows[0].Cells[Fun_GetCol("HInterID")].Value); |
| | | HInterID = DBUtility.ClsPub.isLong(txtHMaterID.Tag); |
| | | DataSet DSBefore; |
| | | DSBefore = SubCn.RunProcReturn("exec h_p_NextMater " + HInterID, "h_p_NextMater", ref DBUtility.ClsPub.sExeReturnInfo); |
| | | if (DSBefore == null || DSBefore.Tables[0].Rows.Count == 0) |
| | |
| | | else |
| | | { |
| | | grdMain.DataSource = DSBefore.Tables[0].DefaultView; |
| | | txtHMaterID.Tag = DBUtility.ClsPub.isInt(grdMain.Rows[0].Cells["HInterID"].Value); |
| | | txtHMaterID.Tag = DBUtility.ClsPub.isLong(grdMain.Rows[0].Cells["HInterID"].Value); |
| | | txtHMiniQty.Text = DBUtility.ClsPub.isStrNull(grdMain.Rows[0].Cells["æ åè£
ç®±"].Value); |
| | | txtHMaterModel.Text = DBUtility.ClsPub.isStrNull(grdMain.Rows[0].Cells["è§æ ¼åå·"].Value); |
| | | txtHMaterName.Text = DBUtility.ClsPub.isStrNull(grdMain.Rows[0].Cells["ç©æåç§°"].Value); |
| | | } |
| | | //txtHMaterID.Text = DBUtility.ClsPub.isStrNull(grdMain.Rows[0].Cells["HInterID"].Value); |
| | | } |
| | |
| | | Thread.Sleep(1000); |
| | | } |
| | | } |
| | | |
| | | private void label14_Click(object sender, EventArgs e) |
| | | { |
| | | |
| | | } |
| | | } |
| | | } |