private void btnSave_Click(object sender, EventArgs e) { try { if (gridView2.RowCount > 0) { #region report List <Transportation_Items> bi = new List <Transportation_Items>(); for (int i = 0; i < gridView2.RowCount; i++) { int rowHand = gridView2.GetRowHandle(i); Transportation_Items item = new Transportation_Items() { Code = gridView2.GetRowCellDisplayText(rowHand, gridView2.Columns["الكود"]), Product_Type = gridView2.GetRowCellDisplayText(rowHand, gridView2.Columns["النوع"]), Product_Name = gridView2.GetRowCellDisplayText(rowHand, gridView2.Columns["الاسم"]), Total_Meters = Convert.ToDouble(gridView2.GetRowCellDisplayText(rowHand, gridView2.Columns["الكمية"])), Bill = gridView2.GetRowCellDisplayText(rowHand, gridView2.Columns["فاتورة"]) }; bi.Add(item); } Report_Transportation_Bill_Copy f = new Report_Transportation_Bill_Copy(); f.PrintInvoice(TransferProductID, comFromStore.Text, comToStore.Text, Date.ToString(), bi); f.ShowDialog(); #endregion XtraTabPage xtraTabPage = getTabPage("تعديل بيانات تحويل فاتورة"); tabControlStoresContent.TabPages.Remove(xtraTabPage); } else { MessageBox.Show("يجب ادخال جميع البيانات"); } } catch (Exception ex) { MessageBox.Show(ex.Message); } }
private void btnReport_Click(object sender, EventArgs e) { if (TransferProductID > 0) { try { List <Transportation_Items> bi = new List <Transportation_Items>(); conn.Open(); string query = "SELECT transfer_product.TransferProduct_ID as 'رقم التحويل',storeFrom.Store_Name as 'من مخزن',storeTo.Store_Name as 'الى مخزن',transfer_product.Date as 'تاريخ التحويل' FROM transfer_product left JOIN store as storeTo ON storeTo.Store_ID = transfer_product.To_Store left join store as storeFrom on storeFrom.Store_ID = transfer_product.From_Store where transfer_product.TransferProduct_ID=" + TransferProductID; MySqlCommand com = new MySqlCommand(query, conn); MySqlDataReader dr = com.ExecuteReader(); while (dr.Read()) { Transportation_Items item; connectionReader2.Open(); string q = "SELECT data.Code as 'الكود',type.Type_Name as 'النوع',concat(product.Product_Name,' ',COALESCE(color.Color_Name,''),' ',data.Description,' ',groupo.Group_Name,' ',factory.Factory_Name,' ',COALESCE(size.Size_Value,''),' ',COALESCE(sort.Sort_Value,'')) as 'الاسم',transfer_product_details.Quantity as 'الكمية',concat(customer_bill.Branch_BillNumber,' ',customer_bill.Branch_Name) as 'رقم الفاتورة' FROM transfer_product_details INNER JOIN transfer_product ON transfer_product_details.TransferProduct_ID = transfer_product.TransferProduct_ID left JOIN store as storeTo ON storeTo.Store_ID = transfer_product.To_Store left join store as storeFrom on storeFrom.Store_ID = transfer_product.From_Store left JOIN customer_bill ON transfer_product_details.CustomerBill_ID = customer_bill.CustomerBill_ID INNER JOIN data ON transfer_product_details.Data_ID = data.Data_ID LEFT JOIN color ON color.Color_ID = data.Color_ID LEFT JOIN size ON size.Size_ID = data.Size_ID LEFT JOIN sort ON sort.Sort_ID = data.Sort_ID INNER JOIN groupo ON data.Group_ID = groupo.Group_ID INNER JOIN factory ON factory.Factory_ID = data.Factory_ID INNER JOIN product ON product.Product_ID = data.Product_ID INNER JOIN type ON type.Type_ID = data.Type_ID where transfer_product.TransferProduct_ID=" + dr["رقم التحويل"].ToString() + " order by SUBSTR(data.Code,1,16),color.Color_Name,data.Description,data.Sort_ID"; MySqlCommand c = new MySqlCommand(q, connectionReader2); MySqlDataReader dr1 = c.ExecuteReader(); while (dr1.Read()) { if (WithBill == false) { item = new Transportation_Items() { Code = dr1["الكود"].ToString(), Product_Type = dr1["النوع"].ToString(), Product_Name = dr1["الاسم"].ToString(), Total_Meters = Convert.ToDouble(dr1["الكمية"].ToString()) }; } else { item = new Transportation_Items() { Code = dr1["الكود"].ToString(), Product_Type = dr1["النوع"].ToString(), Product_Name = dr1["الاسم"].ToString(), Total_Meters = Convert.ToDouble(dr1["الكمية"].ToString()), Bill = dr1["رقم الفاتورة"].ToString() }; } bi.Add(item); } dr1.Close(); } if (WithBill == false) { Report_Transportation_Copy f = new Report_Transportation_Copy(); f.PrintInvoice(Convert.ToInt16(dr["رقم التحويل"].ToString()), dr["من مخزن"].ToString(), dr["الى مخزن"].ToString(), dr["تاريخ التحويل"].ToString(), bi); dr.Close(); f.ShowDialog(); } else { Report_Transportation_Bill_Copy f = new Report_Transportation_Bill_Copy(); f.PrintInvoice(Convert.ToInt16(dr["رقم التحويل"].ToString()), dr["من مخزن"].ToString(), dr["الى مخزن"].ToString(), dr["تاريخ التحويل"].ToString(), bi); dr.Close(); f.ShowDialog(); } } catch (Exception ex) { MessageBox.Show(ex.Message); } conn.Close(); connectionReader2.Close(); } else { MessageBox.Show("برجاء التاكد من اختيار عنصر"); } }