public static A2ZRECCTRLDTO ReadLastVoucherNo(int CashCode) { DataTable dt = BLL.CommonManager.Instance.GetDataTableByQuery("SELECT * FROM A2ZCGLMST WHERE GLAccNo = " + CashCode, "A2ZGLMCUS"); var p = new A2ZRECCTRLDTO(); if (dt.Rows.Count > 0) { p.GLCashCode = Converter.GetInteger(dt.Rows[0]["GLAccNo"]); p.RecLastVchNo = Converter.GetInteger(dt.Rows[0]["LastVoucherNo"]); return(p); } p.GLCashCode = 0; return(p); }
public static A2ZRECCTRLDTO ReadLastRecords(Int16 RecType) { DataTable dt = BLL.CommonManager.Instance.GetDataTableByQuery("SELECT * FROM A2ZRECCTRL WHERE CtrlRecType = " + RecType, "A2ZCSMCUS"); var p = new A2ZRECCTRLDTO(); if (dt.Rows.Count > 0) { p.CtrlRecType = Converter.GetSmallInteger(dt.Rows[0]["CtrlRecType"]); p.CtrlRecLastNo = Converter.GetInteger(dt.Rows[0]["CtrlRecLastNo"]); return(p); } p.CtrlRecType = 0; return(p); }
public static A2ZRECCTRLDTO ReadLastRecords(int BranchNo, Int16 RecType) { DataTable dt = new DataTable(); string strQuery = "SELECT * FROM A2ZRECCTRL WHERE BranchNo='" + BranchNo + "' AND CtrlRecType='" + RecType + "'"; dt = BLL.CommonManager.Instance.GetDataTableByQuery(strQuery, "A2ZCSCUBS"); var p = new A2ZRECCTRLDTO(); if (dt.Rows.Count > 0) { p.CtrlRecType = Converter.GetSmallInteger(dt.Rows[0]["CtrlRecType"]); p.CtrlRecLastNo = Converter.GetInteger(dt.Rows[0]["CtrlRecLastNo"]); return(p); } p.CtrlRecType = 0; return(p); }
//--------------------------- VOUCHER'S INFORMATIONS ------------------------ public static A2ZRECCTRLDTO GetLastVoucherNo(int CashCode) { DataTable dt = BLL.CommonManager.Instance.GetDataTableByQuery("SELECT * FROM A2ZCGLMST WHERE GLAccNo = " + CashCode, "A2ZGLMCUS"); var p = new A2ZRECCTRLDTO(); if (dt.Rows.Count > 0) { p.GLCashCode = Converter.GetInteger(dt.Rows[0]["GLAccNo"]); p.RecLastVchNo = Converter.GetInteger(dt.Rows[0]["LastVoucherNo"]); p.RecLastVchNo = p.RecLastVchNo + 1; int rowEffect = 0; string strQuery = "UPDATE A2ZCGLMST set LastVoucherNo='" + p.RecLastVchNo + "' where GLAccNo='" + p.GLCashCode + "'"; rowEffect = Converter.GetInteger(BLL.CommonManager.Instance.ExecuteNonQuery(strQuery, "A2ZGLMCUS")); return(p); } p.GLCashCode = 0; return(p); }
public static A2ZRECCTRLDTO GetLastRecords(Int16 RecType) { DataTable dt = BLL.CommonManager.Instance.GetDataTableByQuery("SELECT * FROM A2ZRECCTRL WHERE CtrlRecType = " + RecType, "A2ZCSMCUS"); var p = new A2ZRECCTRLDTO(); if (dt.Rows.Count > 0) { p.CtrlRecType = Converter.GetSmallInteger(dt.Rows[0]["CtrlRecType"]); p.CtrlRecLastNo = Converter.GetInteger(dt.Rows[0]["CtrlRecLastNo"]); p.CtrlRecLastNo = p.CtrlRecLastNo + 1; int rowEffect = 0; string strQuery = "UPDATE A2ZRECCTRL set CtrlRecLastNo='" + p.CtrlRecLastNo + "' where CtrlRecType='" + p.CtrlRecType + "'"; rowEffect = Converter.GetInteger(BLL.CommonManager.Instance.ExecuteNonQuery(strQuery, "A2ZCSMCUS")); return(p); } p.CtrlRecType = 0; return(p); }
public static A2ZRECCTRLDTO UpdateLastRecords(int BranchNo, Int16 RecType, int MemNo) { DataTable dt = new DataTable(); string strQuery = "SELECT * FROM A2ZRECCTRL WHERE BranchNo='" + BranchNo + "' AND CtrlRecType='" + RecType + "'"; dt = BLL.CommonManager.Instance.GetDataTableByQuery(strQuery, "A2ZCSCUBS"); var p = new A2ZRECCTRLDTO(); if (dt.Rows.Count > 0) { p.CtrlRecType = Converter.GetSmallInteger(dt.Rows[0]["CtrlRecType"]); p.CtrlRecLastNo = Converter.GetInteger(dt.Rows[0]["CtrlRecLastNo"]); p.CtrlRecLastNo = p.CtrlRecLastNo + 1; int rowEffect = 0; string str1Query = "UPDATE A2ZRECCTRL set CtrlRecLastNo='" + MemNo + "' where BranchNo='" + BranchNo + "' AND CtrlRecType='" + p.CtrlRecType + "'"; rowEffect = Converter.GetInteger(BLL.CommonManager.Instance.ExecuteNonQuery(str1Query, "A2ZCSCUBS")); return(p); } p.CtrlRecType = 0; return(p); }