private void cmb_ordercode_SelectedIndexChanged(object sender, EventArgs e)
{
string sql = "select DISTINCT TC002 from COPTC where TC001 like '" + cmb_TC001.Text + "' order by TC002 ASC";
sqlERPCON connect = new sqlERPCON();
connect.getComboBoxData(sql, ref cmb_TC002);
}
private void cmd_product_cmd_SelectedIndexChanged(object sender, EventArgs e)
{
string sql = "select DISTINCT TA002 from MOCTA where TA001 like '" + cmb_TA001.Text + "' order by TA002 ASC";
sqlERPCON connect = new sqlERPCON();
connect.getComboBoxData(sql, ref cmb_TA002);
}
private void cmd_COPTC_TC001_SelectedIndexChanged(object sender, EventArgs e)
{
string sql = "select distinct TC002 from COPTC where TC001 ='" + cmd_COPTC_TC001.Text + "' order by TC002";
sqlERPCON conERP = new sqlERPCON();
conERP.getComboBoxData(sql, ref cmd_COPTC_TC002);
}
private void GetDataFromShipping(DateTime datefrom, DateTime dateto)
{
dt = new DataTable();
StringBuilder sql = new StringBuilder();
sql.Append(@"select
coptcs.TC001 as Code_Type,
coptcs.TC002 as Code_No,
coptds.TD004 as Product_Code,
sum(copths.TH008) as Delivery_Quantity,
max(coptgs.TG003) as Delivery_Date
from COPTC coptcs
left join COPTD coptds on coptcs.TC002 = coptds.TD002 and coptcs.TC001 = coptds.TD001 -- cong doan tao don
left join COPTH copths on coptcs.TC002 = copths.TH015 and coptcs.TC001 = copths.TH014 and copths.TH004 =coptds.TD004
left join COPTG coptgs on copths.TH002 = coptgs.TG002 and copths.TH001 = coptgs.TG001 --cong doan giao hang
where 1=1
and coptcs.TC027 = 'Y' and coptgs.TG023 ='Y'
");
sql.Append(" and CONVERT(date,coptds.TD013) >= '" + datefrom + "' ");
sql.Append(" and CONVERT(date,coptds.TD013) <= '" + dateto + "' ");
sql.Append(@"group by
coptcs.CREATE_DATE,
coptcs.TC001 ,
coptcs.TC002 ,
coptds.TD004
");
sql.Append("order by coptcs.TC001, coptcs.TC002");
sqlERPCON con = new sqlERPCON();
con.sqlDataAdapterFillDatatable(sql.ToString(), ref dt);
}
public List <SemiFinishedGoods> ListGetSemiFinishedGoods(string dept, string product)
{
List <SemiFinishedGoods> Listsemifinishedgoods = new List <SemiFinishedGoods>();
try
{
DataTable dtSemi = new DataTable();
StringBuilder sql = new StringBuilder();
sql.Append("select MD001,MD003,MD006,MD012 from BOMMD where 1=1 and MD003 like '%B-%' ");//lenh tim kiem chua chat che lam
sql.Append(" and MD001 = '" + product + "'");
sqlERPCON sqlCON = new sqlERPCON();
sqlCON.sqlDataAdapterFillDatatable(sql.ToString(), ref dtSemi);
for (int i = 0; i < dtSemi.Rows.Count; i++)
{
SemiFinishedGoods semiFinished = new SemiFinishedGoods();
// semiFinished.Item = dtSemi.Rows[i]["MD003"].ToString();
semiFinished = GetStockGoodsONSFT(dept, dtSemi.Rows[i]["MD003"].ToString());
Listsemifinishedgoods.Add(semiFinished);
}
}
catch (Exception ex)
{
SystemLog.Output(SystemLog.MSG_TYPE.Err, "ListGetSemiFinishedGoods(string product) : " + product, ex.Message);
}
return(Listsemifinishedgoods);
}
private void LoadTreeviewDeptment()
{
TreeNode trnode = new TreeNode("ALL DEPARTMENTS");
trnode.Name = "Node_Depts";
trv_department.Nodes.Clear();
dt = new DataTable();
sqlERPCON conERP = new sqlERPCON();
conERP.sqlDataAdapterFillDatatable("select distinct b.TC005,a.ME002 from CMSME a inner join COPTC b on a.ME001 = b.TC005 order by b.TC005 ", ref dt);
TreeNode child = new TreeNode();
foreach (DataRow row in dt.Rows)
{
child = new TreeNode(row[0].ToString() + ": " + row[1].ToString());
trnode.Nodes.Add(child);
}
trv_department.Nodes.Add(trnode);
trv_department.AfterCheck += Trv_department_AfterCheck;
trnode.Checked = true;
}
private void ERPShowMain_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);
}
public double QuantityCanRun(string lot)
{
double ReadyQty = 0;
try
{
if (lot.Length == 26)
{
sqlERPCON data = new sqlERPCON();
string lottam = lot;
double StockERP = double.Parse(data.sqlExecuteScalarString("select isnull(sum(TA011+TA012),'0') from SFCTA where ( TA001+ '-'+RTRIM(TA002)+';'+ TA003 +';'+TA004 +';'+TA006 ) = '" + lot + "' "));
var PlanERP = double.Parse(data.sqlExecuteScalarString("select (isnull (TA010,'0')) from SFCTA where ( TA001+ '-'+RTRIM(TA002)+';'+ TA003 +';'+TA004 +';'+TA006 ) = '" + lot + "' "));
sqlCON sqlCON = new sqlCON();
double StockRealtime = double.Parse(sqlCON.sqlExecuteScalarString("select isnull(sum(cast( isnull(data,'0') as int)),0) from m_ERPMQC_REALTIME where lot = '" + lot + "' and remark != 'RW'"));
var MAXSYSTEM = StockERP >= StockRealtime ? StockERP : StockRealtime;
ReadyQty = (PlanERP - MAXSYSTEM);
}
}
catch (Exception ex)
{
SystemLog.Output(SystemLog.MSG_TYPE.Err, "QuantityCanRun(string lot)", ex.Message);
}
return(ReadyQty);
}
public List <StockOfSemi> stockOfSemis(string SemiProduct, double rate)
{
List <StockOfSemi> Semis = new List <StockOfSemi>();
try
{
DataTable dt = new DataTable();
StringBuilder sql = new StringBuilder();
sql.Append("select MC001,MC002,MC007 from INVMC where (MC002 = 'A03' or MC002 = 'A09') ");
sql.Append(" and MC001 = '" + SemiProduct + "'");
sqlERPCON sqlCON = new sqlERPCON();
sqlCON.sqlDataAdapterFillDatatable(sql.ToString(), ref dt);
Semis = (from DataRow dr in dt.Rows
select new StockOfSemi()
{
Semi = dr["MC001"].ToString().Trim(),
Stock = (dr["MC007"].ToString() != "" && rate != 0) ? Math.Round((double.Parse(dr["MC007"].ToString()) / rate), 0) : 0,
Warehourse = dr["MC002"].ToString().Trim()
}).ToList();
}
catch (Exception ex)
{
SystemLog.Output(SystemLog.MSG_TYPE.Err, "stockOfSemis(string SemiProduct, double rate)", ex.Message);
}
return(Semis);
}
private void LoadTreeviewDeptment()
{
TreeNode trnode = new TreeNode("ALL DEPARTMENTS");
trnode.Name = "Node_Depts";
trv_department.Nodes.Clear();
dt = new DataTable();
sqlERPCON conERP = new sqlERPCON();
conERP.sqlDataAdapterFillDatatable("select distinct TC004 from SFCTC ", ref dt);
TreeNode child = new TreeNode();
foreach (DataRow row in dt.Rows)
{
child = new TreeNode(row[0].ToString());
trnode.Nodes.Add(child);
}
trv_department.Nodes.Add(trnode);
trv_department.NodeMouseClick += Trv_department_NodeMouseClick;
trv_department.AfterCheck += Trv_department_AfterCheck;
trnode.Checked = false;
}
public DataTable GetDataTableBOMHQonERP(string ma_SP)
{
DataTable dt = new DataTable();
StringBuilder stringBuilder = new StringBuilder();
stringBuilder.Append(@" with BOMLevel1 as
(select d.MD001 ,d.MD002, d.MD003 ,d.MD004,cast(MD006/MD007 as decimal(10,3)) as Amoutused, 1 as [Level]
from BOMMC c
inner join BOMMD d on MC001 = MD001 ");
stringBuilder.Append(" where MC001 = '" + ma_SP + "' ");
stringBuilder.Append(@" union all
select d.MD001,d.MD002, d.MD003 ,d.MD004,cast(MD006/MD007 as decimal(10,3)) as Amoutused, dlevel.Level+1
from BOMMD d
inner join BOMLevel1 dlevel on d.MD001 = dlevel.MD003
)
select distinct d.MB201 as MA_NVL,f.XA003 as HS_CODE, cast( SUM(c.Amoutused/e.MC004 ) as decimal(10,3)) as DM_SD , c.MD004 as MA_DVT from BOMLevel1 c
inner join INVMB d on MB001 = c.MD003
inner join BOMMC e on c.MD001 = e.MC001
inner join BOMXA f on d.MB201 = f.XA001
WHERE Level < 2 AND MB201 != ''
group by d.MB201, c.MD004,c.Level, f.XA003 ");
sqlERPCON sqlERPCON = new sqlERPCON();
sqlERPCON.sqlDataAdapterFillDatatable(stringBuilder.ToString(), ref dt);
return(dt);
}
public List <LSX_SFTTA> ListSFTTA(string code, string No)
{
List <LSX_SFTTA> lSX_SFTTAs = new List <LSX_SFTTA>();
sqlERPCON query = new sqlERPCON();
StringBuilder strSQL = new StringBuilder();
DataTable dt = new DataTable();
strSQL.Append("select TA001,TA002,TA003,TA004,TA008,TA009,TA010,TA011,TA012 from SFCTA where TA003 = '0010' and ");
strSQL.Append(" TA001 = '" + code + "' and ");
strSQL.Append(" TA002 = '" + No + "'");
query.sqlDataAdapterFillDatatable(strSQL.ToString(), ref dt);
//Load data into list
for (int i = 0; i < dt.Rows.Count; i++)
{
LSX_SFTTA sFTTA = new LSX_SFTTA();
sFTTA.code = dt.Rows[i]["TA001"].ToString();
sFTTA.No = dt.Rows[i]["TA002"].ToString();
sFTTA.MaSX_TA003 = dt.Rows[i]["TA003"].ToString();
sFTTA.MaSX_TA004 = dt.Rows[i]["TA004"].ToString();
sFTTA.NgayBatdau_TA008 = dt.Rows[i]["TA008"].ToString();
sFTTA.NgayKetThuc_TA009 = dt.Rows[i]["TA009"].ToString();
sFTTA.SLKeHoach_TA010 = dt.Rows[i]["TA010"].ToString() != "" ? double.Parse(dt.Rows[i]["TA010"].ToString()) : 0;
sFTTA.SLOutput_TA011 = dt.Rows[i]["TA011"].ToString() != "" ? double.Parse(dt.Rows[i]["TA011"].ToString()) : 0;
sFTTA.SLBaoPhe_TA012 = dt.Rows[i]["TA012"].ToString() != "" ? double.Parse(dt.Rows[i]["TA012"].ToString()) : 0;
lSX_SFTTAs.Add(sFTTA);
}
return(lSX_SFTTAs);
}
public bool IscheckFIFO(string material, string lot, string warehouse)
{
StringBuilder stringBuilder = new StringBuilder();
stringBuilder.Append(@"
select ME009,a.* from INVMM a
inner join INVME b on ME001 = MM001 and ME002= MM004
where 1=1
");
stringBuilder.Append(" and MM002 = '" + warehouse + "' ");
stringBuilder.Append(" and MM001 = '" + material + "' ");
stringBuilder.Append(@" AND MM005 > 0
order by CAST(ME009 as datetime) DESC ");
DataTable dt = new DataTable();
sqlERPCON sqlERPCON = new sqlERPCON();
sqlERPCON.sqlDataAdapterFillDatatable(stringBuilder.ToString(), ref dt);
var dtrow = dt.AsEnumerable().Where(d => d.Field <string>("MM004").Trim() == lot).ToList();
if (dtrow.Count == 1)
{
DateTime dtExpiryRow = DateTime.ParseExact(dtrow[0]["ME009"].ToString(), "yyyyMMdd", CultureInfo.CurrentCulture);
for (int i = 0; i < dt.Rows.Count; i++)
{
DateTime dtExpiryi = DateTime.ParseExact(dt.Rows[i]["ME009"].ToString(), "yyyyMMdd", CultureInfo.CurrentCulture);
if (dtExpiryi < dtExpiryRow)
{
return(false);
}
}
}
return(true);
}
public double StockOfProduct(string ProducNo)
{
try
{
StringBuilder stringBuilder = new StringBuilder();
stringBuilder.Append(@" select MB064 from INVMB where 1=1
");
stringBuilder.Append(" and MB001 = '" + ProducNo + "' ");
sqlERPCON sqlERPCON = new sqlERPCON();
string data = sqlERPCON.sqlExecuteScalarString(stringBuilder.ToString());
if (data != string.Empty)
{
try
{
return(double.Parse(data));
}
catch (Exception)
{
return(0);
}
}
}
catch (Exception)
{
return(0);
}
return(0);
}
public List <string> ListHENNofProduct(string ProductNO)
{
try
{
StringBuilder stringBuilder = new StringBuilder();
stringBuilder.Append(@" select distinct TE017 from MOCTA
left join MOCTE on TA001 = TE011 and TA002 = TE012
where (TE018 like '%HENN%' ) and TE019 ='Y'
");
stringBuilder.Append(" and TA034 = '" + ProductNO + "' ");
sqlERPCON sqlERPCON = new sqlERPCON();
DataTable dt = new DataTable();
sqlERPCON.sqlDataAdapterFillDatatable(stringBuilder.ToString(), ref dt);
if (dt != null && dt.Rows.Count > 0)
{
return(dt.AsEnumerable()
.Select(r => r.Field <string>("TE017"))
.ToList());
}
else
{
return(null);
}
}
catch (Exception ex)
{
return(null);
}
}
public List <ProductionItem> GetProductionItems(string product, DateTime maxDate)
{
List <ProductionItem> productionItems = new List <ProductionItem>();
try
{
StringBuilder stringBuilder = new StringBuilder();
stringBuilder.Append(@"select TC047 as product, CREATE_DATE, CREATE_TIME ,TC014 as SLNghiemThu, TC016 as SLBaophe
from SFCTC
where 1=1 ");
stringBuilder.Append(" and TC047 like '%" + product + "%'");
stringBuilder.Append(" and CREATE_DATE in ('" + maxDate.ToString("yyyyMMdd") + "', '" + maxDate.AddDays(-1).ToString("yyyyMMdd") + "')");
stringBuilder.Append("order by CREATE_DATE, CREATE_TIME");
DataTable dt = new DataTable();
sqlERPCON sqlERPCON = new sqlERPCON();
sqlERPCON.sqlDataAdapterFillDatatable(stringBuilder.ToString(), ref dt);
productionItems = (from DataRow dr in dt.Rows
select new ProductionItem()
{
Product = (dr["product"] != null) ? dr["product"].ToString().Trim() : "",
Create_date = (dr["CREATE_DATE"] != null && dr["CREATE_DATE"].ToString() != "") ? DateTime.Parse(dr["CREATE_DATE"].ToString().Trim().Insert(4, "-").Insert(7, "-")) : DateTime.MinValue,
Create_time = (dr["CREATE_TIME"].ToString() != null) ? TimeSpan.Parse(dr["CREATE_TIME"].ToString().Trim()) : TimeSpan.MinValue,
OutputQty = (dr["SLNghiemThu"].ToString() != null) ? double.Parse(dr["SLNghiemThu"].ToString().Trim()) : 0,
DefectQty = (dr["SLBaophe"].ToString() != null) ? double.Parse(dr["SLBaophe"].ToString().Trim()) : 0
}).ToList();
}
catch (Exception)
{
return(null);
}
return(productionItems);
}
public List <ItemsInINVMC> GetItemsInINVMCs(string dept, string product)
{
List <ItemsInINVMC> finishedGoods = new List <ItemsInINVMC>();
try
{
StringBuilder stringBuilder = new StringBuilder();
stringBuilder.Append(@" select MC001,MC002,MC007 from INVMC where 1=1 ");
stringBuilder.Append("and MC001 ='" + product + "' ");
DataTable dt = new DataTable();
sqlERPCON sqlERPCON = new sqlERPCON();
sqlERPCON.sqlDataAdapterFillDatatable(stringBuilder.ToString(), ref dt);
for (int i = 0; i < dt.Rows.Count; i++)
{
if (double.Parse(dt.Rows[i]["MC007"].ToString()) > 0)
{
finishedGoods.Add(new ItemsInINVMC
{
Product = dt.Rows[i]["MC001"].ToString(),
Quantity = double.Parse(dt.Rows[i]["MC007"].ToString()),
Warehouse = dt.Rows[i]["MC002"].ToString()
});
}
}
}
catch (Exception ex)
{
return(null);
}
return(finishedGoods);
}
public bool UpdateMOCTC(DataTable dtExport)
{
for (int i = 0; i < dtExport.Rows.Count; i++)
{
string type = dtExport.Rows[i]["TE001"].ToString().Trim();
string No = dtExport.Rows[i]["TE002"].ToString().Trim();
string STT = dtExport.Rows[i]["TE003"].ToString().Trim();
StringBuilder stringMOCTE = new StringBuilder();
stringMOCTE.Append(" update MOCTE set TE019 ='Y' where 1=1 ");
stringMOCTE.Append(" and TE001 ='" + type + "' ");
stringMOCTE.Append(" and TE002 ='" + No + "' ");
stringMOCTE.Append(" and TE003 ='" + STT + "' ");
sqlERPCON sqlERPCON = new sqlERPCON();
var result = sqlERPCON.sqlExecuteNonQuery(stringMOCTE.ToString(), false);
}
StringBuilder stringMOCTC = new StringBuilder();
string typeC = dtExport.Rows[0]["TE001"].ToString().Trim();
string NoC = dtExport.Rows[0]["TE002"].ToString().Trim();
stringMOCTC.Append(" update MOCTC set TC009 = 'Y' where 1=1 ");
stringMOCTC.Append(" and TC001 ='" + typeC + "' ");
stringMOCTC.Append(" and TC002 ='" + NoC + "' ");
sqlERPCON sqlERPCON1 = new sqlERPCON();
var result2 = sqlERPCON1.sqlExecuteNonQuery(stringMOCTC.ToString(), false);
return(true);
}
// public List<string> ListHENNofProduct(string ProductNO)
// {
// try
// {
// StringBuilder stringBuilder = new StringBuilder();
// stringBuilder.Append(@" select distinct TE017 from MOCTA
// left join MOCTE on TA001 = TE011 and TA002 = TE012
// where (TE018 like '%HENN%' ) and TE019 ='Y'
//");
// stringBuilder.Append(" and TA034 = '"+ ProductNO+"' ");
// sqlERPCON sqlERPCON = new sqlERPCON();
// DataTable dt = new DataTable();
// sqlERPCON.sqlDataAdapterFillDatatable(stringBuilder.ToString(), ref dt);
// if (dt != null && dt.Rows.Count > 0)
// return dt.AsEnumerable()
// .Select(r => r.Field<string>("TE017"))
// .ToList();
// else return null;
// }
// catch (Exception ex)
// {
// SystemLog.Output(SystemLog.MSG_TYPE.Err, "List<string> ListHENNofProduct(string ProductNO)", ex.Message);
// return null;
// }
// }
public List <string> ListHENNofProduct(string ProductNO)
{
try
{
StringBuilder stringBuilder = new StringBuilder();
stringBuilder.Append(@" select distinct MD003 from BOMMD where 1=1
");
stringBuilder.Append(" and MD001 like '%" + ProductNO + "%' ");
stringBuilder.Append(" and (MD003 like '%BPJHC%' or ( MD003 like '%BPJ-%' and ISNUMERIC(SUBSTRING(MD003,5,1)) = '1' )) ");
stringBuilder.Append(" and MD012 = '" + "" + "'");
sqlERPCON sqlERPCON = new sqlERPCON();
DataTable dt = new DataTable();
sqlERPCON.sqlDataAdapterFillDatatable(stringBuilder.ToString(), ref dt);
if (dt != null && dt.Rows.Count > 0)
{
return(dt.AsEnumerable()
.Select(r => r.Field <string>("MD003"))
.ToList());
}
else
{
return(null);
}
}
catch (Exception ex)
{
SystemLog.Output(SystemLog.MSG_TYPE.Err, "List<string> ListHENNofProduct(string ProductNO)", ex.Message);
return(null);
}
}
public List <BOMItems> bOMItems(string NameProduct)
{
List <BOMItems> bOMItems = new List <BOMItems>();
try
{
DataTable dt = new DataTable();
StringBuilder sql = new StringBuilder();
sql.Append("select MD001,MD003,MD006,MD012 from BOMMD where 1=1 and MD003 like '%B-%' ");
sql.Append(" and MD001 = '" + NameProduct + "'");
sqlERPCON sqlCON = new sqlERPCON();
sqlCON.sqlDataAdapterFillDatatable(sql.ToString(), ref dt);
bOMItems = (from DataRow dr in dt.Rows
select new BOMItems()
{
finishedGoods = dr["MD001"].ToString().Trim(),
SemiFinishedgoods = dr["MD003"].ToString().Trim(),
Rate = (dr["MD006"].ToString() != "") ? double.Parse(dr["MD006"].ToString().Trim()) : 0,
Expired = (dr["MD012"].ToString() != "") ? DateTime.Parse(dr["MD012"].ToString().Trim().Insert(4, "-").Insert(7, "-")) : DateTime.MaxValue
}).ToList();
}
catch (Exception ex)
{
SystemLog.Output(SystemLog.MSG_TYPE.Err, "bOMItems (string NameProduct)", ex.Message);
}
return(bOMItems);
}
private void GetDataFromShipping()
{
//DateTime dtnow = DateTime.Now;
//DateTime datefrom = new DateTime(dtnow.Year, 1, 1);
//DateTime dateto = new DateTime(dtnow.Year, 12, 31);
dt = new DataTable();
StringBuilder sql = new StringBuilder();
sql.Append(@"select
TH014, TH015,TH004,
sum(a.TH008) as Delivery_Quantity,
max(b.TG003) as Delivery_Date,
TH016
from COPTH a
inner join COPTG b on a.TH001 = b.TG001 and a.TH002 = b.TG002
where TG023 ='Y' and TH014 !='' and TH015 != ''
");
// sql.Append(" and CONVERT(date,coptds.TD013) >= '" + datefrom + "' ");
// sql.Append(" and CONVERT(date,coptds.TD013) <= '" + dateto + "' ");
sql.Append(@"group by
TH014,
TH015,
TH004,
TH016
");
sql.Append("order by TH014, TH015, TH004");
sqlERPCON con = new sqlERPCON();
con.sqlDataAdapterFillDatatable(sql.ToString(), ref dt);
}
public List <SettingBOM> GetSettingBOMs()
{
List <SettingBOM> settingBOMs = new List <SettingBOM>();
try
{
StringBuilder stringBuilder = new StringBuilder();
stringBuilder.Append(@" select distinct ProductName, productNo
from (
select smes.ME002 as Dept,TD001, TD002, TD004 as ProductName,TD005 as productNo,
sum(TD008) as ClientRequestQty,sum(TD009) as DeliveryQty, TD013 as ClientRequestDate from COPTD ptd
inner join COPTC ptc on ptc.TC001 = ptd.TD001 and ptc.TC002 = ptd.TD002
left join CMSME smes on smes.ME001 = ptc.TC005
where ptc.TC027 ='Y' and TD001 like '%B%' and ( TD004 like '%BMH%' or TD004 like '%BWTX%')
group by TD001,TD002,TD005, TD013,smes.ME002,TD004
) DDH
");
sqlERPCON sqlERPCON = new sqlERPCON();
DataTable dt = new DataTable();
sqlERPCON.sqlDataAdapterFillDatatable(stringBuilder.ToString(), ref dt);
settingBOMs = (from DataRow dr in dt.Rows
select new SettingBOM()
{
ProductName = (dr["ProductName"] != null) ? dr["ProductName"].ToString().Trim() : "",
ProductNo = (dr["productNo"] != null) ? dr["productNo"].ToString().Trim() : "",
}).ToList();
}
catch (Exception)
{
return(null);
}
return(settingBOMs);
}
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;
}
}
}
public List <NVLTheoLSX> ListNVL(string code, string No)
{
List <NVLTheoLSX> _listNVL = new List <NVLTheoLSX>();
sqlERPCON query = new sqlERPCON();
StringBuilder strSQL = new StringBuilder();
DataTable dt = new DataTable();
strSQL.Append("select TB001,TB002, TB003,TB004,TB005,TB006 from MOCTB where TB006 ='****' and TB018 ='Y' and ");
strSQL.Append(" TB001 = '" + code + "' and ");
strSQL.Append(" TB002 = '" + No + "'");
query.sqlDataAdapterFillDatatable(strSQL.ToString(), ref dt);
//Load data into list
for (int i = 0; i < dt.Rows.Count; i++)
{
NVLTheoLSX nVL = new NVLTheoLSX();
nVL.code = dt.Rows[i]["TB001"].ToString();
nVL.No = dt.Rows[i]["TB002"].ToString();
nVL.NVL_TB003 = dt.Rows[i]["TB003"].ToString();
nVL.NVLCan_TB004 = dt.Rows[i]["TB004"].ToString() != "" ? double.Parse(dt.Rows[i]["TB004"].ToString()):0;
nVL.NVLLanh_TB005 = dt.Rows[i]["TB005"].ToString() != "" ? double.Parse(dt.Rows[i]["TB005"].ToString()) : 0;
nVL.NVLPercentLanh = (nVL.NVLCan_TB004 != 0) ? (nVL.NVLLanh_TB005 / nVL.NVLCan_TB004) :((nVL.NVLCan_TB004 == nVL.NVLLanh_TB005)?1:0);
nVL.CD_TB006 = dt.Rows[i]["TB006"].ToString();
_listNVL.Add(nVL);
}
return(_listNVL);
}
private void cmb_dept_SelectedIndexChanged(object sender, EventArgs e)
{
cmb_productioncode.Items.Clear();
sqlERPCON connproductioncode = new sqlERPCON();
connproductioncode.getComboBoxData("select distinct TC047 from SFCTC where TC004 like '" + cmb_dept.Text + "%'order by TC047", ref cmb_productioncode);
}
private void CheckMaterial_Load(object sender, EventArgs e)
{
string sql = "select distinct LF005 from INVLF";
sqlERPCON sqlcon = new sqlERPCON();
sqlcon.getComboBoxData(sql.ToString(), ref cmb_warehousecode);
}
void nation()
{
cmb_nation.Items.Clear();
string sql = "select distinct MR004 from CMSMR";
sqlERPCON sqlcon = new sqlERPCON();
sqlcon.getComboBoxData(sql.ToString(), ref cmb_nation);
}
private void cmd_MOCTA_TA001_SelectedIndexChanged(object sender, EventArgs e)
{
cmb_MOCTA_TA002.Items.Clear();
string sql = "select distinct TA002 from MOCTA where TA001 ='" + cmb_MOCTA_TA001.Text + "' order by TA002";
sqlERPCON conERP = new sqlERPCON();
conERP.getComboBoxData(sql, ref cmb_MOCTA_TA002);
}
public List <Accessory> GetAccessories(string dept, string product)
{
List <Accessory> accessories = new List <Accessory>();
try
{
//DataTable dt = new DataTable();
//StringBuilder stringBuilder = new StringBuilder();
StringBuilder stringBuilder = new StringBuilder();
stringBuilder.Append(@" select MD003,MC002,MC007 from BOMMD
inner join INVMC on MD003 = MC001
where 1=1 and MD012 ='' and MC007 > '0'
");
stringBuilder.Append(" and MD001 like '%" + product + "%' ");
if (dept == "B01-MH" || dept == "B01-FF")
{
if (product.Contains("BMH") || product.Contains("BWT") || product.Contains("FF"))
{
stringBuilder.Append(" and (MD003 like '%BPJHC%' or ( MD003 like '%BPJ-%' and ISNUMERIC(SUBSTRING(MD003,5,1)) = '1' )) ");
stringBuilder.Append(" and ( MC002 = 'Y22' or MC002 = 'Y12' ) ");
}
}
else if (dept == "A01-Gia Dung")
{
stringBuilder.Append(" and (MD003 like 'ABL%' or MD003 like 'AWJ%' ) ");
stringBuilder.Append(" and (MC002 = 'A07' or MC002 ='A01' or MC002 = 'W01' or MC002 = '002') ");
}
else if (dept == "A01-PTC")
{
stringBuilder.Append(" and (MD003 like 'ABL%' or MD003 like 'AWJ%' ) ");
stringBuilder.Append(" and (MC002 = 'A07' or MC002 ='A01' or MC002 = 'W01' or MC002 = '002') ");
}
else if (dept == "A01-JM")
{
stringBuilder.Append(" and (MD003 like 'ABL%' or MD003 like 'AWJ%' ) ");
stringBuilder.Append(" and (MC002 = 'A07' or MC002 ='A01' or MC002 = 'W01' or MC002 = '002') ");
}
sqlERPCON sqlERPCON = new sqlERPCON();
DataTable dt = new DataTable();
sqlERPCON.sqlDataAdapterFillDatatable(stringBuilder.ToString(), ref dt);
for (int i = 0; i < dt.Rows.Count; i++)
{
Accessory accessory = new Accessory();
accessory.Item = dt.Rows[i]["MD003"].ToString();
accessory.Warehouse = dt.Rows[i]["MC002"].ToString();
accessory.QtyInWarehouse = double.Parse(dt.Rows[i]["MC007"].ToString().Trim());
accessories.Add(accessory);
}
}
catch (Exception ex)
{
SystemLog.Output(SystemLog.MSG_TYPE.Err, " List<Accessory> GetAccessories: " + product, ex.Message);
}
return(accessories);
}
private void GenerateQRCode_Load(object sender, EventArgs e)
{
string sqlQuery = "select distinct TD005 from INVTD where 1=1 and CONVERT(date,TD002) >= '" + new DateTime(2019, 12, 18).ToString("yyyyMMdd") + "'";
sqlERPCON sqlERPCON = new sqlERPCON();
sqlERPCON.getComboBoxData(sqlQuery, ref cbm_warehouse);
if (cbm_warehouse.Items.Count > 0)
{
cbm_warehouse.SelectedIndex = 0;
}
}
