凯贝客户条码生成模块，客户料号取值方式修改，以下拉框方式返回数据进行编辑选择

yxj

2025-09-26 e35bcf919935392bccd3197608991366edca2255

凯贝客户条码生成模块，客户料号取值方式修改，以下拉框方式返回数据进行编辑选择

 WarM/ÌõÂë´òÓ¡/Gy_CusBarCodeBill_KaiBei.cs

@@ -982,6 +982,8 @@
                                "," + HMinQtyCol.ToString() +
                                "," + HMaterNumberCol.ToString() +
                                "," + HAuxPropNumberCol.ToString() +
                                "," + HCusModelNameCol.ToString() +
                                "," + HCusModelCol.ToString() +
                                "," + HUnitNumberCol.ToString() +
                                "," + HCode1Col.ToString() +
                                //"," + HCode2Col.ToString() +
@@ -1399,6 +1401,8 @@
            string sAllowCol = HQtyCol.ToString() +
                                "," + HMinQtyCol.ToString() +
                                "," + HAuxPropNumberCol.ToString() +
                                "," + HCusModelNameCol.ToString() +
                                "," + HCusModelCol.ToString() +
                                "," + HCode1Col.ToString() +
                                //"," + HCode2Col.ToString() +
                                "," + HCode3Col.ToString() +
@@ -1647,11 +1651,21 @@
                    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)

 WarM/ÌõÂë´òÓ¡/Gy_CusBarCodeBill_KaiBei_LangChao.cs

@@ -1165,6 +1165,8 @@
                                //"," + HMaterNumberCol.ToString() +
                                "," + HAuxPropNumberCol.ToString() +
                                "," + HUnitNumberCol.ToString() +
                                "," + HCusModelNameCol.ToString() +
                                "," + HCusModelCol.ToString() +
                                //"," + HCode1Col.ToString() +
                                //"," + HCode2Col.ToString() +
                                //"," + HCode3Col.ToString() +
@@ -1594,6 +1596,8 @@
                                "," + HMinQtyCol.ToString() +
                                "," + HWMinQtyCol.ToString() +
                                "," + HAuxPropNumberCol.ToString() +
                                "," + HCusModelNameCol.ToString() +
                                "," + HCusModelCol.ToString() +
                                //"," + HCode1Col.ToString() +
                                //"," + HCode2Col.ToString() +
                                //"," + HCode3Col.ToString() +
@@ -1913,11 +1917,21 @@
                    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)