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("برجاء التاكد من اختيار عنصر");
}
}
