private void btnReportReceive_Click(object sender, EventArgs e)
{
if (intSaleReturnId == 0)
{
MessageBox.Show("กรุณาเลือกรายการก่อนค่ะ");
}
else
{
DialogResult dlg = MessageBox.Show("ต้องการพิมพ์รายงานหรือไม่ !!!", "ผลการทำงาน", MessageBoxButtons.OKCancel, MessageBoxIcon.Question);
if (dlg == DialogResult.OK)
{
SaleBackSupplier.rptSaleBack frm = new SaleBackSupplier.rptSaleBack();
frm.StartPosition = FormStartPosition.CenterScreen; // กำหนด frm ย่อย ให้
frm.setSaleBackId = intSaleReturnId;
frm.ShowDialog();
}
}
}
private void cmdSave_Click(object sender, EventArgs e)
{
if (MessageBox.Show("คุณต้องการแก้ไขรายการส่งคืนสินค้าให้ผู้ขาย ใช่หรือไม่?", "คำยืนยัน", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == System.Windows.Forms.DialogResult.Yes)
{
try
{
if (Class.Function.GetTextId(txtShipper.Text) == "") {
MessageBox.Show("กรุณาเลือกขนส่ง"); return;
}
if (Class.Function.GetTextId(txtSupplier.Text) == "")
{
MessageBox.Show("กรุณาเลือกผู้ขาย"); return;
}
List<string> sqladd = new List<string>();
String d = " DELETE FROM SALEBACK_WEIGHT WHERE SaleBackHeadId = " + lblSaleBackId.Text.Trim();
sqladd.Add(d);
d = " DELETE FROM SALEBACK_DETAIL WHERE SaleBackHeadId=" + lblSaleBackId.Text.Trim();
sqladd.Add(d);
d = " DELETE FROM SALEBACK_Head WHERE SaleBackHeadId=" + lblSaleBackId.Text.Trim();
sqladd.Add(d);
if (Class.DBConnString.clsDB.ExecuteTransactionNonAlert(sqladd.ToArray()))
{
tr = Conn.BeginTransaction();
string sqlSave = sb.ToString();
sb.Remove(0, sb.Length);
sb.Append("INSERT INTO SALEBACK_HEAD (SaleBackHeadId,SaleBackHeadDate,SupplierId,Remark,SaleBackHeadDateTime, ");
sb.Append("ShipperId) ");
sb.Append(" VALUES (@SaleBackHeadId,@SaleBackHeadDate,@SupplierId,@Remark,@SaleBackHeadDateTime,");
sb.Append("@ShipperId) ");
sqlSave = sb.ToString();
com.Parameters.Clear();
com.Transaction = tr;
com.CommandText = sqlSave;
com.Parameters.Add("@SaleBackHeadId", SqlDbType.Int).Value = Convert.ToInt32(lblSaleBackId.Text.Trim());
com.Parameters.Add("@SupplierId", SqlDbType.Int).Value = Convert.ToInt32(Class.Function.GetTextId(txtSupplier.Text));
com.Parameters.Add("@Remark", SqlDbType.NVarChar).Value = rtbRemark.Text.Trim();
com.Parameters.Add("@ShipperId", SqlDbType.Int).Value = Convert.ToInt32(Class.Function.GetTextId(txtShipper.Text));
com.Parameters.Add("@SaleBackHeadDateTime", SqlDbType.DateTime).Value = DateTime.Now.ToString("dd/MM/yyyy HH:mm:ss");
com.Parameters.Add("@SaleBackHeadDate", SqlDbType.DateTime).Value = dptSaleBackDate.Value.ToString("dd/MM/yyyy");
com.ExecuteNonQuery();
//
string ProductId;
for (int i = 0; i <= lsvProductList.Items.Count - 1; i++)
{
ProductId = lsvProductList.Items[i].SubItems[2].Text;
sb.Remove(0, sb.Length);
sb.Append("INSERT INTO SALEBACK_DETAIL (SaleBackHeadId,ReceiveHeadId,ProductId,SaleBackDetailQuantityPack,SaleBackDetailQuantity,SaleBackDetailPriceUnit,SaleBackDetailTotal,AmountProduct,State,ReceiveDate )");
sb.Append(" VALUES( @SaleBackHeadId,@ReceiveHeadId,@ProductId,@SaleBackDetailQuantityPack,@SaleBackDetailQuantity,@SaleBackDetailPriceUnit,@SaleBackDetailTotal,@AmountProduct,@State,@ReceiveDate)");
sqlSave = sb.ToString();
com.Parameters.Clear();
com.CommandText = sqlSave;
com.Parameters.Add("@SaleBackHeadId", SqlDbType.Int).Value = Convert.ToInt16(lblSaleBackId.Text.Trim());
com.Parameters.Add("@ReceiveHeadId", SqlDbType.NVarChar).Value = lsvProductList.Items[i].SubItems[0].Text;
com.Parameters.Add("@ProductId", SqlDbType.NVarChar).Value = lsvProductList.Items[i].SubItems[2].Text.Replace(",", "");
com.Parameters.Add("@SaleBackDetailQuantity", SqlDbType.Float).Value = Convert.ToSingle(lsvProductList.Items[i].SubItems[6].Text.Replace(",", "")).ToString("#,##0.00");
com.Parameters.Add("@SaleBackDetailPriceUnit", SqlDbType.Float).Value = Convert.ToSingle(lsvProductList.Items[i].SubItems[11].Text.Replace(",", "")).ToString("#,##0.00");
com.Parameters.Add("@SaleBackDetailTotal", SqlDbType.Float).Value = Convert.ToSingle(lsvProductList.Items[i].SubItems[12].Text.Replace(",", "")).ToString("#,##0.00");
com.Parameters.Add("@State", SqlDbType.Int).Value = Convert.ToInt16(lsvProductList.Items[i].SubItems[13].Text.Replace(",", ""));
com.Parameters.Add("@ReceiveDate", SqlDbType.DateTime).Value = Convert.ToDateTime(lsvProductList.Items[i].SubItems[1].Text.Replace(",", ""));
if (lsvProductList.Items[i].SubItems[8].Text != "")
{
com.Parameters.Add("@SaleBackDetailQuantityPack", SqlDbType.Float).Value = Convert.ToSingle(lsvProductList.Items[i].SubItems[8].Text.Replace(",", ""));
com.Parameters.Add("@AmountProduct", SqlDbType.NVarChar).Value = Convert.ToSingle(lsvProductList.Items[i].SubItems[4].Text.Replace(",", ""));
}
else
{
com.Parameters.Add("@SaleBackDetailQuantityPack", SqlDbType.NVarChar).Value = "";
com.Parameters.Add("@AmountProduct", SqlDbType.NVarChar).Value = "";
}
com.ExecuteNonQuery();
string weightext = lsvProductList.Items[i].SubItems[9].Text.Replace(" ", "#");
string[] weighttextarr = weightext.Split('#');
int len = weighttextarr.Length;
string Packtext = lsvProductList.Items[i].SubItems[10].Text.Replace(" ", "#");
string[] Packtextarr = Packtext.Split('#');
int lenPack = Packtextarr.Length;
if (weightext != "" && Packtext != "")
{
for (int j = 0; j < weighttextarr.Length - 1; j++)
{
sb.Remove(0, sb.Length);
sb.Append(" INSERT INTO SALEBACK_WEIGHT (SaleBackWeight,SaleBackHeadId,SaleBackPack,ProductId )");
sb.Append("VALUES( @SaleBackWeight,@SaleBackHeadId,@SaleBackPack,@ProductId)");
sqlSave = sb.ToString();
com.Parameters.Clear();
com.CommandText = sqlSave;
com.Parameters.Add("@SaleBackHeadId", SqlDbType.Int).Value = Convert.ToInt16(lblSaleBackId.Text.Trim());
com.Parameters.Add("@ProductId", SqlDbType.NVarChar).Value = lsvProductList.Items[i].SubItems[2].Text.Replace(",", "");
com.Parameters.Add("@SaleBackWeight", SqlDbType.Float).Value = Convert.ToSingle(weighttextarr[j].ToString()).ToString("#,##0.00");
com.Parameters.Add("@SaleBackPack", SqlDbType.Float).Value = Convert.ToSingle(Packtextarr[j].ToString());
com.ExecuteNonQuery();
}
}
else if (weightext != "" && Packtext == "")
{
for (int j = 0; j < weighttextarr.Length - 1; j++)
{
sb.Remove(0, sb.Length);
sb.Append("INSERT INTO SALEBACK_WEIGHT (SaleBackWeight,SaleBackHeadId,ProductId )");
sb.Append("VALUES( @SaleBackWeight,@SaleBackHeadId,@ProductId)");
sqlSave = sb.ToString();
com.Parameters.Clear();
com.CommandText = sqlSave;
com.Parameters.Add("@SaleBackHeadId", SqlDbType.Int).Value = Convert.ToInt16(lblSaleBackId.Text.Trim());
com.Parameters.Add("@ProductId", SqlDbType.NVarChar).Value = lsvProductList.Items[i].SubItems[2].Text.Replace(",", "");
com.Parameters.Add("@SaleBackWeight", SqlDbType.Float).Value = Convert.ToSingle(weighttextarr[j].ToString()).ToString("#,##0.00");
com.ExecuteNonQuery();
}
}
}
//lblSaleBackId.Text.Trim();
tr.Commit();
// ต้องการ print หรือไม่
///*
DialogResult dlg = MessageBox.Show("ต้องการพิมพ์รายงานหรือไม่ !!!", "ผลการทำงาน", MessageBoxButtons.OKCancel, MessageBoxIcon.Question);
if (dlg == DialogResult.OK)
{
SaleBackSupplier.rptSaleBack rptSaleBack = new SaleBackSupplier.rptSaleBack();
rptSaleBack.StartPosition = FormStartPosition.CenterScreen; // กำหนด frm ย่อย ให้
rptSaleBack.setSaleBackId = Convert.ToInt16(lblSaleBackId.Text);
rptSaleBack.ShowDialog();
}
else
{
MessageBox.Show("ปรับปรุงสำเร็จ");
Close();
}
ClearProductList();
ClearProductDetails();
}
}
catch (Exception ex)
{
MessageBox.Show("ไม่สามารถบันทึกรายการสั่งซื้อได้ เนื่องจาก " + ex.Message, "ข้อผิดพลาด", MessageBoxButtons.OK, MessageBoxIcon.Warning);
cmdSave.Focus();
tr.Rollback();
}
}
ClearProductList();
}
private void cmdSave_Click(object sender, EventArgs e)
{
if (txtSaleBackId.Text.Trim() == "")
{
MessageBox.Show("กรุณาใส่หมายเลขใบส่งคืนสินค้าด้วยค่ะ !!!", "ผลการตรวจสอบ", MessageBoxButtons.OK, MessageBoxIcon.Information);
txtSaleBackId.Focus();
return;
}
if (Class.Function.GetTextId(txtSupplier.Text) == "") {
MessageBox.Show("กรุณาเลือกผู้ขาย !!!", "ผลการตรวจสอบ", MessageBoxButtons.OK, MessageBoxIcon.Information);
return;
}
if (Class.Function.GetTextId(txtShipper.Text) == "")
{
MessageBox.Show("กรุณาเลือกขนส่ง !!!", "ผลการตรวจสอบ", MessageBoxButtons.OK, MessageBoxIcon.Information);
return;
}
if (MessageBox.Show("คุณต้องการบันทึกรายการส่งคืนสินค้า ใช่หรือไม่?", "คำยืนยัน", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == System.Windows.Forms.DialogResult.Yes)
{
//GetShipperId(); //หาค่า ShipperId เพื่อใช้บันทึกลงในฐานข้อมูล
tr = Conn.BeginTransaction();
try
{
string sqlSave;
sb.Remove(0, sb.Length);
sb.Append("INSERT INTO SALEBACK_HEAD (SaleBackHeadId,SaleBackHeadDate,SupplierId,Remark,SaleBackHeadDateTime, ");
sb.Append("ShipperId) ");
sb.Append(" VALUES (@SaleBackHeadId,@SaleBackHeadDate,@SupplierId,@Remark,@SaleBackHeadDateTime,");
sb.Append("@ShipperId) ");
sqlSave = sb.ToString();
com.Parameters.Clear();
com.Transaction = tr;
com.CommandText = sqlSave;
com.Parameters.Add("@SaleBackHeadId", SqlDbType.Int).Value = Convert.ToInt32(txtSaleBackId.Text.Trim());
com.Parameters.Add("@SupplierId", SqlDbType.Int).Value = Convert.ToInt32(Class.Function.GetTextId(txtSupplier.Text));
com.Parameters.Add("@Remark", SqlDbType.NVarChar).Value = rtbRemark.Text.Trim();
com.Parameters.Add("@ShipperId", SqlDbType.Int).Value = Convert.ToInt32(Class.Function.GetTextId(txtShipper.Text));
if (dptSaleBackDate.Value.ToString("dd/MM/yyyy") == DateTime.Now.ToString("dd/MM/yyyy"))
{
com.Parameters.Add("@SaleBackHeadDateTime", SqlDbType.DateTime).Value = DateTime.Now.ToString("dd/MM/yyyy HH:mm:ss");
com.Parameters.Add("@SaleBackHeadDate", SqlDbType.DateTime).Value = DateTime.Now.ToString("dd/MM/yyyy");
}
else
{
com.Parameters.Add("@SaleBackHeadDateTime", SqlDbType.DateTime).Value = dptSaleBackDate.Value.ToString("dd/MM/yyyy HH:mm:ss");
com.Parameters.Add("@SaleBackHeadDate", SqlDbType.DateTime).Value = dptSaleBackDate.Value.ToString("dd/MM/yyyy");
}
com.ExecuteNonQuery();
string ProductId;
for (int i = 0; i <= lsvProductList.Items.Count - 1; i++)
{
ProductId = lsvProductList.Items[i].SubItems[2].Text;
sb.Remove(0, sb.Length);
sb.Append("INSERT INTO SALEBACK_DETAIL (SaleBackHeadId,ReceiveHeadId,ProductId,SaleBackDetailQuantityPack,SaleBackDetailQuantity,SaleBackDetailPriceUnit,SaleBackDetailTotal,AmountProduct,State,ReceiveDate )");
sb.Append("");//Iyayben
sb.Append(" VALUES( @SaleBackHeadId,@ReceiveHeadId,@ProductId,@SaleBackDetailQuantityPack,@SaleBackDetailQuantity,@ReceiveDetailPriceUnit,@ReceiveDetailTotal,@AmountProduct,@State,@ReceiveDate)");
sqlSave = sb.ToString();
com.Parameters.Clear();
com.CommandText = sqlSave;
com.Parameters.Add("@SaleBackHeadId", SqlDbType.Int).Value = Convert.ToInt32(txtSaleBackId.Text.Trim());
com.Parameters.Add("@ReceiveHeadId", SqlDbType.NVarChar).Value = lsvProductList.Items[i].SubItems[0].Text;
com.Parameters.Add("@ProductId", SqlDbType.NVarChar).Value = lsvProductList.Items[i].SubItems[2].Text.Replace(",", "");
if (lsvProductList.Items[i].SubItems[8].Text.Replace(",", "") != "")
{
com.Parameters.Add("@SaleBackDetailQuantityPack", SqlDbType.Float).Value = Convert.ToSingle(lsvProductList.Items[i].SubItems[8].Text.Replace(",", ""));
}
else
{
com.Parameters.Add("@SaleBackDetailQuantityPack", SqlDbType.Float).Value = 0.00;
}
com.Parameters.Add("@SaleBackDetailQuantity", SqlDbType.Float).Value = Convert.ToSingle(lsvProductList.Items[i].SubItems[6].Text.Replace(",", ""));
com.Parameters.Add("@ReceiveDetailPriceUnit", SqlDbType.Float).Value = Convert.ToSingle(lsvProductList.Items[i].SubItems[11].Text.Replace(",", "")).ToString("#,##0.0000");
com.Parameters.Add("@ReceiveDetailTotal", SqlDbType.Float).Value = Convert.ToSingle(lsvProductList.Items[i].SubItems[12].Text.Replace(",", ""));
com.Parameters.Add("@AmountProduct", SqlDbType.NVarChar).Value = lsvProductList.Items[i].SubItems[4].Text.Replace(",", "");
com.Parameters.Add("@State", SqlDbType.Int).Value = Convert.ToInt32(lsvProductList.Items[i].SubItems[13].Text.Replace(",", ""));
com.Parameters.Add("@ReceiveDate", SqlDbType.DateTime).Value = Convert.ToDateTime(lsvProductList.Items[i].SubItems[1].Text.Replace(",", ""));
com.ExecuteNonQuery();
//MaxDetailId();
string weightext = lsvProductList.Items[i].SubItems[9].Text.ToString();
string Packtext = lsvProductList.Items[i].SubItems[10].Text.ToString();
string[] weighttextarr = weightext.Split('#');
int len = weighttextarr.Length;
string[] Packtextarr = Packtext.Split('#');
int lenPack = Packtextarr.Length;
if (weightext != "" && Packtext != "")
{
for (int j = 0; j < weighttextarr.Length - 1; j++)
{
sb.Remove(0, sb.Length);
sb.Append(" INSERT INTO SALEBACK_WEIGHT (SaleBackWeight,SaleBackHeadId,SaleBackPack,ProductId )");
sb.Append("VALUES( @SaleBackWeight,@SaleBackHeadId,@SaleBackPack,@ProductId)");
sqlSave = sb.ToString();
com.Parameters.Clear();
com.CommandText = sqlSave;
com.Parameters.Add("@SaleBackHeadId", SqlDbType.Int).Value = Convert.ToInt32(txtSaleBackId.Text.Trim());
com.Parameters.Add("@ProductId", SqlDbType.NVarChar).Value = lsvProductList.Items[i].SubItems[2].Text.Replace(",", "");
com.Parameters.Add("@SaleBackWeight", SqlDbType.Float).Value = Convert.ToSingle(weighttextarr[j].ToString()).ToString("#,##0.00");
com.Parameters.Add("@SaleBackPack", SqlDbType.Float).Value = Convert.ToSingle(Packtextarr[j].ToString());
com.ExecuteNonQuery();
}
}
else if (weightext != "" && Packtext == "")
{
for (int j = 0; j < weighttextarr.Length - 1; j++)
{
sb.Remove(0, sb.Length);
sb.Append("INSERT INTO SALEBACK_WEIGHT (SaleBackWeight,SaleBackHeadId,ProductId )");
sb.Append("VALUES( @SaleBackWeight,@SaleBackHeadId,@ProductId)");
sqlSave = sb.ToString();
com.Parameters.Clear();
com.CommandText = sqlSave;
com.Parameters.Add("@SaleBackHeadId", SqlDbType.Int).Value = Convert.ToInt32(txtSaleBackId.Text.Trim());
com.Parameters.Add("@ProductId", SqlDbType.NVarChar).Value = lsvProductList.Items[i].SubItems[2].Text.Replace(",", "");
com.Parameters.Add("@SaleBackWeight", SqlDbType.Float).Value = Convert.ToSingle(weighttextarr[j].ToString()).ToString("#,##0.00");
com.ExecuteNonQuery();
}
}
}
tr.Commit();
// ต้องการ print หรือไม่
DialogResult dlg = MessageBox.Show("ต้องการพิมพ์รายงานหรือไม่ !!!", "ผลการทำงาน", MessageBoxButtons.OKCancel, MessageBoxIcon.Question);
if (dlg == DialogResult.OK)
{
SaleBackSupplier.rptSaleBack frm = new SaleBackSupplier.rptSaleBack();
frm.StartPosition = FormStartPosition.CenterScreen; // กำหนด frm ย่อย ให้
frm.setSaleBackId = Convert.ToInt32(txtSaleBackId.Text); ;
frm.ShowDialog();
}
ClearProductList();
ClearProductDetails();
txtSaleBackId.Focus();
SaleBackId();
}
catch (Exception ex)
{
MessageBox.Show("ไม่สามารถบันทึกรายการได้ เนื่องจาก " + ex.Message, "ข้อผิดพลาด", MessageBoxButtons.OK, MessageBoxIcon.Warning);
cmdSave.Focus();
tr.Rollback();
}
}
}