private void dgv_show_CellDoubleClick(object sender, DataGridViewCellEventArgs e)
{
if (dgv_show.RowCount == 0)
{
return;
}
int i = e.RowIndex;
int j = e.ColumnIndex;
Class.valiballecommon va = Class.valiballecommon.GetStorage();
va.value1 = dgv_show.Rows[dgv_show.SelectedCells[0].RowIndex].Cells["Code_Type"].Value.ToString();
va.value2 = dgv_show.Rows[dgv_show.SelectedCells[0].RowIndex].Cells["Code_No"].Value.ToString();
va.value3 = dtp_from.Value.ToString("yyyy-MM-dd");
if (dgv_show.Rows[i].Cells["Shipping_Percent"].Selected || dgv_show.Rows[i].Cells["Delivery_Date"].Selected || dgv_show.Rows[i].Cells["Client_Request_Date"].Selected)
{
ERPShowShipping shipping = new ERPShowShipping();
shipping.ShowDialog();
}
else if (dgv_show.Rows[i].Cells["FinishedGoods"].Selected || dgv_show.Rows[i].Cells["NGQuantity"].Selected || dgv_show.Rows[i].Cells["OKQuantity"].Selected ||
dgv_show.Rows[i].Cells["Good_product_ratio"].Selected || dgv_show.Rows[i].Cells["Production_Rate"].Selected)
{
ERPShowOrder showOrder = new ERPShowOrder();
showOrder.ShowDialog();
}
}
private void ERPShowOrder_Load(object sender, EventArgs e)
{
if (Class.valiballecommon.GetStorage().value1 != null)
{
Class.valiballecommon va = Class.valiballecommon.GetStorage();
cmb_COPTC_TC002.Text = Class.valiballecommon.GetStorage().value2;
cmb_COPTC_TC001.Text = Class.valiballecommon.GetStorage().value1;
// string test = Class.valiballecommon.GetStorage().value3;
dtp_from.Value = (Class.valiballecommon.GetStorage().value3.Length > 8) ? Convert.ToDateTime(Class.valiballecommon.GetStorage().value3) : DateTime.MinValue;
va.value3 = null;
va.value1 = null;
va.value2 = null;
btn_search_Click(sender, e);
}
else
{
string sql_cmb_COPTC_TC001 = @"select distinct
moctas.TA026 as MaDDH
from MOCTA moctas
where moctas.TA026 != '' and moctas.TA027 != '' and moctas.TA013 = 'Y'";
sqlERPCON conERP = new sqlERPCON();
cmb_COPTC_TC001.Items.Clear();
conERP.getComboBoxData(sql_cmb_COPTC_TC001, ref cmb_COPTC_TC001);
if (cmb_COPTC_TC001.Items != null)
{
cmb_COPTC_TC001.SelectedIndex = 0;
}
}
}
private void AddERPConfigMail_Load(object sender, EventArgs e)
{
sqlCON dept = new sqlCON();
string sqldept = "select distinct deptcode from m_dept order by deptcode";
dept.getComboBoxData(sqldept, ref cmb_deptcode);
sqlCON function = new sqlCON();
string sqlfunction = "select distinct usingfunction from m_email order by usingfunction";
function.getComboBoxData(sqlfunction, ref cmb_usingfunction);
cmb_defaultstatus.Items.Add("YES");
cmb_defaultstatus.Items.Add("NO");
if (Class.valiballecommon.GetStorage().value1 != null)
{
cmb_deptcode.Text = Class.valiballecommon.GetStorage().value1;
txt_emailaddress.Text = Class.valiballecommon.GetStorage().value2;
cmb_usingfunction.Text = Class.valiballecommon.GetStorage().value3;
cmb_defaultstatus.Text = Class.valiballecommon.GetStorage().value4;
txt_emailaddress.Enabled = false;
Class.valiballecommon va = Class.valiballecommon.GetStorage();
va.value1 = null;
va.value2 = null;
va.value3 = null;
va.value4 = null;
addupdate = 0;
}
else
{
addupdate = 1;
}
}
private void btn_edit_Click(object sender, EventArgs e)
{
SettingForm.RegisterUserForm.AddRegisterUser frm = new SettingForm.RegisterUserForm.AddRegisterUser();
Class.valiballecommon va = Class.valiballecommon.GetStorage();
va.value1 = dgv_registeruser.Rows[dgv_registeruser.SelectedCells[0].RowIndex].Cells[1].Value.ToString();
va.value2 = dgv_registeruser.Rows[dgv_registeruser.SelectedCells[0].RowIndex].Cells[2].Value.ToString();
va.value3 = dgv_registeruser.Rows[dgv_registeruser.SelectedCells[0].RowIndex].Cells[3].Value.ToString();
if (frm.ShowDialog() == DialogResult.OK)
{
searchdata(ref dgv_registeruser, true);
}
}
private void btn_edit_Click(object sender, EventArgs e)
{
AddModelForm frm = new AddModelForm();
Class.valiballecommon va = Class.valiballecommon.GetStorage();
va.value1 = dgv_model.Rows[dgv_model.SelectedCells[0].RowIndex].Cells[1].Value.ToString();
va.value2 = dgv_model.Rows[dgv_model.SelectedCells[0].RowIndex].Cells[2].Value.ToString();
if (frm.ShowDialog() == DialogResult.OK)
{
searchdata(ref dgv_model, true);
}
}
private void ProductionChart_Load(object sender, EventArgs e)
{
Class.valiballecommon va = Class.valiballecommon.GetStorage();
txt_Production_Planning_Code.Text = Class.valiballecommon.GetStorage().value1;
txt_Production_Planning_No.Text = Class.valiballecommon.GetStorage().value2;
txt_Product_Code.Text = Class.valiballecommon.GetStorage().value3;
txt_Product_Name.Text = Class.valiballecommon.GetStorage().value4;
va.value1 = null;
va.value2 = null;
va.value3 = null;
va.value4 = null;
chartshow();
}
private void btn_edit_Click(object sender, EventArgs e)
{
AddERPConfigMail frm = new AddERPConfigMail();
Class.valiballecommon va = Class.valiballecommon.GetStorage();
va.value1 = dgv_show.Rows[dgv_show.SelectedCells[0].RowIndex].Cells[1].Value.ToString();
va.value2 = dgv_show.Rows[dgv_show.SelectedCells[0].RowIndex].Cells[2].Value.ToString();
va.value3 = dgv_show.Rows[dgv_show.SelectedCells[0].RowIndex].Cells[4].Value.ToString();
va.value4 = dgv_show.Rows[dgv_show.SelectedCells[0].RowIndex].Cells[3].Value.ToString();
va.valuleID = dgv_show.Rows[dgv_show.SelectedCells[0].RowIndex].Cells[0].Value.ToString();
if (frm.ShowDialog() == DialogResult.OK)
{
searchdata(ref dgv_show, true);
}
}
private void dgv_show_CellContentClick(object sender, DataGridViewCellEventArgs e)
{
int curRow = int.Parse(e.RowIndex.ToString());
if (dgv_show.Columns[e.ColumnIndex] == dtCol && curRow >= 0)
{
Class.valiballecommon va = Class.valiballecommon.GetStorage();
va.value1 = dgv_show.Rows[dgv_show.SelectedCells[0].RowIndex].Cells["Production_Planning_Code"].Value.ToString();
va.value2 = dgv_show.Rows[dgv_show.SelectedCells[0].RowIndex].Cells["Production_Planning_No"].Value.ToString();
va.value3 = dgv_show.Rows[dgv_show.SelectedCells[0].RowIndex].Cells["Product_Code"].Value.ToString();
va.value4 = dgv_show.Rows[dgv_show.SelectedCells[0].RowIndex].Cells["Product_Name"].Value.ToString();
ProductionChart chart = new ProductionChart();
chart.ShowDialog();
}
}
private void btn_edit_Click(object sender, EventArgs e)
{
AddIPPLC frm = new AddIPPLC();
Class.valiballecommon va = Class.valiballecommon.GetStorage();
va.value1 = dgv_ip.Rows[dgv_ip.SelectedCells[0].RowIndex].Cells[1].Value.ToString();
va.value2 = dgv_ip.Rows[dgv_ip.SelectedCells[0].RowIndex].Cells[2].Value.ToString();
va.value3 = dgv_ip.Rows[dgv_ip.SelectedCells[0].RowIndex].Cells[3].Value.ToString();
va.value4 = dgv_ip.Rows[dgv_ip.SelectedCells[0].RowIndex].Cells[4].Value.ToString();
va.value5 = dgv_ip.Rows[dgv_ip.SelectedCells[0].RowIndex].Cells[5].Value.ToString();
va.value6 = dgv_ip.Rows[dgv_ip.SelectedCells[0].RowIndex].Cells[6].Value.ToString();
if (frm.ShowDialog() == DialogResult.OK)
{
searchdata(ref dgv_ip, true);
}
}
private void AddDept_Load(object sender, EventArgs e)
{
if (Class.valiballecommon.GetStorage().value1 != null)
{
txt_deptcode.Text = Class.valiballecommon.GetStorage().value1;
txt_deptname.Text = Class.valiballecommon.GetStorage().value2;
txt_deptcode.Enabled = false;
Class.valiballecommon va = Class.valiballecommon.GetStorage();
va.value1 = null;
va.value2 = null;
addupdate = 0;
}
else
{
addupdate = 1;
}
}
private void ERPShowShipping_Load(object sender, EventArgs e)
{
string sql = "select distinct TC001 from COPTC where TC001 != '' order by TC001";
sqlERPCON conERP = new sqlERPCON();
conERP.getComboBoxData(sql, ref cmd_COPTC_TC001);
if (Class.valiballecommon.GetStorage().value1 != null)
{
Class.valiballecommon va = Class.valiballecommon.GetStorage();
cmd_COPTC_TC002.Text = Class.valiballecommon.GetStorage().value2;
cmd_COPTC_TC001.Text = Class.valiballecommon.GetStorage().value1;
// string test = Class.valiballecommon.GetStorage().value3;
dtp_from.Value = (Class.valiballecommon.GetStorage().value3.Length > 8) ? Convert.ToDateTime(Class.valiballecommon.GetStorage().value3) : DateTime.MinValue;
va.value3 = null;
va.value1 = null;
va.value2 = null;
btn_search_Click(sender, e);
}
}
private void dgv_show_CellClick(object sender, DataGridViewCellEventArgs e)
{
if (dgv_show.RowCount == 0)
{
return;
}
int i = e.RowIndex;
int j = e.ColumnIndex;
Class.valiballecommon va = Class.valiballecommon.GetStorage();
cmb_dept.Text = dgv_show.Rows[dgv_show.SelectedCells[0].RowIndex].Cells["deptcode"].Value.ToString();
cmb_productioncode.Text = dgv_show.Rows[dgv_show.SelectedCells[0].RowIndex].Cells["production_code"].Value.ToString();
txt_tagetoutput.Text = dgv_show.Rows[dgv_show.SelectedCells[0].RowIndex].Cells["output_taget"].Value.ToString();
txt_tagetNG.Text = dgv_show.Rows[dgv_show.SelectedCells[0].RowIndex].Cells["ng_taget"].Value.ToString();
cmb_type.Text = dgv_show.Rows[dgv_show.SelectedCells[0].RowIndex].Cells["type"].Value.ToString();
keyid = dgv_show.Rows[dgv_show.SelectedCells[0].RowIndex].Cells["id"].Value.ToString();
//cmb_dept.Enabled = false;
//cmb_productioncode.Enabled = false;
}
private void AddRegisterUser_Load(object sender, EventArgs e)
{
string sql = "select distinct permission from m_user ";
sqlCON connect = new sqlCON();
connect.getComboBoxData(sql, ref cmb_permission);
if (Class.valiballecommon.GetStorage().value1 != null)
{
txt_usercode.Text = Class.valiballecommon.GetStorage().value1;
txt_username.Text = Class.valiballecommon.GetStorage().value2;
cmb_permission.Text = Class.valiballecommon.GetStorage().value3;
txt_usercode.Enabled = false;
Class.valiballecommon va = Class.valiballecommon.GetStorage();
va.value1 = null;
va.value2 = null;
va.value3 = null;
addupdate = 0;
}
else
{
addupdate = 1;
}
}
private void AddProcessForm_Load_2(object sender, EventArgs e)
{
sqlCON connect = new sqlCON();
string sql = "select distinct modelcode from m_model order by modelcode";
connect.getComboBoxData(sql, ref cmb_modelcode);
if (Class.valiballecommon.GetStorage().value1 != null)
{
cmb_modelcode.Text = Class.valiballecommon.GetStorage().value1;
cmb_processcode.Text = Class.valiballecommon.GetStorage().value2;
txt_processname.Text = Class.valiballecommon.GetStorage().value3;
cmb_processcode.Enabled = false;
Class.valiballecommon va = Class.valiballecommon.GetStorage();
va.value1 = null;
va.value2 = null;
va.value3 = null;
addupdate = 0;
}
else
{
addupdate = 1;
}
}
private void btn_ok_Click(object sender, EventArgs e)
{
if (checkdata() == false)
{
return;
}
if (addupdate == 1) //add
{
sql = @"insert into m_email(emailaddress, deptcode, status, usingfunction, datetimeRST) values('"
+ txt_emailaddress.Text + "','" + cmb_deptcode.Text + "','" + cmb_defaultstatus.Text + "','" + cmb_usingfunction.Text + "',GETDATE())";
}
else //update
{
sql = "update m_email set deptcode = '" + cmb_deptcode.Text + "', status = '" + cmb_defaultstatus.Text + "', usingfunction ='" + cmb_usingfunction.Text + "' where id = '" + Class.valiballecommon.GetStorage().valuleID + "'";
Class.valiballecommon va = Class.valiballecommon.GetStorage();
va.valuleID = null;
}
sqlCON connect = new sqlCON();
connect.sqlExecuteNonQuery(sql, true);
this.DialogResult = DialogResult.OK;
this.Close();
}
private void AddIPPLC_Load(object sender, EventArgs e)
{
sqlCON data = new sqlCON();
if (Class.valiballecommon.GetStorage().value1 != null)
{
if (Class.valiballecommon.GetStorage().value6 == "True")
{
chk_active.Checked = true;
}
else
{
chk_active.Checked = false;
}
cmb_factory.Text = Class.valiballecommon.GetStorage().value1;
cmb_process.Text = Class.valiballecommon.GetStorage().value2;;
cmb_line.Text = Class.valiballecommon.GetStorage().value3;
txt_modelPLC.Text = Class.valiballecommon.GetStorage().value4;
cmb_ip.Text = Class.valiballecommon.GetStorage().value5;
// chk_active.Enabled = false;
cmb_ip.Enabled = false;
Class.valiballecommon va = Class.valiballecommon.GetStorage();
va.value1 = null;
va.value2 = null;
addupdate = 0;
}
else
{
addupdate = 1;
data.getComboBoxData("select distinct IPPLC from m_ipPLC", ref cmb_ip);
data.getComboBoxData("select distinct factory from m_ipPLC", ref cmb_factory);
data.getComboBoxData(" select distinct process from m_ipPLC", ref cmb_process);
data.getComboBoxData("select distinct line from m_ipPLC", ref cmb_line);
}
}
