public static int UpdateInformation(A2ZRECCTRLNODTO dto)
{
int rowEffect = 0;
string strQuery = "UPDATE A2ZRECCTRLNO set CtrlGLCashCode='" + dto.GLCashCode + "', CtrlRecType='" + dto.RecType + "',CtrlRecLastNo='" + dto.RecLastNo + "' WHERE CtrlGLCashCode ='" + dto.GLCashCode + "'and CtrlRecType='" + dto.RecType + "'";
rowEffect = Converter.GetInteger(BLL.CommonManager.Instance.ExecuteNonQuery(strQuery, "A2ZCSCUBS"));
if (rowEffect == 0)
{
return(0);
}
else
{
return(1);
}
}
public static int InsertInformation(A2ZRECCTRLNODTO dto)
{
int rowEffect = 0;
string strQuery = @"INSERT into A2ZRECCTRLNO(CtrlGLCashCode,CtrlRecType,CtrlRecLastNo)values('" + dto.GLCashCode + "','" + dto.RecType + "','" + dto.RecLastNo + "')";
rowEffect = Converter.GetInteger(BLL.CommonManager.Instance.ExecuteNonQuery(strQuery, "A2ZCSCUBS"));
if (rowEffect == 0)
{
return(0);
}
else
{
return(1);
}
}
public static A2ZRECCTRLNODTO GetInformation(int GLCashCode, Int16 RecType)
{
DataTable dt = BLL.CommonManager.Instance.GetDataTableByQuery("SELECT * FROM A2ZRECCTRLNO WHERE CtrlGLCashCode='" + GLCashCode + "' and CtrlRecType='" + RecType + "' ", "A2ZCSCUBS");
var p = new A2ZRECCTRLNODTO();
if (dt.Rows.Count > 0)
{
p.GLCashCode = Converter.GetInteger(dt.Rows[0]["CtrlGLCashCode"]);
p.RecType = Converter.GetSmallInteger(dt.Rows[0]["CtrlRecType"]);
p.RecLastNo = Converter.GetInteger(dt.Rows[0]["CtrlRecLastNo"]);
p.Record = Converter.GetInteger(1);
return(p);
}
p.Record = 0;
return(p);
}
public static A2ZRECCTRLNODTO ReadLastVoucherNo(int CashCode, Int16 RecType)
{
DataTable dt = BLL.CommonManager.Instance.GetDataTableByQuery("SELECT * FROM A2ZRECCTRLNO WHERE CtrlGLCashCode ='" + CashCode + "' and CtrlRecType='" + RecType + "' ", "A2ZACOMS");
var p = new A2ZRECCTRLNODTO();
if (dt.Rows.Count > 0)
{
p.GLCashCode = Converter.GetInteger(dt.Rows[0]["CtrlGLCashCode"]);
p.RecLastNo = Converter.GetInteger(dt.Rows[0]["CtrlRecLastNo"]);
return(p);
}
p.GLCashCode = 0;
return(p);
}
//--------------------------- VOUCHER'S INFORMATIONS ------------------------
public static A2ZRECCTRLNODTO GetLastVoucherNo(int CashCode, Int16 RecType)
{
DataTable dt = BLL.CommonManager.Instance.GetDataTableByQuery("SELECT * FROM A2ZRECCTRLNO WHERE CtrlGLCashCode ='" + CashCode + "' and CtrlRecType='" + RecType + "'", "A2ZCSCUBS");
var p = new A2ZRECCTRLNODTO();
if (dt.Rows.Count > 0)
{
p.GLCashCode = Converter.GetInteger(dt.Rows[0]["CtrlGLCashCode"]);
p.RecType = Converter.GetSmallInteger(dt.Rows[0]["CtrlRecType"]);
p.RecLastNo = Converter.GetInteger(dt.Rows[0]["CtrlRecLastNo"]);
p.RecLastNo = p.RecLastNo + 1;
int rowEffect = 0;
string strQuery = "UPDATE A2ZRECCTRLNO set CtrlGLCashCode='" + p.GLCashCode + "', CtrlRecType='" + p.RecType + "',CtrlRecLastNo='" + p.RecLastNo + "' WHERE CtrlGLCashCode ='" + p.GLCashCode + "'and CtrlRecType='" + p.RecType + "'";
rowEffect = Converter.GetInteger(BLL.CommonManager.Instance.ExecuteNonQuery(strQuery, "A2ZCSCUBS"));
return(p);
}
p.GLCashCode = 0;
return(p);
}
