public int APUpdateUndoSmtloading(string panel, OleExec DB) { string strSql = $@"update mes4.r_tr_product_detail set wo = '#' || substr(wo,2,11), p_sn = '#' || p_sn, tr_code = '#' || tr_code where p_sn in (select p_sn from mes4.r_sn_link where panel_no =:panel_no )"; OleDbParameter[] paramet = new OleDbParameter[] { new OleDbParameter(":panel_no", panel) }; int i = DB.ExecuteNonQuery(strSql, CommandType.Text, paramet); strSql = $@"update mes4.r_sn_link set p_sn = '#' || p_sn, wo = '#' || substr(wo,2,11), panel_no = '#' || panel_no where panel_no =:panel_no "; paramet = new OleDbParameter[] { new OleDbParameter(":panel_no", panel) }; i = DB.ExecuteNonQuery(strSql, CommandType.Text, paramet); return(i); }
public int Delete(string ID, OleExec DB) { try { if (!string.IsNullOrEmpty(ID.Trim())) { string sql = $@"DELETE FROM C_FACTORY WHERE ID='{ID.Trim()}'"; int result = DB.ExecuteNonQuery(sql, CommandType.Text); if (result > 0) { return(0); //delete success } else { return(1); // delete fail } } else { return(2); //delete fail id is empty } } catch (Exception e) { return(3); //exception throw e; } }
public int Add(R_BACKFLUSH_HISTORY NewHis, OleExec sfcdb) { Row_R_BACKFLUSH_HISTORY NewHisRow = (Row_R_BACKFLUSH_HISTORY)NewRow(); NewHisRow.WORKORDERNO = NewHis.WORKORDERNO; NewHisRow.SKUNO = NewHis.SKUNO; NewHisRow.SAP_STATION = NewHis.SAP_STATION; NewHisRow.WORKORDER_QTY = NewHis.WORKORDER_QTY; NewHisRow.BACKFLUSH_QTY = NewHis.BACKFLUSH_QTY; NewHisRow.SFC_QTY = NewHis.SFC_QTY; NewHisRow.DIFF_QTY = NewHis.DIFF_QTY; NewHisRow.SFC_STATION = NewHis.SFC_STATION; NewHisRow.HAND_QTY = NewHis.HAND_QTY; NewHisRow.LAST_SFC_QTY = NewHis.LAST_SFC_QTY; NewHisRow.DIFF_QTY1 = NewHis.DIFF_QTY1; NewHisRow.DIFF_QTY2 = NewHis.DIFF_QTY2; NewHisRow.HISTORY_HAND_QTY = NewHis.HISTORY_HAND_QTY; NewHisRow.MRB_QTY = NewHis.MRB_QTY; NewHisRow.REC_TYPE = NewHis.REC_TYPE; NewHisRow.BACK_DATE = NewHis.BACK_DATE; NewHisRow.RESULT = NewHis.RESULT; NewHisRow.TIMES = NewHis.TIMES; NewHisRow.TOSAP = NewHis.TOSAP; int result = sfcdb.ExecuteNonQuery(NewHisRow.GetInsertString(DBType), CommandType.Text); return(result); }
public int Add(R_MRB newMrb, OleExec DB) { string strSql = $@"insert into r_mrb( id,sn,workorderno,next_station,skuno,from_storage,to_storage,rework_wo,create_emp,create_time,mrb_flag,sap_flag,edit_emp,edit_time)"; strSql = strSql + $@"values(:id,:sn,:workorderno,:next_station,:skuno,:from_storage,:to_storage,:rework_wo,:create_emp,:create_time,:mrb_flag,:sap_flag,:edit_emp,:edit_time)"; OleDbParameter[] paramet = new OleDbParameter[] { new OleDbParameter(":id", newMrb.ID), new OleDbParameter(":sn", newMrb.SN), new OleDbParameter(":workorderno", newMrb.WORKORDERNO), new OleDbParameter(":next_station", newMrb.NEXT_STATION), new OleDbParameter(":skuno", newMrb.SKUNO), new OleDbParameter(":from_storage", newMrb.FROM_STORAGE), new OleDbParameter(":to_storage", newMrb.TO_STORAGE), new OleDbParameter(":rework_wo", newMrb.REWORK_WO), new OleDbParameter(":create_emp", newMrb.CREATE_EMP), new OleDbParameter(":create_time", newMrb.CREATE_TIME), new OleDbParameter(":mrb_flag", newMrb.MRB_FLAG), new OleDbParameter(":sap_flag", newMrb.SAP_FLAG), new OleDbParameter(":edit_emp", newMrb.EDIT_EMP), new OleDbParameter(":edit_time", newMrb.EDIT_TIME) }; int result = DB.ExecuteNonQuery(strSql, CommandType.Text, paramet); return(result); }
public int RetrunUpdateKPSNBySnId(string snId, string stationName, string user, OleExec DB) { string sql = $@" update r_sn_kp set VALUE ='',edit_time=sysdate,edit_emp='{user}' where r_sn_id='{snId}' and station ='{stationName}'"; int res = DB.ExecuteNonQuery(sql, CommandType.Text, null); return(res); }
public int DeleteBySNID(string snID, OleExec sfcdb) { string sql = $@" delete r_sn_kp where r_sn_id='{snID}' "; int res = sfcdb.ExecuteNonQuery(sql, CommandType.Text, null); return(res); }
public int DeleteById(string id, OleExec DB) { string strSql = $@"delete c_storage_item where id=:id"; OleDbParameter[] paramet = new OleDbParameter[] { new OleDbParameter(":id", id) }; int result = DB.ExecuteNonQuery(strSql, CommandType.Text, paramet); return(result); }
public int DeleteById(string Id, OleExec DB) { string strSql = $@"delete c_action_code where id=:Id"; OleDbParameter[] paramet = new OleDbParameter[] { new OleDbParameter(":Id", Id) }; int result = DB.ExecuteNonQuery(strSql, CommandType.Text, paramet); return(result); }
public int UpDate(string ID, decimal SEQ_NO, string NAME, string VALUE, OleExec DB) { string sql = $@" UPDATE C_BU_EX SET NAME='{NAME}' ,VALUE='{VALUE}' WHERE ID='{ID}' AND SEQ_NO={SEQ_NO}"; OleDbParameter[] parameters = null; int result = DB.ExecuteNonQuery(sql, CommandType.Text, parameters); return(result); }
public int DeleteBuExByID_SEQ_NO(string ID, decimal SEQ_NO, OleExec DB) { string sql = $@"DELETE FROM C_BU_EX WHERE ID=:ID AND SEQ_NO=:SEQ_NO"; OleDbParameter[] parameters = new OleDbParameter[] { new OleDbParameter("ID", ID), new OleDbParameter("SEQ_NO", SEQ_NO) }; int result = DB.ExecuteNonQuery(sql, CommandType.Text, parameters); return(result); }
public int UpdateFINISHEDQTYAddOne(string r_wo, OleExec DB) { string strSql = $@"update r_wo_base set finished_qty=case when (finished_qty is null) then 1 else (finished_qty+1) end where workorderno=:wono"; OleDbParameter[] paramet = new OleDbParameter[] { new OleDbParameter(":wono", r_wo) }; int result = DB.ExecuteNonQuery(strSql, CommandType.Text, paramet); return(result); }
public int DeleteByReturn_Route_DetailId(string returnid, OleExec DB) { string strSql = $@"delete c_route_detail_return where return_route_detail_id=:return_route_detail_id"; OleDbParameter[] paramet = new OleDbParameter[1]; paramet[0] = new OleDbParameter(":return_route_detail_id", returnid); int result = DB.ExecuteNonQuery(strSql, CommandType.Text, paramet); return(result); }
public int DeleteByDetailId(string detailId, OleExec DB) { string strSql = $@"delete c_route_detail_directlink where c_route_detail_id=:c_route_detail_id"; OleDbParameter[] paramet = new OleDbParameter[1]; paramet[0] = new OleDbParameter(":c_route_detail_id", detailId); int res = DB.ExecuteNonQuery(strSql, CommandType.Text, paramet); return(res); }
/// <summary> /// 通過ID刪除 /// </summary> /// <param name="id"></param> /// <param name="DB"></param> /// <returns></returns> public int DeleteById(string id, OleExec DB) { string strSql = $@"delete c_route_detail where id=:id"; OleDbParameter[] paramet = new OleDbParameter[1]; paramet[0] = new OleDbParameter(":id", id); int result = DB.ExecuteNonQuery(strSql, CommandType.Text, paramet); return(result); }
public int deleteById(string id, OleExec DB) { string sql = "delete c_line where id=:id"; int result = 0; OleDbParameter[] paramet = new OleDbParameter[] { new OleDbParameter(":id", id) }; result = DB.ExecuteNonQuery(sql, CommandType.Text, paramet); return(result); }
public int updateTotalQTYAddOne(string strWo, string user_emp, OleExec DB) { string strSql = $@" update r_mrb_gt set total_QTY=case when (total_QTY is null) then 1 else (total_QTY+1) end,EDIT_EMP=:userno,EDIT_TIME=sysdate where workorderno=:wono and SAP_FLAG='0'"; OleDbParameter[] paramet = new OleDbParameter[2]; paramet[0] = new OleDbParameter(":userno", user_emp); paramet[1] = new OleDbParameter(":wono", strWo); int result = DB.ExecuteNonQuery(strSql, CommandType.Text, paramet); return(result); }
public int Add(C_ROUTE_DETAIL_DIRECTLINK newdirectlink, OleExec DB) { string strSql = $@"insert into c_route_detail_directlink(id,c_route_detail_id,directlink_route_detail_id)"; strSql = strSql + $@"values(:id,:c_route_detail_id,:directlink_route_detail_id)"; OleDbParameter[] paramet = new OleDbParameter[3]; paramet[0] = new OleDbParameter(":id", newdirectlink.ID); paramet[1] = new OleDbParameter(":c_route_detail_id", newdirectlink.C_ROUTE_DETAIL_ID); paramet[2] = new OleDbParameter(":directlink_route_detail_id", newdirectlink.DIRECTLINK_ROUTE_DETAIL_ID); int res = DB.ExecuteNonQuery(strSql, CommandType.Text, paramet); return(res); }
public int Add(C_ROUTE_DETAIL_RETURN newdetailreturn, OleExec DB) { string strSql = $@"insert into c_route_detail_return(id,route_detail_id,return_route_detail_id)"; strSql = strSql + $@" values(:id,:route_detail_id,:return_route_detail_id)"; OleDbParameter[] paramet = new OleDbParameter[3]; paramet[0] = new OleDbParameter(":id", newdetailreturn.ID); paramet[1] = new OleDbParameter(":route_detail_id", newdetailreturn.ROUTE_DETAIL_ID); paramet[2] = new OleDbParameter(":return_route_detail_id", newdetailreturn.RETURN_ROUTE_DETAIL_ID); int result = DB.ExecuteNonQuery(strSql, CommandType.Text, paramet); return(result); }
public int OutMrbUpdate(string reworkno, string userEmp, string snno, OleExec DB) { string strSql = $@"update r_mrb set rework_wo=:rework_wo,mrb_flag='1',edit_emp=:edit_emp,edit_time=sysdate where sn=:sn and mrb_flag='0' and rework_wo is null"; OleDbParameter[] paramet = new OleDbParameter[] { new OleDbParameter(":rework_wo", reworkno), new OleDbParameter(":edit_emp", userEmp), new OleDbParameter(":sn", snno) }; int result = DB.ExecuteNonQuery(strSql, CommandType.Text, paramet); return(result); }
/// <summary> /// 通過ID更新 /// </summary> /// <param name="updateitem"></param> /// <param name="DB"></param> /// <returns></returns> public int UpdateById(C_ROUTE_DETAIL updateitem, OleExec DB) { string strSql = $@"update c_route_detail set seq_no=:seq_no,station_name=:station_name,station_type=:station_type,return_flag=:return_flag where id=:id"; OleDbParameter[] paramet = new OleDbParameter[5]; paramet[0] = new OleDbParameter(":seq_no", updateitem.SEQ_NO); paramet[1] = new OleDbParameter(":station_name", updateitem.STATION_NAME); paramet[2] = new OleDbParameter(":station_type", updateitem.STATION_TYPE); paramet[3] = new OleDbParameter(":return_flag", updateitem.RETURN_FLAG); paramet[4] = new OleDbParameter(":id", updateitem.ID); int result = DB.ExecuteNonQuery(strSql, CommandType.Text, paramet); return(result); }
public int UpdateById(C_ACTION_CODE NewActionCode, OleExec DB) { Row_C_ACTION_CODE NewActionCodeRow = (Row_C_ACTION_CODE)NewRow(); NewActionCodeRow.ID = NewActionCode.ID; NewActionCodeRow.ACTION_CODE = NewActionCode.ACTION_CODE; NewActionCodeRow.ENGLISH_DESCRIPTION = NewActionCode.ENGLISH_DESCRIPTION; NewActionCodeRow.CHINESE_DESCRIPTION = NewActionCode.CHINESE_DESCRIPTION; NewActionCodeRow.EDIT_EMP = NewActionCode.EDIT_EMP; NewActionCodeRow.EDIT_TIME = NewActionCode.EDIT_TIME; int result = DB.ExecuteNonQuery(NewActionCodeRow.GetUpdateString(DBType, NewActionCode.ID), CommandType.Text); return(result); }
public int Add(C_STORAGE_ITEM NewStorageItem, OleExec DB) { Row_C_STORAGE_ITEM NewStorageItemRow = (Row_C_STORAGE_ITEM)NewRow(); NewStorageItemRow.ID = NewStorageItem.ID; NewStorageItemRow.ITEM_NAME = NewStorageItem.ITEM_NAME; NewStorageItemRow.ITEM_SON = NewStorageItem.ITEM_SON; NewStorageItemRow.STORAGE_CODE = NewStorageItem.STORAGE_CODE; NewStorageItemRow.EDIT_EMP = NewStorageItem.EDIT_EMP; NewStorageItemRow.EDIT_TIME = NewStorageItem.EDIT_TIME; int result = DB.ExecuteNonQuery(NewStorageItemRow.GetInsertString(DBType), CommandType.Text); return(result); }
public int UpdateById(C_STORAGE_CODE NewStorageCode, OleExec DB) { Row_C_STORAGE_CODE NewStorageRow = (Row_C_STORAGE_CODE)NewRow(); NewStorageRow.ID = NewStorageCode.ID; NewStorageRow.PLANT = NewStorageCode.PLANT; NewStorageRow.STORAGE_CODE = NewStorageCode.STORAGE_CODE; NewStorageRow.DESCRIPTION = NewStorageCode.DESCRIPTION; NewStorageRow.EDIT_EMP = NewStorageCode.EDIT_EMP; NewStorageRow.EDIT_TIME = NewStorageCode.EDIT_TIME; int result = DB.ExecuteNonQuery(NewStorageRow.GetUpdateString(DBType, NewStorageCode.ID), CommandType.Text); return(result); }
public int AddNewErrorCode(C_ERROR_CODE NewErrorCode, OleExec DB) { Row_C_ERROR_CODE NewErrorCodeRow = (Row_C_ERROR_CODE)NewRow(); NewErrorCodeRow.ID = NewErrorCode.ID; NewErrorCodeRow.ERROR_CODE = NewErrorCode.ERROR_CODE; NewErrorCodeRow.ENGLISH_DESCRIPTION = NewErrorCode.ENGLISH_DESCRIPTION; NewErrorCodeRow.CHINESE_DESCRIPTION = NewErrorCode.CHINESE_DESCRIPTION; NewErrorCodeRow.EDIT_EMP = NewErrorCode.EDIT_EMP; NewErrorCodeRow.EDIT_TIME = NewErrorCode.EDIT_TIME; int result = DB.ExecuteNonQuery(NewErrorCodeRow.GetInsertString(DBType), CommandType.Text); return(result); }
public void DeleteById(JObject requestValue, JToken Data, MESStationReturn StationReturn) { string id = Data["ID"].ToString(); if (string.IsNullOrEmpty(id)) { StationReturn.Status = StationReturnStatusValue.Fail; StationReturn.MessageCode = "MES00000006"; StationReturn.MessagePara = new List <Object>() { "Reason Code ID" }; StationReturn.Data = null; return; } OleExec sfcdb = DBPools["SFCDB"].Borrow(); string[] ids = id.Split(','); Row_C_REASON_CODE row_reason_code = (Row_C_REASON_CODE) new T_C_REASON_CODE(sfcdb, DB_TYPE_ENUM.Oracle).NewRow(); try { string deleteString = null; sfcdb.BeginTrain(); foreach (string deleteID in ids) { deleteString = row_reason_code.GetDeleteString(DB_TYPE_ENUM.Oracle, deleteID); sfcdb.ExecuteNonQuery(deleteString, CommandType.Text, null); } sfcdb.CommitTrain(); } catch (Exception ex) { sfcdb.RollbackTrain(); if (sfcdb != null) { this.DBPools["SFCDB"].Return(sfcdb); } throw ex; } StationReturn.Status = StationReturnStatusValue.Pass; StationReturn.MessageCode = "MES00000004"; StationReturn.Data = ""; if (sfcdb != null) { this.DBPools["SFCDB"].Return(sfcdb); } }
/// <summary> /// 通過ID更新路由 /// </summary> /// <param name="newRoute"></param> /// <param name="DB"></param> /// <returns>成功返回大於零的數,失敗返回0</returns> public int UpdateById(C_ROUTE newRoute, OleExec DB) { string strSql = $@"update c_route set route_name=:route_name ,default_skuno=:default_skuno ,route_type=:route_type ,edit_time=:edit_time ,edit_emp=:edit_emp where id=:id"; OleDbParameter[] paramet = new OleDbParameter[6]; paramet[0] = new OleDbParameter(":route_name", newRoute.ROUTE_NAME); paramet[1] = new OleDbParameter(":default_skuno", newRoute.DEFAULT_SKUNO); paramet[2] = new OleDbParameter(":route_type", newRoute.ROUTE_TYPE); paramet[3] = new OleDbParameter(":edit_time", newRoute.EDIT_TIME); paramet[4] = new OleDbParameter(":edit_emp", newRoute.EDIT_EMP); paramet[5] = new OleDbParameter(":id", newRoute.ID); int result = DB.ExecuteNonQuery(strSql, CommandType.Text, paramet); return(result); }
public int Insert(string FACTORY_CODE, string FACTORY_NAME, string FACTORY_ADDRESS, string DESCRIPTION, string EDIT_EMP, string BU, DB_TYPE_ENUM dbt, OleExec DB) { OleDbParameter[] param = null; string sql; int result; string ID; T_C_FACTORY factory = null; DataTable table; try { sql = $@"SELECT * FROM C_FACTORY WHERE UPPER(FACTORY_CODE)='{FACTORY_CODE}' AND UPPER(FACTORY_NAME)='{FACTORY_NAME}' AND UPPER(FACTORY_ADDRESS)='{FACTORY_ADDRESS}'"; table = DB.ExecSelect(sql).Tables[0]; if (table.Rows.Count > 0) { // factorycode+factoryname+factoryaddress existed fail primary key return(0); } factory = new T_C_FACTORY(DB, dbt); ID = factory.GetNewID(BU, DB, dbt); param = new OleDbParameter[] { new OleDbParameter("ID", ID), new OleDbParameter("FACTORY_CODE", FACTORY_CODE.ToUpper()), new OleDbParameter("FACTORY_NAME", FACTORY_NAME.ToUpper()), new OleDbParameter("FACTORY_ADDRESS", FACTORY_ADDRESS.ToUpper()), new OleDbParameter("DESCRIPTION", DESCRIPTION), new OleDbParameter("EDIT_EMP", EDIT_EMP) }; sql = "INSERT INTO C_FACTORY VALUES(:ID,:FACTORY_CODE,:FACTORY_NAME,:FACTORY_ADDRESS,:DESCRIPTION, SYSDATE,:EDIT_EMP)"; result = DB.ExecuteNonQuery(sql, CommandType.Text, param); if (result > 0) { return(1); //Insert success } else { return(2); //Insert fail } } catch (Exception e) { return(3); //exception throw e; } }
public int Update(string ID, string FACTORY_CODE, string FACTORY_NAME, string FACTORY_ADDRESS, string DESCRIPTION, string EDIT_EMP, OleExec DB) { OleDbParameter[] param = null; int result; string sql; DataTable table; try { sql = $@"SELECT * FROM C_FACTORY WHERE ID='{ID}'"; table = DB.ExecSelect(sql).Tables[0]; // check id exist ? if (table.Rows.Count <= 0) { return(0); // id not exist } sql = $@"SELECT * FROM C_FACTORY WHERE UPPER(FACTORY_CODE)='{FACTORY_CODE}' AND UPPER(FACTORY_NAME)='{FACTORY_NAME}' AND UPPER(FACTORY_ADDRESS)='{FACTORY_ADDRESS}'"; table = DB.ExecSelect(sql).Tables[0]; if (table.Rows.Count > 0) { return(1); // factorycode+factoryname+factoryaddress existed fail primary key } sql = $@"UPDATE C_FACTORY SET FACTORY_CODE=:FACTORY_CODE,FACTORY_NAME=:FACTORY_NAME,FACTORY_ADDRESS=:FACTORY_ADDRESS,DESCRIPTION=:DESCRIPTION,EDIT_TIME=SYSDATE,EDIT_EMP=:EDIT_EMP WHERE ID='{ID}'"; param = new OleDbParameter[] { new OleDbParameter("FACTORY_CODE", FACTORY_CODE.ToUpper()), new OleDbParameter("FACTORY_NAME", FACTORY_NAME.ToUpper()), new OleDbParameter("FACTORY_ADDRESS", FACTORY_ADDRESS.ToUpper()), new OleDbParameter("DESCRIPTION", DESCRIPTION), new OleDbParameter("EDIT_EMP", EDIT_EMP) }; result = DB.ExecuteNonQuery(sql, CommandType.Text, param); if (result > 0) { return(2); //Update success } else { return(3); //Update fail } } catch (Exception e) { return(4); //exception throw e; } }
/// <summary> /// 添加C_ROUTE_DETAIL /// </summary> /// <param name="newc_route_detail"></param> /// <param name="DB"></param> /// <returns></returns> public int Add(C_ROUTE_DETAIL newc_route_detail, OleExec DB) { string strSql = $@"insert into c_route_detail(id,seq_no,route_id,station_name,station_type,return_flag)"; strSql = strSql + $@"values(:id,:seq_no,:route_id,:station_name,:station_type,:return_flag)"; OleDbParameter[] paramet = new OleDbParameter[6]; paramet[0] = new OleDbParameter(":id", newc_route_detail.ID); paramet[1] = new OleDbParameter(":seq_no", newc_route_detail.SEQ_NO); paramet[2] = new OleDbParameter(":route_id", newc_route_detail.ROUTE_ID); paramet[3] = new OleDbParameter(":station_name", newc_route_detail.STATION_NAME); paramet[4] = new OleDbParameter(":station_type", newc_route_detail.STATION_TYPE); paramet[5] = new OleDbParameter(":return_flag", newc_route_detail.RETURN_FLAG); int result = DB.ExecuteNonQuery(strSql, CommandType.Text, paramet); return(result); }
/// <summary> /// 添加新的路由 /// </summary> /// <param name="newRoute">新的路由</param> /// <param name="DB"></param> /// <returns>成功返回大於零的數,失敗返回0</returns> public int Add(C_ROUTE newRoute, OleExec DB) { string strSql = $@"insert into c_route(id,route_name,default_skuno,route_type,edit_time,edit_emp)"; strSql = strSql + $@"values(:id,:route_name,:default_skuno,:route_type,:edit_time,:edit_emp)"; OleDbParameter[] paramet = new OleDbParameter[6]; paramet[0] = new OleDbParameter(":id", newRoute.ID); paramet[1] = new OleDbParameter(":route_name", newRoute.ROUTE_NAME); paramet[2] = new OleDbParameter(":default_skuno", newRoute.DEFAULT_SKUNO); paramet[3] = new OleDbParameter(":route_type", newRoute.ROUTE_TYPE); paramet[4] = new OleDbParameter(":edit_time", newRoute.EDIT_TIME); paramet[5] = new OleDbParameter(":edit_emp", newRoute.EDIT_EMP); int result = DB.ExecuteNonQuery(strSql, CommandType.Text, paramet); return(result); }