private POEditData GetData()
{
POEditData data = new POEditData();
data.PECODE = this.txtPECode.Text.Trim();
data.DATEFROM = this.ctlDateFrom.DateValue;
data.DATETO = this.ctlDateTo.DateValue;
data.PODATEFROM = this.ctlPODateFrom.DateValue;
data.PODATETO = this.ctlPODateTo.DateValue;
data.POCODE = this.txtPOCode.Text.Trim();
data.STATUSFROM = this.cmbStatusFrom.SelectedItem.Value;
data.STATUSTO = this.cmbStatusTo.SelectedItem.Value;
data.SUPPLIER = this.cmbSupplier.SelectedItem.Value;
return data;
}
public bool UpdateDataPOEdit(string userID, POEditData data)
{
bool ret = true;
OracleDBObj obj = new OracleDBObj();
obj.CreateConnection();
obj.CreateTransaction();
try
{
DALObj2.OnDB = false;
DALObj2.GetDataByLOID(data.LOID, obj.zTrans);
DALObj2.ACTIVE = data.ACTIVE;
DALObj2.APPROVEDATE = data.APPROVEDATE;
DALObj2.APPROVER = data.APPROVER;
DALObj2.POEDITDATE = data.POEDITDATE;
DALObj2.CODE = data.CODE;
DALObj2.PONEW = data.PONEW;
DALObj2.POOLD = data.POOLD;
DALObj2.REASON = data.REASON;
DALObj2.REMARK = data.REMARK;
DALObj2.STATUS = data.STATUS;
DALObj2.TYPE = data.TYPE;
if (DALObj2.OnDB)
ret = DALObj2.UpdateCurrentData(userID, obj.zTrans);
else
ret = DALObj2.InsertCurrentData(userID, obj.zTrans);
_LOIDEDIT = DALObj2.LOID;
if (!ret)
{
throw new ApplicationException(DALObj.ErrorMessage);
}
obj.zTrans.Commit();
obj.CloseConnection();
}
catch (Exception ex)
{
obj.zTrans.Rollback();
obj.CloseConnection();
ret = false;
_error = ex.Message;
}
return ret;
}
//public DataTable GetPOEditList(POEditData data)
//{
// string whereString = "";
// if (data.PECODE.Trim() != "")
// whereString += (whereString == "" ? "" : "AND ") + "UPPER(PECODE) = '" + OracleDB.QRText(data.PECODE.Trim()).ToUpper() + "' ";
// if (data.POCODE.Trim() != "")
// whereString += (whereString == "" ? "" : "AND ") + "UPPER(POCODE) = '" + OracleDB.QRText(data.POCODE.Trim()).ToUpper() + "' ";
// if (data.DATEFROM.Year != 1)
// whereString += (whereString == "" ? "" : "AND ") + "POEDITDATE >= " + OracleDB.QRDate(data.DATEFROM) + " ";
// if (data.DATETO.Year != 1)
// whereString += (whereString == "" ? "" : "AND ") + "POEDITDATE <= " + OracleDB.QRDate(data.DATETO) + " ";
// if (data.PODATEFROM.Year != 1)
// whereString += (whereString == "" ? "" : "AND ") + "ORDERDATE >= " + OracleDB.QRDate(data.PODATEFROM) + " ";
// if (data.PODATETO.Year != 1)
// whereString += (whereString == "" ? "" : "AND ") + "ORDERDATE <= " + OracleDB.QRDate(data.PODATETO) + " ";
// if (data.SUPPLIER != "0")
// whereString += (whereString == "" ? "" : "AND ") + "SUPPLIER = " + data.SUPPLIER.ToString() + " ";
// if (data.STATUSFROM.Trim() != "")
// whereString += (whereString == "" ? "" : "AND ") + "RANK >= '" + OracleDB.QRText(data.STATUSFROM.Trim()) + "' ";
// if (data.STATUSTO.Trim() != "")
// whereString += (whereString == "" ? "" : "AND ") + "RANK <= '" + OracleDB.QRText(data.STATUSTO.Trim()) + "' ";
// string sql = "SELECT * FROM (SELECT ROWNUM NO, PE.LOID PELOID, PE.CODE PECODE, PE.POEDITDATE, PE.REASON, PO.LOID POLOID, PO.CODE POCODE, PO.ORDERDATE, ";
// sql += "CASE PE.STATUS WHEN '" + Constz.Requisition.Status.Waiting.Code + "' THEN '" + Constz.Requisition.Status.Waiting.Name + "' ";
// sql += "WHEN '" + Constz.Requisition.Status.Approved.Code + "' THEN '" + Constz.Requisition.Status.Approved.Name + "' ";
// sql += "WHEN '" + Constz.Requisition.Status.Void.Code + "' THEN '" + Constz.Requisition.Status.Void.Name + "' ";
// sql += "ELSE '' END AS STATUSNAME, ";
// sql += "CASE PE.STATUS WHEN '" + Constz.Requisition.Status.Waiting.Code + "' THEN '" + Constz.Requisition.Status.Waiting.Rank + "' ";
// sql += "WHEN '" + Constz.Requisition.Status.Approved.Code + "' THEN '" + Constz.Requisition.Status.Approved.Rank + "' ";
// sql += "WHEN '" + Constz.Requisition.Status.Void.Code + "' THEN '" + Constz.Requisition.Status.Void.Rank + "' ";
// sql += "ELSE '' END AS RANK, PO.SUPPLIER,S.SUPPLIERNAME, PE.PONEW, PE.POOLD ";
// sql += "FROM POEDIT PE INNER JOIN PDORDER PO ON PE.POOLD = PO.LOID ";
// sql += "INNER JOIN SUPPLIER S ON PO.SUPPLIER = S.LOID) ";
// sql += (whereString == "" ? "" : "WHERE " + whereString);
// sql += "ORDER BY PECODE ";
// DataTable dt = OracleDB.ExecListCmd(sql);
// return dt;
//}
public DataTable GetPOEditList(POEditData data)
{
DataTable dt = DALObj2.GetPOEditList(data);
int i = 1;
foreach (DataRow dRow in dt.Rows)
{
dRow["NO"] = i;
i += 1;
}
return dt;
}
public POEditData GetDataEdit(double loid)
{
POEditData data = new POEditData();
if (DALObj2.GetDataByLOID(loid, null))
{
data.LOID = DALObj2.LOID;
data.CODE = DALObj2.CODE;
data.ACTIVE = DALObj2.ACTIVE;
data.APPROVEDATE = DALObj2.APPROVEDATE;
data.APPROVER = DALObj2.APPROVER;
data.POEDITDATE = DALObj2.POEDITDATE;
data.PONEW = DALObj2.PONEW;
data.POOLD = DALObj2.POOLD;
data.REASON = DALObj2.REASON;
data.REMARK = DALObj2.REMARK;
data.STATUS = DALObj2.STATUS;
}
return data;
}
public DataTable GetPOEditList(POEditData data)
{
string whereString = "";
if (data.PECODE.Trim() != "")
whereString += (whereString == "" ? "" : "AND ") + "UPPER(PECODE) = '" + OracleDB.QRText(data.PECODE.Trim()).ToUpper() + "' ";
if (data.POCODE.Trim() != "")
whereString += (whereString == "" ? "" : "AND ") + "UPPER(POCODE) = '" + OracleDB.QRText(data.POCODE.Trim()).ToUpper() + "' ";
if (data.DATEFROM.Year != 1)
whereString += (whereString == "" ? "" : "AND ") + "POEDITDATE >= " + OracleDB.QRDate(data.DATEFROM) + " ";
if (data.DATETO.Year != 1)
whereString += (whereString == "" ? "" : "AND ") + "POEDITDATE <= " + OracleDB.QRDate(data.DATETO) + " ";
if (data.PODATEFROM.Year != 1)
whereString += (whereString == "" ? "" : "AND ") + "ORDERDATE >= " + OracleDB.QRDate(data.PODATEFROM) + " ";
if (data.PODATETO.Year != 1)
whereString += (whereString == "" ? "" : "AND ") + "ORDERDATE <= " + OracleDB.QRDate(data.PODATETO) + " ";
if (data.SUPPLIER != "0")
whereString += (whereString == "" ? "" : "AND ") + "SUPPLIER = " + data.SUPPLIER.ToString() + " ";
if (data.STATUSFROM.Trim() != "")
whereString += (whereString == "" ? "" : "AND ") + "RANK >= '" + OracleDB.QRText(data.STATUSFROM.Trim()) + "' ";
if (data.STATUSTO.Trim() != "")
whereString += (whereString == "" ? "" : "AND ") + "RANK <= '" + OracleDB.QRText(data.STATUSTO.Trim()) + "' ";
string sql = "SELECT * FROM (SELECT ROWNUM NO, PE.LOID PELOID, PE.CODE PECODE, PE.POEDITDATE, PE.REASON, PO.LOID POLOID, PO.CODE POCODE, PO.ORDERDATE, ";
sql += "CASE PE.STATUS WHEN '" + Constz.Requisition.Status.Waiting.Code + "' THEN '" + Constz.Requisition.Status.Waiting.Name + "' ";
sql += "WHEN '" + Constz.Requisition.Status.Approved.Code + "' THEN '" + Constz.Requisition.Status.Approved.Name + "' ";
sql += "WHEN '" + Constz.Requisition.Status.Void.Code + "' THEN '" + Constz.Requisition.Status.Void.Name + "' ";
sql += "ELSE '' END AS STATUSNAME, ";
sql += "CASE PE.STATUS WHEN '" + Constz.Requisition.Status.Waiting.Code + "' THEN '" + Constz.Requisition.Status.Waiting.Rank + "' ";
sql += "WHEN '" + Constz.Requisition.Status.Approved.Code + "' THEN '" + Constz.Requisition.Status.Approved.Rank + "' ";
sql += "WHEN '" + Constz.Requisition.Status.Void.Code + "' THEN '" + Constz.Requisition.Status.Void.Rank + "' ";
sql += "ELSE '' END AS RANK, PO.SUPPLIER,S.SUPPLIERNAME, PE.PONEW, PE.POOLD ";
sql += "FROM POEDIT PE INNER JOIN PDORDER PO ON PE.POOLD = PO.LOID ";
sql += "INNER JOIN SUPPLIER S ON PO.SUPPLIER = S.LOID) ";
sql += (whereString == "" ? "" : "WHERE " + whereString);
sql += "ORDER BY PECODE DESC";
DataTable dt = OracleDB.ExecListCmd(sql);
return dt;
}
private POEditData GetRecentDataEdit()
{
POEditData data = new POEditData();
data.LOID = Convert.ToDouble(this.txtLOID.Text == "" ? "0" : this.txtLOID.Text);
data.CODE = this.txtEditCode.Text.Trim();
data.STATUS = Constz.Requisition.Status.Approved.Code;
data.ACTIVE = Constz.ActiveStatus.Active;
data.POEDITDATE = this.ctlOrderDate.DateValue;
data.PONEW = Convert.ToDouble(this.txtNewLoid.Text == "" ? "0" : this.txtNewLoid.Text);
data.POOLD = Convert.ToDouble(this.txtOldLoid.Text == "" ? "0" : this.txtOldLoid.Text);
data.REASON = this.txtReason.Text.Trim();
data.REMARK = this.txtRemark.Text.Trim();
data.APPROVEDATE = DateTime.Now.Date;
data.APPROVER = Authz.CurrentUserInfo.UserID;
data.TYPE = "1";
return data;
}
private POEditData GetDataEdit()
{
POEditData data = new POEditData();
data.LOID = Convert.ToDouble(this.txtLOID.Text == "" ? "0" : this.txtLOID.Text);
data.CODE = this.txtEditCode.Text.Trim();
data.STATUS = this.txtStatus.Text.Trim();
data.ACTIVE = Constz.ActiveStatus.Active;
data.POEDITDATE = this.ctlOrderDate.DateValue;
data.PONEW = Convert.ToDouble(this.txtNewLoid.Text == "" ? "0" : this.txtNewLoid.Text);
data.POOLD = Convert.ToDouble(this.txtOldLoid.Text == "" ? "0" : this.txtOldLoid.Text);
data.REASON = this.txtReason.Text.Trim();
data.REMARK = this.txtRemark.Text.Trim();
data.TYPE = "1";
return data;
}
private void SetDataEdit(POEditData data)
{
this.txtLOID.Text = data.LOID.ToString();
this.ctlOrderDate.DateValue = data.POEDITDATE;
this.txtEditCode.Text = data.CODE;
this.txtNewLoid.Text = data.PONEW.ToString();
this.txtOldLoid.Text = data.POOLD.ToString();
this.txtReason.Text = data.REASON;
this.txtRemark.Text = data.REMARK;
this.txtStatus.Text = data.STATUS;
this.txtStatusName.Text = (data.STATUS == Constz.Requisition.Status.Approved.Code ? Constz.Requisition.Status.Approved.Name : (data.STATUS == Constz.Requisition.Status.Void.Code ? Constz.Requisition.Status.Void.Name : Constz.Requisition.Status.Waiting.Name));
if (data.STATUS == Constz.Requisition.Status.Approved.Code || data.STATUS == Constz.Requisition.Status.Void.Code)
{
this.ctlToolbar.BtnSaveShow = false;
this.ctlToolbar.BtnSubmitShow = false;
}
}
