private void bntPrintReport_Click(object sender, EventArgs e)
{
DataMain.rptProductAdd rpt= new rptProductAdd();
rpt.StartPosition = FormStartPosition.CenterScreen; // กำหนด frm ย่อย ให้อยู่ตรงกลาง
rpt.setProductId = strProductId;
MessageBox.Show(strProductId);
rpt.ShowDialog();
//sb = new StringBuilder();
//sb.Remove(0, sb.Length);
//sb.Append("SELECT PRODUCT.ProductId,PRODUCT.ProductIdExternal,PRODUCT.ProductParentId,");
//sb.Append("PRODUCT.ProductName,PRODUCT.ProductNameEng,MAINCATE.MainCateName,SUBCATE.SubCateName,");
//sb.Append("UNITSALE.UnitSaleName,UNITSTOCK.UnitStockName,PRODUCT.ProductStockConvert,UNITCONVERT.UnitConVertName,");
//sb.Append("PRODUCT.ProductPackQuantity,PRODUCT.ProductPackWeight,PRODUCT.ProductStockReorder,");
//sb.Append("PRODUCT.ProductPhoto,PRODUCT.ProductDateEntry,PRODUCT.ProductStatus,PRODUCT.UserId ");
//sb.Append("FROM (PRODUCT INNER JOIN MAINCATE ON PRODUCT.MainCateId = MAINCATE.MainCateId) ");
//sb.Append("INNER JOIN SUBCATE ON PRODUCT.SubCateId = SUBCATE.SubCateId ");
//sb.Append("INNER JOIN UNITSALE ON PRODUCT.UnitSaleId = UNITSALE.UnitSaleId ");
//sb.Append("INNER JOIN UNITSTOCK ON PRODUCT.UnitStockId = UNITSTOCK.UnitStockId ");
//sb.Append("INNER JOIN UNITCONVERT ON PRODUCT.UnitConvertId = UNITCONVERT.UnitConVertId WHERE (ProductID=@strProductId)");
//String sqlProductShowReport = sb.ToString();
//com = new SqlCommand(sqlProductShowReport, Conn);
//com.Parameters.Add("@strProductId", SqlDbType.NVarChar).Value = strProductId.ToString();
//da = new SqlDataAdapter(com);
//ds = new DataSet();
//da.Fill(ds, "ProductShow");
//for (int i = 0; i < ds.Tables["ProductShow"].Rows.Count; i++)
//{
// String StrProductIdExternal = ds.Tables["ProductShow"].Rows[i]["ProductIdExternal"].ToString();
// String StrProductParentId = ds.Tables["ProductShow"].Rows[i]["ProductParentId"].ToString();
// String StrProductName = ds.Tables["ProductShow"].Rows[i]["ProductName"].ToString();
// String StrProductNameEng = ds.Tables["ProductShow"].Rows[i]["ProductNameEng"].ToString();
// String StrMainCateName = ds.Tables["ProductShow"].Rows[i]["MainCateName"].ToString();
// String StrSubCateName = ds.Tables["ProductShow"].Rows[i]["SubCateName"].ToString();
// String StrUnitSaleName = ds.Tables["ProductShow"].Rows[i]["UnitSaleName"].ToString();
// String StrUnitStockName = ds.Tables["ProductShow"].Rows[i]["UnitStockName"].ToString();
// String StrProductStockConvert = ds.Tables["ProductShow"].Rows[i]["ProductStockConvert"].ToString();
// String StrUnitConVertName = ds.Tables["ProductShow"].Rows[i]["UnitConVertName"].ToString();
// String StrProductPackQuantity = ds.Tables["ProductShow"].Rows[i]["ProductPackQuantity"].ToString();
// String StrProductPackWeight = ds.Tables["ProductShow"].Rows[i]["ProductPackWeight"].ToString();
// String StrProductStockReorder = ds.Tables["ProductShow"].Rows[i]["ProductStockReorder"].ToString();
// String StrProductPhoto = ds.Tables["ProductShow"].Rows[i]["ProductPhoto"].ToString();
// String StrProductDateEntry = ds.Tables["ProductShow"].Rows[i]["ProductDateEntry"].ToString();
// String StrProductStatus = ds.Tables["ProductShow"].Rows[i]["ProductStatus"].ToString();
// String StrUserId = ds.Tables["ProductShow"].Rows[i]["UserId"].ToString();
// X = new Dataset.DataSet();
// if (X.DT_AddProduct.Rows.Count > 0)
// {
// X.DT_AddProduct.Clear();
// }
// else
// {
// X.DT_AddProduct.Rows.Add(strProductId, StrProductIdExternal, StrProductParentId, StrProductName, StrProductNameEng, StrMainCateName, StrSubCateName, StrUnitSaleName, StrUnitStockName, StrProductStockConvert, StrUnitConVertName, StrProductPackQuantity, StrProductPackWeight, StrProductStockReorder, StrProductPhoto, StrProductDateEntry, StrProductStatus, StrUserId);
// frm = new DataMain.rptProductAdd();
// frm.Xx = X;
// }
//}
//frm.ShowDialog();
///*if (printDialog1.ShowDialog() == DialogResult.OK)
//{
// printDocument1.Print();//พิมพ์เอกสาร
//}*/
}
public void insertproduct(string DatabaseName)
{
tr = Conn.BeginTransaction();
try
{
sb = new StringBuilder();
sb.Remove(0, sb.Length);
sb.Append("INSERT INTO PRODUCT (ProductId,ProductIdExternal,ProductIdExternal2,ProductParentId,ProductName,ProductNameEng,");
sb.Append("ProductDescript,MainCateId,SubCateId,UnitChildId,UnitSaleId,UnitPackId,UnitStockId,");
sb.Append("ProductStockConvert,UnitConvertId,ProductStockReorder,ProductPackQuantity,ProductPackWeight,ProductOrderId,ProductDateEntry)");
sb.Append(" VALUES (@ProductId,@ProductIdExternal,@ProductIdExternal2,@ProductParentId,@ProductName,@ProductNameEng,");
sb.Append("@ProductDescript,@MainCateId,@SubCateId,@UnitChildId,@UnitSaleId,@UnitPackId,@UnitStockId,");
sb.Append("@ProductStockConvert,@UnitConvertId,@ProductStockReorder,@ProductPackQuantity,@ProductPackWeight,@ProductOrderId,@ProductDateEntry)");
// ต่อ String รหัสสินค้า
string sqlAdd;
sqlAdd = sb.ToString();
com.CommandText = sqlAdd;
com.CommandType = CommandType.Text;
com.Connection = Conn;
com.Transaction = tr;
com.Parameters.Clear();
String strProductParentId = txtNewBarcode1.Text + txtNewBarcode2.Text + txtNewBarcode3.Text;
strProductId = txtNewBarcode1.Text + txtNewBarcode2.Text + txtNewBarcode3.Text;
strProductId += "-";
strProductId += txtBarcode5.Text;
com.Parameters.Add("@ProductId", SqlDbType.NVarChar).Value = strProductId;
com.Parameters.Add("@ProductOrderId", SqlDbType.NVarChar).Value = txtNewBarcode3.Text.Trim();
com.Parameters.Add("@ProductIdExternal", SqlDbType.NVarChar).Value = txtProductIdExternal.Text.Trim();
com.Parameters.Add("@ProductIdExternal2", SqlDbType.NVarChar).Value = txtProductIdExternal2.Text.Trim();
com.Parameters.Add("@ProductParentId", SqlDbType.NVarChar).Value = strProductParentId;
com.Parameters.Add("@ProductName", SqlDbType.NVarChar).Value = txtProductName.Text.Trim();
com.Parameters.Add("@ProductNameEng", SqlDbType.NVarChar).Value = txtProductNameEng.Text.Trim();
com.Parameters.Add("@ProductDescript", SqlDbType.NVarChar).Value = txtProductDescript.Text.ToString();
com.Parameters.Add("@MainCateId", SqlDbType.NVarChar).Value = cboMainCate.SelectedValue.ToString();
com.Parameters.Add("@SubCateId", SqlDbType.NVarChar).Value = cboSubCate.SelectedValue.ToString();
com.Parameters.Add("@UnitChildId", SqlDbType.NVarChar).Value = cboUnitChild.SelectedValue.ToString();
com.Parameters.Add("@UnitSaleId", SqlDbType.NVarChar).Value = cboUnitSale.SelectedValue.ToString();
com.Parameters.Add("@UnitPackId", SqlDbType.NVarChar).Value = cboUnitPack.SelectedValue.ToString();
com.Parameters.Add("@UnitStockId", SqlDbType.NVarChar).Value = cboUnitStock.SelectedValue.ToString();
com.Parameters.Add("@ProductStockConvert", SqlDbType.NVarChar).Value = txtProductConvert.Text.Trim();
com.Parameters.Add("@UnitConvertId", SqlDbType.NVarChar).Value = cboUnitConvert.SelectedValue.ToString();
com.Parameters.Add("@ProductStockReorder", SqlDbType.NVarChar).Value = txtProductReorder.Text.Trim();
com.Parameters.Add("@ProductPackQuantity", SqlDbType.NVarChar).Value = txtQauntityPack.Text.Trim();
com.Parameters.Add("@ProductPackWeight", SqlDbType.NVarChar).Value = txtQuantityWeight.Text.Trim();
com.Parameters.Add("@ProductDateEntry", SqlDbType.DateTime).Value = DateTime.Now;
com.ExecuteNonQuery();
tr.Commit();
DialogResult dlg = MessageBox.Show("ต้องการพิมพ์รายงานหรือไม่ !!!", "ผลการทำงาน", MessageBoxButtons.OKCancel, MessageBoxIcon.Question);
if (dlg == DialogResult.OK)
{
DataMain.rptProductAdd rpt = new rptProductAdd();
rpt.StartPosition = FormStartPosition.CenterScreen; // กำหนด frm ย่อย ให้อยู่ตรงกลาง
rpt.setProductId = strProductId;
rpt.ShowDialog();
}
MessageBox.Show("เพิ่มสินค้าใหม่ที่ " + DatabaseName + " เรียบร้อยแล้ว !!!", "ผลการทำงาน", MessageBoxButtons.OK, MessageBoxIcon.Information);
DataMain.frmProductMain frmProductMain = new KTCERP.DataMain.frmProductMain();
Close();
}
catch (Exception ex)
{
MessageBox.Show("เพิ่มไม่ได้ครับ \n เนื่องจาก " + ex.Message, "ผลการทำงาน", MessageBoxButtons.OK, MessageBoxIcon.Information);
tr.Rollback();
}
}
