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);
}