public bool UpdateMODETAIL(DataTable dtTRansOrderLine) { try { for (int i = 0; i < dtTRansOrderLine.Rows.Count; i++) { string PO = dtTRansOrderLine.Rows[i]["KEYID"].ToString(); DataTable dtLot = Database.SFT.SFT_LOT.GetDataTableLot(PO); StringBuilder stringBuilder = new StringBuilder(); stringBuilder.Append(" update MODETAIL "); stringBuilder.Append(" set LASTMAINTAINDATETIME = GETDATE() , "); stringBuilder.Append(" MO009 = MO009 +" + dtTRansOrderLine.Rows[i]["TRANSQTY"] + ", "); stringBuilder.Append(" MO033 = '" + DateTime.Now.ToString("yyyyMMdd") + "' , "); stringBuilder.Append(" MO027 = MO027 + " + double.Parse(dtTRansOrderLine.Rows[i]["TRANSQTY"].ToString()) * double.Parse(dtLot.Rows[0]["PKQTYPER"].ToString()) + " "); stringBuilder.Append("where CMOID ='" + dtTRansOrderLine.Rows[i]["KEYID"] + "' "); sqlSFT sqlSFT = new sqlSFT(); var result = sqlSFT.sqlExecuteNonQuery(stringBuilder.ToString(), false); if (result == false) { return(false); } } return(true); } catch (Exception ex) { SystemLog.Output(SystemLog.MSG_TYPE.Err, "UpdateMODETAIL(FinishedGoodsItems fgItems)", ex.Message); } return(false); }
public void DeleteRowIntoWarehouseEmptyStock(string ID, string status) { StringBuilder builder = new StringBuilder(); builder.Append("select DEFECTQTY from SFT_OP_REALRUN where SEQUENCE = 0 and OPID = 'B02---B01' "); builder.Append(" and ID = '" + ID + "' "); sqlSFT sFT = new sqlSFT(); var QtyDefect = sFT.sqlExecuteScalarString(builder.ToString()); if (double.Parse(QtyDefect) == 0) // Neu con defect thi khong duoc xoa Lot pending warehouse { StringBuilder stringBuilder = new StringBuilder(); stringBuilder.Append(" delete from LOT where 1=1 "); stringBuilder.Append(" and ID = '" + ID + "' "); stringBuilder.Append(" and STATUS = '" + status + "' "); stringBuilder.Append(" and LOTSIZE = '0' "); var result = sFT.sqlExecuteNonQuery(stringBuilder.ToString(), false); } }
public bool UpdateLotforFinishedGood(DataRow dtTRansOrderLine, string Status, string ERP_OPSEQ) { try { string PO = dtTRansOrderLine["KEYID"].ToString().Trim(); DataTable dtLot = Database.SFT.SFT_LOT.GetDataTableLot(PO); StringBuilder stringBuilder = new StringBuilder(); stringBuilder.Append("update LOT set"); if (Status == "99") { stringBuilder.Append(" LOTSIZE =LOTSIZE + " + dtTRansOrderLine["TRANSQTY"] + ", "); stringBuilder.Append(" PKQTY = PKQTY + " + double.Parse(dtTRansOrderLine["TRANSQTY"].ToString()) * double.Parse(dtLot.Rows[0]["PKQTYPER"].ToString()) + " "); stringBuilder.Append(" where ID ='" + dtTRansOrderLine["KEYID"] + "' and STATUS =99"); //stringBuilder.Append(" and ERP_OPSEQ ='" + ERP_OPSEQ + "' "); } else if (Status == "130") { stringBuilder.Append(" LOTSIZE =LOTSIZE - " + dtTRansOrderLine["TRANSQTY"] + ", "); stringBuilder.Append(" PKQTY = PKQTY - " + double.Parse(dtTRansOrderLine["TRANSQTY"].ToString()) * double.Parse(dtLot.Rows[0]["PKQTYPER"].ToString()) + " "); stringBuilder.Append(" where ID ='" + dtTRansOrderLine["KEYID"] + "' and STATUS =130"); stringBuilder.Append(" and ERP_OPSEQ ='" + ERP_OPSEQ + "' "); } sqlSFT sqlSFT = new sqlSFT(); var result = sqlSFT.sqlExecuteNonQuery(stringBuilder.ToString(), false); if (result == false) { return(false); } return(true); } catch (Exception ex) { SystemLog.Output(SystemLog.MSG_TYPE.Err, "UpdateLotforFinishedGood(FinishedGoodsItems fgItems, string Status)", ex.Message); } return(false); }
public bool UpdateOPREALRUN(string ID, string ERP_OPSEQ, string ERP_OPID, string ERP_WSID, DataRow dtERPPQC) { try { string PO = dtERPPQC["ProductOrder"].ToString(); DataTable dtLot = Database.SFT.SFT_LOT.GetDataTableLot(PO); StringBuilder stringBuilder = new StringBuilder(); stringBuilder.Append("update SFT_OP_REALRUN set "); stringBuilder.Append(" OUTQTY = OUTQTY +" + dtERPPQC["Quantity"] + ", "); stringBuilder.Append(" PKQTY = PKQTY +" + double.Parse(dtERPPQC["Quantity"].ToString()) * double.Parse(dtLot.Rows[0]["PKQTYPER"].ToString()) + ", "); stringBuilder.Append(" OR023 = OR023 -" + double.Parse(dtERPPQC["Quantity"].ToString()) * double.Parse(dtLot.Rows[0]["PKQTYPER"].ToString()) + ", "); stringBuilder.Append(" OUTTIME = '" + DateTime.Now.ToString("yyyyMMdd HH:mm:ss") + "' "); stringBuilder.Append(" where 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 SEQUENCE ='" + 0 + "' "); sqlSFT sqlSFT = new sqlSFT(); var update = sqlSFT.sqlExecuteNonQuery(stringBuilder.ToString(), false); if (update == false) { SystemLog.Output(SystemLog.MSG_TYPE.Err, "UpdateOPREALRUN", "False"); return(false); } else { return(true); } } catch (Exception ex) { SystemLog.Output(SystemLog.MSG_TYPE.Err, "UpdateOPREALRUN", ex.Message); } return(false); }
public bool InsertData(DataTable dtdata) { try { StringBuilder stringBuilder = new StringBuilder(); stringBuilder.Append(" insert into LOT ( "); for (int i = 0; i < dtdata.Columns.Count; i++) { if (i < dtdata.Columns.Count - 1) { stringBuilder.Append(dtdata.Columns[i].ColumnName + ","); } else { stringBuilder.Append(dtdata.Columns[i].ColumnName + ") values ( "); } } for (int i = 0; i < dtdata.Rows.Count; i++) { StringBuilder stringFun = new StringBuilder(); for (int j = 0; j < dtdata.Columns.Count; j++) { string valueCell = "NULL"; if (dtdata.Rows[i][dtdata.Columns[j].ColumnName] != null) { if (dtdata.Columns[j].DataType == typeof(DateTime)) { valueCell = "NULL"; } else if (dtdata.Rows[i][dtdata.Columns[j].ColumnName].GetType() == typeof(DBNull)) { valueCell = "NULL"; } else { valueCell = dtdata.Rows[i][dtdata.Columns[j].ColumnName].ToString(); } } if (j < dtdata.Columns.Count - 1) { if (valueCell == "NULL") { stringFun.Append(" " + valueCell + " ,"); } else { stringFun.Append(" '" + valueCell + "',"); } } else { if (valueCell == "NULL") { stringFun.Append(" " + valueCell + ")"); } else { stringFun.Append(" '" + valueCell + "')"); } } } string sqlInsert = stringBuilder.ToString() + stringFun.ToString(); sqlSFT sqlSFT = new sqlSFT(); var result = sqlSFT.sqlExecuteNonQuery(sqlInsert, false); if (result == false) { return(false); } } return(true); } catch (Exception ex) { SystemLog.Output(SystemLog.MSG_TYPE.Err, "SFT_TRANSORDER_LINE", ex.Message); } return(false); }
public bool InsertData(DataTable dtdata, out int[] sequence) { int[] sequencUpdate = new int[dtdata.Rows.Count]; try { StringBuilder stringBuilder = new StringBuilder(); stringBuilder.Append(" insert into SFT_WS_RUN ( "); for (int i = 0; i < dtdata.Columns.Count; i++) { if (i < dtdata.Columns.Count - 1) { stringBuilder.Append(dtdata.Columns[i].ColumnName + ","); } else { stringBuilder.Append(dtdata.Columns[i].ColumnName + ") values ( "); } } for (int i = 0; i < dtdata.Rows.Count; i++) { string ID = dtdata.Rows[i]["ID"].ToString(); int _SequenceUpdate = GgetSequenceCountupSFT_WS_RUN(ID); sequencUpdate[i] = _SequenceUpdate; dtdata.Rows[i]["SEQUENCE"] = _SequenceUpdate; StringBuilder stringFun = new StringBuilder(); for (int j = 0; j < dtdata.Columns.Count; j++) { string valueCell = "NULL"; if (dtdata.Rows[i][dtdata.Columns[j].ColumnName] != null) { if (dtdata.Columns[j].DataType == typeof(DateTime)) { if (dtdata.Columns[j].ColumnName == "MODI_DATE") { valueCell = "NULL"; } else { valueCell = DateTime.Now.ToString("yyyyMMdd HH:mm:ss"); } } else if (dtdata.Rows[i][dtdata.Columns[j].ColumnName].GetType() == typeof(DBNull)) { valueCell = "NULL"; } else { valueCell = dtdata.Rows[i][dtdata.Columns[j].ColumnName].ToString(); } } if (j < dtdata.Columns.Count - 1) { if (valueCell == "NULL") { stringFun.Append(" " + valueCell + " ,"); } else { stringFun.Append(" '" + valueCell + "',"); } } else { if (valueCell == "NULL") { stringFun.Append(" " + valueCell + ")"); } else { stringFun.Append(" '" + valueCell + "')"); } } } string sqlInsert = stringBuilder.ToString() + stringFun.ToString(); sqlSFT sqlSFT = new sqlSFT(); var result = sqlSFT.sqlExecuteNonQuery(sqlInsert, false); if (result == false) { sequence = sequencUpdate; return(false); } } sequence = sequencUpdate; return(true); } catch (Exception ex) { SystemLog.Output(SystemLog.MSG_TYPE.Err, "SFT_TRANSORDER_LINE", ex.Message); } sequence = sequencUpdate; return(false); }