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 Cmb_COPTC_TC002_SelectedIndexChanged(object sender, EventArgs e)
{
string sql = "select distinct TA001, TA002 from MOCTA where TA013 ='Y' and TA026 ='" + cmb_COPTC_TC001.Text + "' and TA027 ='" + cmb_COPTC_TC002.Text + "' order by TA001";
sqlERPCON conERP = new sqlERPCON();
cmb_MOCTA_TA001.Items.Clear();
cmb_MOCTA_TA002.Items.Clear();
conERP.getComboBoxData(sql, ref cmb_MOCTA_TA001, ref cmb_MOCTA_TA002);
if (cmb_MOCTA_TA001.Items != null)
{
cmb_MOCTA_TA001.Items.Add("");
cmb_MOCTA_TA001.SelectedIndex = 0;
}
if (cmb_MOCTA_TA002.Items != null)
{
cmb_MOCTA_TA002.Items.Add("");
cmb_MOCTA_TA002.SelectedIndex = 0;
}
cmb_MOCTA_TA001.Text = "";
cmb_MOCTA_TA002.Text = "";
}
private void DailyTagetForm_Load(object sender, EventArgs e)
{
sqlERPCON conndept = new sqlERPCON();
conndept.getComboBoxData("select distinct TC004 from SFCTC order by TC004", ref cmb_dept);
}