public List <DeptCodeName> deptCodeNames(ref ComboBox comboBox) { comboBox.Items.Clear(); List <DeptCodeName> deptCodes = new List <DeptCodeName>(); StringBuilder sql = new StringBuilder(); sql.Append("select MD001,MD002 "); sql.Append("from dbo.ERP_CMSMD "); sql.Append("where 1=1 "); sqlSFT sqlSFT = new sqlSFT(); DataTable dt = new DataTable(); sqlSFT.sqlDataAdapterFillDatatable(sql.ToString(), ref dt); deptCodes = (from DataRow dr in dt.Rows select new DeptCodeName() { DeptCode = dr["MD001"].ToString(), DeptName = "[" + dr["MD001"].ToString() + "] - " + dr["MD002"].ToString() }).ToList(); foreach (var item in deptCodes) { comboBox.Items.Add(item.DeptName); } return(deptCodes); }
public bool CheckExstinctRow(string producCode, string Status, string ERP_OPSEQ) { try { StringBuilder stringBuilder = new StringBuilder(); stringBuilder.Append(" select * from LOT "); stringBuilder.Append(" where 1=1 "); stringBuilder.Append(" and ID = '" + producCode + "' "); stringBuilder.Append(" and STATUS = '" + Status + "' "); stringBuilder.Append(" and ERP_OPSEQ ='" + ERP_OPSEQ + "' "); sqlSFT sqlSFT = new sqlSFT(); DataTable dt = new DataTable(); sqlSFT.sqlDataAdapterFillDatatable(stringBuilder.ToString(), ref dt); if (dt.Rows.Count > 0) { return(true); } else { return(false); } } catch (Exception ex) { SystemLog.Output(SystemLog.MSG_TYPE.Err, "CheckExtinctRow(string Table, string ID, string ID2)", ex.Message); return(false); } }
public bool CheckExstinctRow(string ID, string ERP_OPSEQ, string ERP_OPID, string ERP_WSID) { try { StringBuilder stringBuilder = new StringBuilder(); stringBuilder.Append(" select * from SFT_OP_REALRUN "); stringBuilder.Append(" where 1=1 "); stringBuilder.Append(" and ID ='" + ID + "' "); stringBuilder.Append(" and ERP_OPSEQ ='" + ERP_OPSEQ + "' "); stringBuilder.Append(" and ERP_OPID ='" + ERP_OPID + "' "); stringBuilder.Append(" and ERP_WSID ='" + ERP_WSID + "' "); stringBuilder.Append(" and REPORTSTOCKIN ='" + 1 + "' "); sqlSFT sqlSFT = new sqlSFT(); DataTable dt = new DataTable(); sqlSFT.sqlDataAdapterFillDatatable(stringBuilder.ToString(), ref dt); if (dt.Rows.Count > 0) { return(true); } else { return(false); } } catch (Exception ex) { SystemLog.Output(SystemLog.MSG_TYPE.Err, "CheckExtinctRow(string Table, string ID, string ID2)", ex.Message); return(false); } }
public DataTable GetTop1DataTable() { DataTable dt = new DataTable(); string querry = "select top(1) * from SFT_TRANSORDER "; sqlSFT sqlSFT = new sqlSFT(); sqlSFT.sqlDataAdapterFillDatatable(querry, ref dt); return(dt); }
public static DataTable GetDataTableLot(string ProductOrder) { DataTable dt = new DataTable(); StringBuilder stringBuilder = new StringBuilder(); stringBuilder.Append("select top(1) * from LOT where ID ='" + ProductOrder + "' "); sqlSFT sqlSFT = new sqlSFT(); sqlSFT.sqlDataAdapterFillDatatable(stringBuilder.ToString(), ref dt); return(dt); }
public DataTable GetDataTableFromLot() { DataTable dt = new DataTable(); StringBuilder stringBuilder = new StringBuilder(); stringBuilder.Append(" select top(1) * from LOT "); sqlSFT sqlSFT = new sqlSFT(); sqlSFT.sqlDataAdapterFillDatatable(stringBuilder.ToString(), ref dt); return(dt); }
public static DataTable GetDataTableSFT_OP_REALRUN() { DataTable dt = new DataTable(); StringBuilder stringBuilder = new StringBuilder(); stringBuilder.Append("select top(1) * from SFT_OP_REALRUN "); sqlSFT sqlSFT = new sqlSFT(); sqlSFT.sqlDataAdapterFillDatatable(stringBuilder.ToString(), ref dt); return(dt); }
public DataTable GetDataTableLOTMODETAIL(string productCode) { DataTable dt = new DataTable(); StringBuilder stringBuilder = new StringBuilder(); stringBuilder.Append(@"select * from LOT a left join MODETAIL b on CMOID = ID where 1 = 1 and ERP_OPSEQ = '0020' and a.STATUS = '130' and b.STATUS != '99' and b.STATUS != '100' "); stringBuilder.Append(" and a.ID= '" + productCode + "'"); sqlSFT sqlSFT = new sqlSFT(); sqlSFT.sqlDataAdapterFillDatatable(stringBuilder.ToString(), ref dt); return(dt); }
public static string getProductionOrder(string Product) { DataTable dt = new DataTable(); string productionOrder = ""; StringBuilder stringBuilder = new StringBuilder(); stringBuilder.Append(@" select ID from LOT where LOTSIZE > 0 and STATUS = 50 and ERP_OPSEQ ='0020' "); stringBuilder.Append(" and ITEMID like '%" + Product + "%' "); sqlSFT sqlSFT = new sqlSFT(); sqlSFT.sqlDataAdapterFillDatatable(stringBuilder.ToString(), ref dt); if (dt.Rows.Count > 0) { productionOrder = dt.Rows[0]["ID"].ToString(); } return(productionOrder); }
public List <PendingWarehouseItems> GetFinishedGoodsItems(string product) { List <PendingWarehouseItems> pendingWarehouseItems = new List <PendingWarehouseItems>(); try { StringBuilder stringBuilder = new StringBuilder(); stringBuilder.Append(@" select a.ID, a.ITEMID,LOTSIZE, a.UNIT,a.PKQTYPER, a.ERP_WSID,a.ERP_OPID from LOT a left join MODETAIL b on CMOID = ID where 1 = 1 and ERP_OPSEQ = '0020' and a.STATUS = '130' and b.STATUS != '99' and b.STATUS != '100' "); stringBuilder.Append(" and a.ITEMID LIKE '%" + product + "%' "); DataTable dt = new DataTable(); sqlSFT sqlTLVN2 = new sqlSFT(); sqlTLVN2.sqlDataAdapterFillDatatable(stringBuilder.ToString(), ref dt); for (int i = 0; i < dt.Rows.Count; i++) { pendingWarehouseItems.Add(new PendingWarehouseItems { ProductCode = dt.Rows[i]["ID"].ToString(), product = dt.Rows[i]["ITEMID"].ToString(), TotalQty = dt.Rows[i]["LOTSIZE"].ToString() != "" ? double.Parse(dt.Rows[i]["LOTSIZE"].ToString()) : 0, DefectQty = 0, Unit = dt.Rows[i]["UNIT"].ToString(), DateExport = DateTime.Now, PKQTYPER = double.Parse(dt.Rows[i]["PKQTYPER"].ToString()), OUTDEPID = dt.Rows[i]["ERP_WSID"].ToString(), OUTTYPE = dt.Rows[i]["ERP_OPID"].ToString() }); } } catch (Exception ex) { SystemLog.Output(SystemLog.MSG_TYPE.Err, "GetFinishedGoodsItems(string product)", ex.Message); } return(pendingWarehouseItems); }
public List <DeptCodeName> deptCodeNames() { List <DeptCodeName> deptCodes = new List <DeptCodeName>(); StringBuilder sql = new StringBuilder(); sql.Append("select MD001,MD002 "); sql.Append("from dbo.ERP_CMSMD "); sql.Append("where 1=1 "); sqlSFT sqlSFT = new sqlSFT(); DataTable dt = new DataTable(); sqlSFT.sqlDataAdapterFillDatatable(sql.ToString(), ref dt); deptCodes = (from DataRow dr in dt.Rows select new DeptCodeName() { DeptCode = dr["MD001"].ToString(), DeptName = "[" + dr["MD001"].ToString() + "] - " + dr["MD002"].ToString() }).ToList(); return(deptCodes); }