public bool IsAuthenticationPass(string login, string password) { bool isValid = false; try { ProcParam procPara = new ProcParam(3) { ProcedureName = "ADM_PKG.CHECK_AUTHENTICATION_USER" }; procPara.AddParamReturn(0, "ReturnValue", Oracle.DataAccess.Client.OracleDbType.Varchar2, 30); procPara.AddParamInput(1, "strLogin", login); procPara.AddParamInput(2, "strPwd", password); GlobalDB.Instance.DataAc.ExecuteNonQuery(procPara); if (GlobalDB.Instance.DataAc.LastException != null) { throw GlobalDB.Instance.DataAc.LastException; } OracleString result = (OracleString)procPara.ReturnValue(0); if (!result.IsNull) { isValid = !string.IsNullOrEmpty(result.Value); } } catch (Exception ex) { throw ex; } return(isValid); }
public bool Press_CheckExistMachine(string mcNo) { bool isValid = false; try { ProcParam procPara = new ProcParam(2) { ProcedureName = "SCANNER_PACK_PRESS.CHK_EXISTS_MC" }; procPara.AddParamReturn(0, "ReturnValue", OracleDbType.Int32, 120); procPara.AddParamInput(1, "strNo", mcNo); GlobalDB.Instance.DataAc.ExecuteNonQuery(procPara); this.executionTime = GlobalDB.Instance.DataAc.ExecuteTime; OracleDecimal objResult = (OracleDecimal)procPara.ReturnValue(0); if (!objResult.IsNull) { isValid = (objResult.ToInt32() > 0); } } catch (Exception ex) { throw ex; } return(isValid); }
private string GetBomRevisionSeq(string fileid, string userid) { string result = string.Empty; try { ProcParam param = new ProcParam(3) { ProcedureName = "INTERFACE_PACK.UP_BOM_REVISION" }; param.AddParamReturn(0, "ReturnValue", Oracle.DataAccess.Client.OracleDbType.Varchar2, 255); param.AddParamInput(1, "strFILE_ID", fileid); param.AddParamInput(2, "strUser_id", userid); GlobalDB.Instance.DataAc.ExecuteNonQuery(param); //this.executionTime = GlobalDB.Instance.DataAc.ExecuteTime; OracleString resultDB = (OracleString)param.ReturnValue(0); if (!resultDB.IsNull) { result = resultDB.Value; } } catch (Exception ex) { throw ex; } return(result); }
public int GeneratePrintSEQ() { int printSeq = 0; try { ProcParam procSEQ = new ProcParam(1); procSEQ.ProcedureName = "GEN_NO.PRINT_SEQ"; procSEQ.AddParamReturn(0, "ReturnValue", OracleDbType.Int32, 100); GlobalDB.Instance.DataAc.ExecuteNonQuery(procSEQ); ////this.executionTime = GlobalDB.Instance.DataAc.ExecuteTime; OracleDecimal result = (OracleDecimal)procSEQ.ReturnValue(0); if (!result.IsNull) { printSeq = result.ToInt32(); } } catch (Exception ex) { printSeq = 0; } return(printSeq); }
public string GetRevisionLastUpdate() { string result = string.Empty; try { ProcParam param = new ProcParam(1) { ProcedureName = "INTERFACE_PACK.RET_LAST_REV" }; param.AddParamReturn(0, "ReturnValue", Oracle.DataAccess.Client.OracleDbType.Date, 255); GlobalDB.Instance.DataAc.ExecuteNonQuery(param); //this.executionTime = GlobalDB.Instance.DataAc.ExecuteTime; object oResult = param.ReturnValue(0); if (!oResult.Equals(DBNull.Value)) { OracleDate resultDB = (OracleDate)oResult; if (!resultDB.IsNull) { result = resultDB.Value.ToString("dd-MM-yyyy HH:mm:ss"); } } } catch (Exception ex) { throw ex; } return(result); }
private void button7_Click(object sender, EventArgs e) { ProcParam procPara = new ProcParam(3); procPara.ProcedureName = "DAL_PACK.USER_LOGON"; procPara.AddParamReturn(0, "ReturnValue", OracleDbType.Varchar2, 100); procPara.AddParamInput(1, "strVal", "JACK"); procPara.AddParamInput(2, "strPwd", "pa$$w1"); OraDB.Instance.DataAc.ExecuteNonQuery(procPara); if (OraDB.Instance.DataAc.LastException != null) { MessageBox.Show(OraDB.Instance.DataAc.LastException.Message); } else { object objResult = (string.IsNullOrEmpty(procPara.Parameters[0].Value.ToString().Trim()) ? null : procPara.Parameters[0].Value); if (objResult == null) { MessageBox.Show("is null"); } else { MessageBox.Show(objResult.ToString()); } } }
public bool CheckExistLocation(string location) { bool isValid = false; try { ProcParam procPara = new ProcParam(2) { ProcedureName = "SCANNER_MAT_PACK.CHK_EXISTS_LOCATION" }; procPara.AddParamReturn(0, "ReturnValue", OracleDbType.Int32, 120); procPara.AddParamInput(1, "strLOCATION", location); GlobalDB.Instance.DataAc.ExecuteNonQuery(procPara); this.executionTime = GlobalDB.Instance.DataAc.ExecuteTime; OracleDecimal objResult = (OracleDecimal)procPara.ReturnValue(0); if (!objResult.IsNull) { isValid = (objResult.ToInt32() > 0); } } catch (Exception ex) { throw ex; } return(isValid); }
public Version GetLastestVersion(string curVersion) { Version resultVersion = Version.Parse(curVersion); try { ProcParam procPara = new ProcParam(2) { ProcedureName = "ADMINISTRATOR_PACK.GET_APP_VERSION" }; procPara.AddParamReturn(0, "ReturnValue", OracleDbType.Varchar2, 10); procPara.AddParamInput(1, "strCURV", resultVersion.ToString()); GlobalDB.Instance.DataAc.ExecuteNonQuery(procPara); if (GlobalDB.Instance.DataAc.LastException != null) { throw GlobalDB.Instance.DataAc.LastException; } var resultDB = (OracleString)procPara.ReturnValue(0); if (!resultDB.IsNull) { resultVersion = Version.Parse(resultDB.ToString()); } } catch (Exception ex) { resultVersion = Version.Parse(curVersion); } return(resultVersion); }
public bool UserAuthentication(string userName, string password) { this.userid = string.Empty; string result = string.Empty; try { ProcParam procPara = new ProcParam(3); procPara.ProcedureName = "ADMINISTRATOR_PACK.USER_LOGON"; procPara.AddParamReturn(0, "ReturnValue", OracleDbType.Raw, 255); procPara.AddParamInput(1, "strVal", userName); procPara.AddParamInput(2, "strPwd", password); GlobalDB.Instance.DataAc.ExecuteNonQuery(procPara); ////this.executionTime = GlobalDB.Instance.DataAc.ExecuteTime; //OracleString objResult = (OracleString)procPara.Parameters[0].Value; OracleBinary objResult = (OracleBinary)procPara.ReturnValue(0); //byte[] resultByte = this.GetCurrectByteArray(objResult); //result = System.Text.Encoding.Default.GetString(resultByte, 0, resultByte.Length); if (!objResult.IsNull) { result = Encoding.Default.GetString(objResult.Value, 0, objResult.Length); } else { result = ""; } } catch (Exception ex) { throw ex; } if (result != "") { //Authentication pass this.userid = result; return(true); } else { //Authentication fail return(false); } }
public bool IsNumberOfPalateMaching(string arrNo, out string resultMessage) { resultMessage = string.Empty; string result = string.Empty; try { ProcParam procPara = new ProcParam(3) { ProcedureName = "ARRIVAL_PACK.ARR_NUMBER_PTL_MACHING" }; procPara.AddParamReturn(0, "ReturnValue", OracleDbType.NVarchar2, 100); procPara.AddParamInput(1, "strARRIVAL_NO", arrNo); procPara.AddParamOutput(2, "RESULTMSG", OracleDbType.NVarchar2, 255); GlobalDB.Instance.DataAc.ExecuteNonQuery(procPara); if (GlobalDB.Instance.LastException != null) { throw GlobalDB.Instance.LastException; } //inform time //this.executionTime = oracleData.ExecutionTime; result = procPara.Parameters[0].Value.ToString().Trim(); resultMessage = procPara.Parameters[2].Value.ToString(); } catch (Exception ex) { resultMessage = ex.Message; result = ""; } if (result == "Y") { return(true); } else { return(false); } }
public string FGPress_CheckValidationUser(string userid) { string result = string.Empty; try { ProcParam procPara = new ProcParam(2) { ProcedureName = "SCANNER_PACK_FG_PRESS.USER_VALIDATION" }; procPara.AddParamReturn(0, "ReturnValue", OracleDbType.Raw, 255); procPara.AddParamInput(1, "strUSER_ID", userid); GlobalDB.Instance.DataAc.ExecuteNonQuery(procPara); if (GlobalDB.Instance.LastException != null) { throw GlobalDB.Instance.LastException; } this.executionTime = GlobalDB.Instance.DataAc.ExecuteTime; //OracleString objResult = (OracleString)procPara.ReturnValue(0); OracleBinary objResult = (OracleBinary)procPara.ReturnValue(0); if (!objResult.IsNull) { result = UtilityBLL.GetReturnRawData(objResult); } else { result = string.Empty; } } catch (Exception ex) { throw ex; } return(result); }
public int ProductBoxQty(string prodSeq) { try { ProcParam param = new ProcParam(2); param.ProcedureName = "INFO.PRODUCT_BOX_QTY"; param.AddParamReturn(0, "ReturnValue", OracleDbType.Decimal, 100); param.AddParamInput(1, "strNo", prodSeq); GlobalDB.Instance.DataAc.ExecuteNonQuery(param); OracleDecimal result = (OracleDecimal)param.ReturnValue(0); return(result.ToInt32()); } catch (Exception ex) { throw ex; } }
public string RegisterEStockUser(string userlogin, string userpass, out string cust_uid) { cust_uid = string.Empty; string resultMsg = string.Empty; try { ProcParam procPara = new ProcParam(3) { ProcedureName = "ADM_PKG.CHECK_AUTHENTICATION_USER" }; procPara.AddParamReturn(0, "ReturnValue", Oracle.DataAccess.Client.OracleDbType.Varchar2, 30); procPara.AddParamInput(1, "strLogin", userlogin); procPara.AddParamInput(2, "strPwd", userpass); GlobalDB.Instance.DataAc.ExecuteNonQuery(procPara); if (GlobalDB.Instance.DataAc.LastException != null) { throw GlobalDB.Instance.DataAc.LastException; } OracleString result = (OracleString)procPara.ReturnValue(0); if (!result.IsNull) { resultMsg = "Info.REGISTER_SUCCESS"; cust_uid = result.Value; } else { resultMsg = "Error.USER_NOT_REGISTER"; } } catch (Exception ex) { throw ex; } return(resultMsg); }
private Bitmap ProductImage(string proSeqNo) { Bitmap result = null; try { ProcParam param = new ProcParam(2) { ProcedureName = "INFO.MATERIAL_IMAGE" }; param.AddParamReturn(0, "ReturnValue", OracleDbType.Blob, 255); param.AddParamInput(1, "strNo", proSeqNo); GlobalDB.Instance.DataAc.ExecuteNonQuery(param); //this.executionTime = GlobalDB.Instance.DataAc.ExecuteTime; OracleBlob blobDB = (OracleBlob)param.ReturnValue(0); if (!blobDB.IsNull) { using (MemoryStream ms = new MemoryStream(blobDB.Value)) { result = (Bitmap)Bitmap.FromStream(ms); } return(result); } else { return(null); } } catch (Exception ex) { throw ex; } }
public string CheckValidationUser(string userid, string ipaddress, string serialno, string scanversion) { string result = string.Empty; try { ProcParam procPara = new ProcParam(2) { ProcedureName = "SCANNER_MAT_CHK_PACK.USER_VALIDATION" }; procPara.AddParamReturn(0, "ReturnValue", OracleDbType.Raw, 255); procPara.AddParamInput(1, "strUSER_ID", userid); GlobalDB.Instance.DataAc.ExecuteNonQuery(procPara); if (GlobalDB.Instance.DataAc.LastException != null) { throw GlobalDB.Instance.DataAc.LastException; } OracleBinary objResult = (OracleBinary)procPara.ReturnValue(0); if (!objResult.IsNull) { result = UtilityBLL.GetReturnRawData(objResult); } else { result = string.Empty; } } catch (Exception ex) { throw ex; } return(result); }
public ResponseResult CheckJobOrder(string jobno) { response = new ResponseResult(); try { ProcParam procPara = new ProcParam(3) { ProcedureName = "SCANNER_MAT_CHK_PACK.CHK_JOB_ORDER" }; procPara.AddParamReturn(0, "ReturnValue", OracleDbType.Varchar2, 30); procPara.AddParamInput(1, "strJOB_NO", jobno); procPara.AddParamOutput(2, "RESULTMSG", OracleDbType.Varchar2, 255); GlobalDB.Instance.DataAc.ExecuteNonQuery(procPara); if (GlobalDB.Instance.DataAc.LastException != null) { throw GlobalDB.Instance.DataAc.LastException; } var returnValue = (OracleString)procPara.ReturnValue(0); var resultMsg = (OracleString)procPara.ReturnValue(2); response.Message = resultMsg.ToString(); response.Data = returnValue.ToString(); } catch (Exception ex) { response.Status = false; response.Message = ex.Message; response.Data = string.Empty; } return(response); }