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(); } }