本文整理汇总了C#中System.Data.DataRow.ToArray方法的典型用法代码示例。如果您正苦于以下问题:C# DataRow.ToArray方法的具体用法?C# DataRow.ToArray怎么用?C# DataRow.ToArray使用的例子?那么恭喜您, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类System.Data.DataRow
的用法示例。
在下文中一共展示了DataRow.ToArray方法的2个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于系统推荐出更棒的C#代码示例。
示例1: SaveSortingOrderDetail
//保存细表信息
public DataSet SaveSortingOrderDetail(DataRow[] detaildt)
{
DataSet ds = this.GenerateEmptyTables();
try
{
foreach (DataRow row in detaildt.ToArray())
{
DataRow detailrow = ds.Tables["WMS_SORT_ORDER_DETAIL"].NewRow();
detailrow["order_detail_id"] = row["OrderDetailID"].ToString().Trim();
detailrow["order_id"] = row["OrderID"].ToString().Trim().Trim();
detailrow["product_code"] = row["ProductCode"].ToString().Trim();
detailrow["product_name"] = row["ProductName"].ToString().Trim();
detailrow["unit_code"] = row["UNIT_CODE02"].ToString();
detailrow["unit_name"] = "条" ;
detailrow["demand_quantity"] = Convert.ToDecimal(row["RealQuantity"]);
detailrow["real_quantity"] = Convert.ToDecimal(row["RealQuantity"]);
detailrow["price"] = Convert.ToDecimal(row["TRADE_PRICE"]);
detailrow["amount"] = Convert.ToDecimal(row["AMOUNT_PRICE"]);
detailrow["unit_quantity"] = row["QUANTITY01"].ToString();
ds.Tables["WMS_SORT_ORDER_DETAIL"].Rows.Add(detailrow);
}
return ds;
}
catch (Exception e)
{
string s = e.Message;
return null;
}
}
示例2: SaveSortingOrder
//保存主表信息
public DataSet SaveSortingOrder(DataRow[] masterdt)
{
DataSet ds = this.GenerateEmptyTables();
foreach (DataRow row in masterdt.ToArray())
{
DataRow masterrow = ds.Tables["WMS_SORT_ORDER"].NewRow();
masterrow["order_id"] = row["OrderID"].ToString().Trim();//订单编号
masterrow["company_code"] = row["COMPANY_CODE"].ToString().Trim(); //所属单位编号
masterrow["sale_region_code"] = row["SALE_REGION_CODE"].ToString().Trim();//营销部编号
masterrow["order_date"] = row["OrderDate"].ToString();//订单日期
masterrow["order_type"] = row["SALE_SCOPE"].ToString().Trim();//订单类型
masterrow["customer_code"] = row["CustomerCode"].ToString().Trim();//客户编号
masterrow["customer_name"] = row["CustomerName"].ToString().Trim();//客户名称
masterrow["quantity_sum"] = Convert.ToDecimal(row["QuantitySum"].ToString());//总数量
masterrow["amount_sum"] = 0;
masterrow["detail_num"] = 0;
masterrow["deliver_order"] = row["DeliverOrder"];
masterrow["DeliverDate"] = DateTime.Now.ToString("yyyyMMdd");
masterrow["description"] = "";
masterrow["is_active"] = "1";
masterrow["update_time"] = DateTime.Now;
masterrow["deliver_line_code"] = row["DIST_BILL_ID"].ToString();// row["DELIVERLINECODE"].ToString();// +"_" + row["DIST_BILL_ID"].ToString();
masterrow["dist_bill_id"] = row["DIST_BILL_ID"].ToString();
ds.Tables["WMS_SORT_ORDER"].Rows.Add(masterrow);
}
return ds;
}