winfom datatable 手动生成

最新推荐文章于 2025-08-05 09:52:27 发布

原创最新推荐文章于 2025-08-05 09:52:27 发布 · 396 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#dataset #exception #string

winform 专栏收录该内容

3 篇文章

订阅专栏

本文介绍了一个用于从数据库中检索特定型号物料销售信息的方法。通过构造SQL查询语句并使用参数化方式传递型号ID，该方法能够获取到物料名称、代码、产品代码及销售详情等数据，并将这些数据整理为易于使用的DataTable格式。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

public DataTable GetMaterialSellInfo(int ModelId)
       {
           try
           {
               StringBuilder strSql = new StringBuilder();
               strSql.Append(" select m_name,m_code,product_code,wmsys.wm_concat(value) value");
               strSql.Append(" from (select b.m_name,b.m_code,b.product_code,a.period || ':' || a.price || ';' || a.min || ';' || a.max value");
               strSql.Append(" from act_material_sell a, ACT_MATERIAL_DICT b");
               strSql.Append(" where a.material_id = b.material_id and b.model_id=" + ModelId + "");
               strSql.Append(" order by b.m_name, a.period asc)");
               strSql.Append(" group by m_name,m_code,product_code");

DataSet ds = GetDataSet(strSql.ToString());

string M_Name, M_Code, Product_Code, Value = "";
int ValueLength = 0;

DataTable dt = new DataTable();

int columncount = 0;

DataTable newDt = ds.Tables[0].Clone();

               if (ds.Tables[0].Rows.Count > 0)
                   Value = ds.Tables[0].Rows[0]["VALUE"].ToString();
               ValueLength = Value.Split(',').Length;

               for (int i = 0; i < ValueLength * 3; i++)
               {
                   newDt.Columns.Add(new DataColumn());
               }

newDt.Columns.Remove("value");

               string str = "";
               for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
               {
                   M_Name = ds.Tables[0].Rows[i]["M_NAME"].ToString();
                   M_Code = ds.Tables[0].Rows[i]["M_CODE"].ToString();
                   Product_Code = ds.Tables[0].Rows[i]["PRODUCT_CODE"].ToString();
                   Value = ds.Tables[0].Rows[i]["VALUE"].ToString();
                   ValueLength = Value.Split(',').Length;

                   DataRow dr = newDt.NewRow();
                   dr[0] = M_Name;
                   dr[1] = M_Code;
                   dr[2] = Product_Code;

                   dr[3] = "3";
                   dr[4] = "4";
                   dr[5] = "5";
                   dr[6] = "6";
                   dr[7] = "7";
                   dr[8] = "8";
                   dr[9] = "9";
                   dr[10] = "10";
                   dr[11] = "11";

newDt.Rows.Add(dr);

               }
               return newDt;
           }
           catch (Exception ex)
           {
               throw ex;
           }
       }