| | |
| | | "," + HMinQtyCol.ToString() + |
| | | "," + HMaterNumberCol.ToString() + |
| | | "," + HAuxPropNumberCol.ToString() + |
| | | "," + HCusModelNameCol.ToString() + |
| | | "," + HCusModelCol.ToString() + |
| | | "," + HUnitNumberCol.ToString() + |
| | | "," + HCode1Col.ToString() + |
| | | //"," + HCode2Col.ToString() + |
| | |
| | | string sAllowCol = HQtyCol.ToString() + |
| | | "," + HMinQtyCol.ToString() + |
| | | "," + HAuxPropNumberCol.ToString() + |
| | | "," + HCusModelNameCol.ToString() + |
| | | "," + HCusModelCol.ToString() + |
| | | "," + HCode1Col.ToString() + |
| | | //"," + HCode2Col.ToString() + |
| | | "," + HCode3Col.ToString() + |
| | |
| | | DataSet ds = oCn.RunProcReturn("exec h_p_Gy_CusBarCodeBill_CusMatNo " + num.ToString() + "," + HCusID.ToString() + "," + HMaterID.ToString(), "h_p_Gy_CusBarCodeBill_CusMatNo"); |
| | | if (ds == null || ds.Tables[0].Rows.Count == 0) |
| | | { |
| | | grdMain.Rows[j].Cells[HCusModelNameCol].Value = ""; |
| | | //ç½æ ¼ä¸æéæ©æ¡ |
| | | DataGridViewComboBoxCell column = new DataGridViewComboBoxCell(); |
| | | column.Items.Add(""); |
| | | grdMain.Rows[j].Cells[HCusModelNameCol] = column; |
| | | grdMain.Rows[j].Cells[HCusModelCol].Value = ""; |
| | | } |
| | | else |
| | | { |
| | | //ç½æ ¼ä¸æéæ©æ¡ |
| | | DataGridViewComboBoxCell column = new DataGridViewComboBoxCell(); |
| | | for (int i = 0; i < ds.Tables[0].Rows.Count; i++) |
| | | { |
| | | column.Items.Add(DBUtility.ClsPub.isStrNull(ds.Tables[0].Rows[i]["HCusRelationNumber"])); |
| | | } |
| | | grdMain.Rows[j].Cells[HCusModelNameCol] = column; |
| | | grdMain.Rows[j].Cells[HCusModelNameCol].Value = DBUtility.ClsPub.isStrNull(ds.Tables[0].Rows[0]["HCusRelationNumber"]); |
| | | grdMain.Rows[j].Cells[HCusModelCol].Value = DBUtility.ClsPub.isStrNull(ds.Tables[0].Rows[0]["HCusRelationName"]); |
| | | if (num == 2) |