protected void lbtnSaveEdit_Click(object sender, EventArgs e)
{
Thread.CurrentThread.CurrentCulture = new CultureInfo("en-US");
DBConnect dbBranch = new DBConnect("Center");
string setpp_id = "";
DateTime datenow = DateTime.Now;
foreach (CheckBox item in lstChckBox)
{
if (item.Checked == true)
{
setpp_id = item.ID;
break;
}
}
if (setpp_id != "")
{
if (tbdisbursestcok.Text != "")
{
string sqlstock = "SELECT st.group_name,st.st_id,st.Itemcode,st.Itemname,st.Itemtotal_amount," +
"st.unit,st.storage_number,st.remark FROM [DBRDEngineering].[dbo].[Stock] as st " +
"where st.st_id ='" + tbstock_id.Text + "'";
DataSet dsstock = dbBranch.DBSelect(sqlstock);
int countstock = dsstock.Tables[0].Rows.Count;
if (countstock > 0)
{
for (int i = 0; i < countstock; i++)
{
string st_id = dsstock.Tables[0].Rows[i]["st_id"].ToString();
string Itemtotal_amount = dsstock.Tables[0].Rows[i]["Itemtotal_amount"].ToString();
// mcname = mcname.ToUpper();
if (tbdisbursestcok.Text != "")
{
int add_amount = Convert.ToInt32(Itemtotal_amount) - Convert.ToInt32(tbdisbursestcok.Text);
string stock_add = "'" + st_id + "','จ่าย','" + tbdisbursestcok.Text + "','" + add_amount + "','" + Session["Emp_id"].ToString() + "',Getdate()";
string sqlInsert = "INSERT History_stock(st_id,his_nametype,amount,his_totalamount,emp_id,inpdate) VALUES(" + stock_add + ")";
bool checkInsert = dbBranch.DBQuery(sqlInsert);
if (checkInsert == true)
{
string sqlupdate = "UPDATE Stock set Itemtotal_amount = '" + add_amount + "' where st_id = '" + st_id + "'";
bool checkupdate = dbBranch.DBQuery(sqlupdate);
//bool ckhistory = WovenHistory.SaveHistory(ddlBranch.SelectedValue, "ข้อมูลเครื่องทอ", "เพิ่มเครื่องทอ " + mcname, Session["emp_id"].ToString());
//if (ckhistory == false)
//{
// ShowMessage("ไม่สามารถบันทึกประวัติการทำกิจกรรมได้ กรุณาติดต่อฝ่ายผลิตชิ้นส่วนและอุปกรณ์", MessageType.Warning);
//}
ShowMessage("บันทึกข้อมูลสำเร็จ", MessageType.Success);
ScriptManager.RegisterClientScriptBlock(this, typeof(Page), "redirectJS", "setTimeout(function() { window.location.replace('Stock.aspx') }, 3000);", true);
}
else
{
ShowMessage("ไม่สามารถบันทึกข้อมูลได้ กรุณาลองใหม่อีกครั้งหรือติดต่อฝ่ายผลิตชิ้นส่วนและอุปกรณ์", MessageType.Error);
}
}
else
{
ShowMessage("กรุณากรอกข้อมูลให้ครบ", MessageType.Warning);
}
}
}
}
}
}
private void showPLCgrouptor()
{
int num = 0;
DBConnect dbBranch = new DBConnect("Center");
string sqlstock = "SELECT st.group_name,st.st_id,st.Itemcode,st.Itemname,st.Itemtotal_amount" +
",st.unit,st.storage_number,st.remark FROM [DBRDEngineering].[dbo].[Stock] as st ";
DataSet dsstock = dbBranch.DBSelect(sqlstock);
int countstock = dsstock.Tables[0].Rows.Count;
if (countstock > 0)
{
for (int i = 0; i < countstock; i++)
{
num = num + 1;
string st_id = dsstock.Tables[0].Rows[i]["st_id"].ToString();
string group_name = dsstock.Tables[0].Rows[i]["group_name"].ToString();
string Itemcode = dsstock.Tables[0].Rows[i]["Itemcode"].ToString();
string Itemname = dsstock.Tables[0].Rows[i]["Itemname"].ToString();
string Itemtotal_amount = dsstock.Tables[0].Rows[i]["Itemtotal_amount"].ToString();
string unit = dsstock.Tables[0].Rows[i]["unit"].ToString();
string storage_number = dsstock.Tables[0].Rows[i]["storage_number"].ToString();
string remark = dsstock.Tables[0].Rows[i]["remark"].ToString();
TableRow rowdata = new TableRow();
TableCell celldata = new TableCell();
CheckBox cbSpares = new CheckBox();
cbSpares.ID = st_id;
cbSpares.SkinID = Itemname;
cbSpares.Checked = false;
celldata.Controls.Add(cbSpares);
celldata.HorizontalAlign = HorizontalAlign.Center;
lstChckBox.Add(cbSpares);
rowdata.Cells.Add(celldata);
celldata = new TableCell();
celldata.Text = num.ToString();
rowdata.Cells.Add(celldata);
celldata = new TableCell();
celldata.Text = Itemcode;
rowdata.Cells.Add(celldata);
celldata = new TableCell();
celldata.Text = Itemname;
rowdata.Cells.Add(celldata);
celldata = new TableCell();
celldata.Text = group_name;
rowdata.Cells.Add(celldata);
celldata = new TableCell();
celldata.Text = storage_number;
rowdata.Cells.Add(celldata);
celldata = new TableCell();
celldata.Text = unit;
rowdata.Cells.Add(celldata);
celldata = new TableCell();
celldata.Text = Itemtotal_amount;
rowdata.Cells.Add(celldata);
//---------------------------//
//celldata = new TableCell();
//celldata.Text = meshTotalNumber;
//rowdata.Cells.Add(celldata);
//celldata = new TableCell();
//celldata.Text = eyeset_remainder_low;
//rowdata.Cells.Add(celldata);
//celldata = new TableCell();
//celldata.Text = eyeset_remainder_high;
//rowdata.Cells.Add(celldata);
//celldata = new TableCell();
//celldata.Text = meshremainder_percent;
//rowdata.Cells.Add(celldata);
//celldata = new TableCell();
//celldata.Text = inpem;
//rowdata.Cells.Add(celldata);
//celldata = new TableCell();
//celldata.Text = inpdate;
//rowdata.Cells.Add(celldata);
//if (role_id == true)
//{
celldata = new TableCell();
LinkButton lbtneditmeshcode = new LinkButton();
lbtneditmeshcode.Text = "<span class='glyphicon glyphicon-th-list' aria-hidden='true'></span> การรับ/จ่าย";
lbtneditmeshcode.ForeColor = System.Drawing.Color.DarkOrange;
lbtneditmeshcode.CommandArgument = st_id;
lbtneditmeshcode.Click += new EventHandler(modelOpedetailadddisbursestock_click);
celldata.Controls.Add(lbtneditmeshcode);
rowdata.Cells.Add(celldata);
// celldata = new TableCell();
// LinkButton lbtnmodaldel = new LinkButton();
// lbtnmodaldel.Text = "<span class='glyphicon glyphicon-trash' aria-hidden='true'></span> ลบ";
// lbtnmodaldel.ID = msd_id;
// lbtnmodaldel.ForeColor = System.Drawing.Color.Red;
// lbtnmodaldel.Click += new EventHandler(lbtndeletemeshtotalnumberstandard_Click);
// celldata.Controls.Add(lbtnmodaldel);
// rowdata.Cells.Add(celldata);
//}
//else
//{
// celldata = new TableCell();
// celldata.Text = "<span class='glyphicon glyphicon-edit' aria-hidden='true'></span> แก้ไข";
// celldata.ForeColor = System.Drawing.Color.DarkOrange;
// rowdata.Cells.Add(celldata);
// celldata = new TableCell();
// celldata.Text = "<span class='glyphicon glyphicon-trash' aria-hidden='true'></span> ลบ";
// celldata.ForeColor = System.Drawing.Color.Red;
// rowdata.Cells.Add(celldata);
//}
tblStock.Rows.Add(rowdata);
}
}
}
protected void modelOpedetailadddisbursestock_click(object sender, EventArgs e)
{
LinkButton source = (LinkButton)sender;
int num = 0;
DBConnect dbBranch = new DBConnect("Center");
string sqlstock = "SELECT sht.his_totalamount,sht.inpdate,sht.emp_id,sht.amount,sht.his_nametype,st.group_name,st.st_id,st.Itemcode,st.Itemname,st.Itemtotal_amount" +
",st.unit,st.storage_number,st.remark FROM [DBRDEngineering].[dbo].[Stock] as st " +
"left JOIN [DBRDEngineering].[dbo].[History_stock] as sht ON sht.st_id = st.st_id " +
"where st.st_id = '" + source.CommandArgument + "' ";
DataSet dsstock = dbBranch.DBSelect(sqlstock);
int countstock = dsstock.Tables[0].Rows.Count;
if (countstock > 0)
{
for (int i = 0; i < countstock; i++)
{
num = num + 1;
string st_id = dsstock.Tables[0].Rows[i]["st_id"].ToString();
string group_name = dsstock.Tables[0].Rows[i]["group_name"].ToString();
string Itemcode = dsstock.Tables[0].Rows[i]["Itemcode"].ToString();
string Itemname = dsstock.Tables[0].Rows[i]["Itemname"].ToString();
string his_nametype = dsstock.Tables[0].Rows[i]["his_nametype"].ToString();
string amount = dsstock.Tables[0].Rows[i]["amount"].ToString();
string emp_id = dsstock.Tables[0].Rows[i]["emp_id"].ToString();
DateTime inpdate = new DateTime();
DateTime.TryParse(dsstock.Tables[0].Rows[i]["inpdate"].ToString(), out inpdate);
string Itemtotal_amount = dsstock.Tables[0].Rows[i]["Itemtotal_amount"].ToString();
string his_totalamount = dsstock.Tables[0].Rows[i]["his_totalamount"].ToString();
string unit = dsstock.Tables[0].Rows[i]["unit"].ToString();
string storage_number = dsstock.Tables[0].Rows[i]["storage_number"].ToString();
string remark = dsstock.Tables[0].Rows[i]["remark"].ToString();
TableRow rowdata = new TableRow();
TableCell celldata = new TableCell();
celldata = new TableCell();
celldata.Text = num.ToString();
rowdata.Cells.Add(celldata);
celldata = new TableCell();
celldata.Text = his_nametype;
rowdata.Cells.Add(celldata);
celldata = new TableCell();
celldata.Text = Itemname;
rowdata.Cells.Add(celldata);
celldata = new TableCell();
celldata.Text = group_name;
rowdata.Cells.Add(celldata);
celldata = new TableCell();
celldata.Text = storage_number;
rowdata.Cells.Add(celldata);
celldata = new TableCell();
celldata.Text = unit;
rowdata.Cells.Add(celldata);
celldata = new TableCell();
celldata.Text = amount;
rowdata.Cells.Add(celldata);
celldata = new TableCell();
celldata.Text = his_totalamount;
rowdata.Cells.Add(celldata);
celldata = new TableCell();
celldata.Text = emp_id;
rowdata.Cells.Add(celldata);
celldata = new TableCell();
celldata.Text = inpdate.ToString("dd/MM/yyyy HH:mm");
rowdata.Cells.Add(celldata);
//---------------------------//
tbldetailadddisbursestock.Rows.Add(rowdata);
}
}
Page.ClientScript.RegisterStartupScript(GetType(), "Pop", "modeldetailadddisbursestock();", true);
}