如何仅在网格视图中打印指定的行

Question

欢迎 我有一个带有发票的销售屏幕，该屏幕在网格视图中显示了Extra Robert的报告 我只想使用选择框选择一些行时，仅在一个页面上打印了所选行，我尝试了此代码 我只想在一页上打印所选的行。谢谢

for (int i = 0; i <= DgvSale.Rows.Count - 1; i++)
{
    if (Convert.ToBoolean(DgvSale.Rows[i].Cells[8].Value) == true)
    {
        tblRpt1 = db.readData("SELECT [Order_ID] as 'رقم الفاتورة',talb_ID as 'طلب',[Cust_Name] as 'اسم العميل',Products.Pro_Name as 'المنتج',Products.Group_ID as 'قسم',Products_Group.Group_Name as 'اسم القسم',[Sales_Detalis].[Qty] as 'الكمية',[Price] as 'السعر',[User_Name] as 'الكاشير',[Date] as 'التاريخ',[Unit] as 'الوحدة',[Sales_Detalis].Tax_Value as 'الضريبة',Price_Tax as 'السعر بعد الضريبة',[typetalab] as 'نوع الطلب',[priceservic] as 'خدمة',[shiftname] as 'شيفت',notes as 'ملاحظات',shiftnum as 'شيفت رقم',Print_Group.Print_Name,Print_Group.Name_Group  FROM [dbo].[Sales_Detalis] , Products,Products_Group,Print_Group where Products.Pro_ID = Sales_Detalis.Pro_ID and Products.Pro_ID= " + row1.Cells[0].Value + " and Order_ID = " + id + "  and Products.Group_ID = Products_Group.Group_ID and Print_Group.Name_Group=Products.Group_ID  ORDER BY Order_ID ASC", "");
    }
}
if (Properties.Settings.Default.SalePrintKind == "8CM")
{
    devOrderSales2 rpt = new devOrderSales2() { DataSource = tblRpt1, DataMember = "OrderSales2" };
    rpt.DataSource = tblRpt1;
    rpt.Parameters["ID1"].Value = id;
    rpt.PrinterName = Properties.Settings.Default.PrinterNameSteker;
    rpt.xrTableCell8.Visible=true;
    if (Properties.Settings.Default.saleprintauto == "0")
    {
        rpt.Print();
    }
    else if (Properties.Settings.Default.saleprintauto == "1")
    {
        rpt.ShowPreviewDialog();
    }
}

Answer 1

我建议使用选定的记录动态创建某些条件：

string sql = @"SELECT [Order_ID] as 'رقم الفاتورة',talb_ID as 'طلب',[Cust_Name] as 'اسم العميل',Products.Pro_Name as 'المنتج',Products.Group_ID as 'قسم',Products_Group.Group_Name as 'اسم القسم',[Sales_Detalis].[Qty] as 'الكمية',[Price] as 'السعر',[User_Name] as 'الكاشير',[Date] as 'التاريخ',[Unit] as 'الوحدة',[Sales_Detalis].Tax_Value as 'الضريبة',Price_Tax as 'السعر بعد الضريبة',[typetalab] as 'نوع الطلب',[priceservic] as 'خدمة',[shiftname] as 'شيفت',notes as 'ملاحظات',shiftnum as 'شيفت رقم',Print_Group.Print_Name,Print_Group.Name_Group
    FROM
        [dbo].[Sales_Detalis]
        INNER JOIN Products
            ON Products.Pro_ID = Sales_Detalis.Pro_ID
        INNER JOIN Products_Group
            ON Products.Group_ID = Products_Group.Group_ID
        INNER JOIN Print_Group
            ON Print_Group.Name_Group=Products.Group_ID
    WHERE
        Products.Pro_ID IN ({0}) AND Order_ID = {1}
    ORDER BY Order_ID ASC";

var productIds = new List<int>();
for (int i = 0; i <= DgvSale.Rows.Count - 1; i++) {
    if (Convert.ToBoolean(DgvSale.Rows[i].Cells[8].Value) == true) {
        productIds.Add(Convert.ToInt32(DgvSale.Rows[i].Cells[0].Value));
    }
}
if (Properties.Settings.Default.SalePrintKind == "8CM" && productIds.Count > 0) {
    string commandText = String.Format(sql, String.Join(", ", productIds), id);
    tblRpt1 = db.readData(commandText, "");

    var rpt = new devOrderSales2 {
        DataSource = tblRpt1,
        DataMember = "OrderSales2",
        PrinterName = Properties.Settings.Default.PrinterNameSteker
    };
    rpt.xrTableCell8.Visible = true;
    rpt.Parameters["ID1"].Value = id;
    if (Properties.Settings.Default.saleprintauto == "0") {
        rpt.Print();
    } else if (Properties.Settings.Default.saleprintauto == "1") {
        rpt.ShowPreviewDialog();
    }
}

另外，您应该使用现代联接语法，而不是在Where子句中使用过时的联接条件。

请注意，我已经设置了一个具有{0}和{1}的SQL字符串作为占位符，后来被替换为String.format方法。我认为产品ID为int。条件看起来像这样的结果：

WHERE
    Products.Pro_ID IN (12, 30, 55, 68) AND Order_ID = 17

用@引入的c＃verbatim字符串@允许您在字符串中包含销钉中断，并使SQL文本更可读取。

row> row1始终指向同一行。

Answer 2

一种方法是首先从行中收集所有相关ID，并且仅进行1 dB查询，例如：

var toprint_ids = new List<long>();
for (int i = 0; i <= DgvSale.Rows.Count - 1; i++)
{
    if (Convert.ToBoolean(DgvSale.Rows[i].Cells[8].Value) == true)
    {
        var itm_id = Convert.ToInt64(row1.Cells[0].Value);
        ids.Add(itm_id);
    }
}

if (toprint_ids.Count == 0)
    return;

tblRpt1 = db.readData("SELECT [Order_ID] as 'رقم الفاتورة',talb_ID as 'طلب',[Cust_Name] as 'اسم العميل',Products.Pro_Name as 'المنتج',Products.Group_ID as 'قسم',Products_Group.Group_Name as 'اسم القسم',[Sales_Detalis].[Qty] as 'الكمية',[Price] as 'السعر',[User_Name] as 'الكاشير',[Date] as 'التاريخ',[Unit] as 'الوحدة',[Sales_Detalis].Tax_Value as 'الضريبة',Price_Tax as 'السعر بعد الضريبة',[typetalab] as 'نوع الطلب',[priceservic] as 'خدمة',[shiftname] as 'شيفت',notes as 'ملاحظات',shiftnum as 'شيفت رقم',Print_Group.Print_Name,Print_Group.Name_Group  FROM [dbo].[Sales_Detalis] , Products,Products_Group,Print_Group where Products.Pro_ID = Sales_Detalis.Pro_ID and Products.Pro_ID in (" + string.Join(",", toprint_ids) + ") and Order_ID = " + id + "  and Products.Group_ID = Products_Group.Group_ID and Print_Group.Name_Group=Products.Group_ID  ORDER BY Order_ID ASC", "");


if (Properties.Settings.Default.SalePrintKind == "8CM")
{
    devOrderSales2 rpt = new devOrderSales2() { DataSource = tblRpt1, DataMember = "OrderSales2" };
    rpt.DataSource = tblRpt1;
    rpt.Parameters["ID1"].Value = id;
    rpt.PrinterName = Properties.Settings.Default.PrinterNameSteker;
    rpt.xrTableCell8.Visible=true;
    if (Properties.Settings.Default.saleprintauto == "0")
    {
        rpt.Print();
    }
    else if (Properties.Settings.Default.saleprintauto == "1")
    {
        rpt.ShowPreviewDialog();
    }
}

请注意查询中的更改：in（“ + string.join（“，”，toprint_ids）） +“）
另外，如果您的行有非数字ID（例如GUIDS），则需要将列表更改为list＆lt; string＆gt;，并且还将查询更改为in（''''in（''） + string.join（“'，'”，toprint_ids） +“'）