public void CreateAccounts(string BrCode, string CustNo, string PrCode, string EDate, string Mid)
{
try
{
sql = "Select Rec_Prd From AVS_RS Where AccOpen = 'Y' And Rec_Prd <> '" + PrCode + "'";
DT = conn.GetDatatable(sql);
if (DT.Rows.Count > 0)
{
for (int i = 0; i < DT.Rows.Count; i++)
{
GlCode = ""; AccNo = "";
sql = "Select GlCode From GlMast Where BrCd = '" + BrCode + "' And SubGlCode = '" + DT.Rows[i]["Rec_Prd"].ToString() + "' ";
GlCode = conn.sExecuteScalar(sql);
if (GlCode == "2")
{
sql = "Select (Case When LastNo Is Null Then 1 Else (LastNo+1) End) LastNo From GlMast Where BrCd = '" + BrCode + "' And GlCode = '" + GlCode + "' And SubGlCode = '" + DT.Rows[i]["Rec_Prd"].ToString() + "' ";
}
else
{
sql = "Select (Case When LastNo Is Null Then 1 Else (LastNo+1) End) LastNo From GlMast Where BrCd = '" + BrCode + "' And SubGlCode = '" + DT.Rows[i]["Rec_Prd"].ToString() + "' ";
}
AccNo = conn.sExecuteScalar(sql);
if (Convert.ToDouble(AccNo.ToString()) > 0)
{
sql = "Insert Into Avs_Acc(BrCd, GlCode, SubGlCode, CustNo, AccNo, OpeningDate, Acc_Status, Stage, Mid, PcMac, Acc_Type, Opr_Type, SystemDate) " +
"Values('" + BrCode + "', '" + GlCode + "', '" + DT.Rows[i]["Rec_Prd"].ToString() + "', '" + CustNo + "', '" + AccNo + "', '" + conn.ConvertDate(EDate).ToString() + "', '1', '1001', '" + Mid + "','" + conn.PCNAME() + "', '1', '1', GetDate())";
Result = conn.sExecuteQuery(sql);
if (Result > 0)
{
if (GlCode == "2")
{
sql = "Update GlMast Set LastNo = '" + Convert.ToInt32(AccNo) + "' Where BrCd = '" + BrCode + "' And GlCode = '" + GlCode + "' And SubGlCode = '" + DT.Rows[i]["Rec_Prd"].ToString() + "'";
}
else
{
sql = "Update GlMast Set LastNo = '" + Convert.ToInt32(AccNo) + "' Where BrCd = '" + BrCode + "' And SubGlCode = '" + DT.Rows[i]["Rec_Prd"].ToString() + "'";
}
Result = conn.sExecuteQuery(sql);
}
}
}
}
}
catch (Exception Ex)
{
ExceptionLogging.SendErrorToText(Ex);
}
}
public void CreateAccounts(string BrCode, string CustNo, string PrCode, string EDate, string Mid)
{
try
{
sql = "Select IsNull(IntAccYN, 'N') As IntAccYN From GlMast Where BrCd = '" + BrCode + "' And SubGlCode = '" + PrCode + "'";
sResult = conn.sExecuteScalar(sql);
if (sResult.ToString() == "Y")
{
sql = "Select GlCode From GlMast Where BrCd = '" + BrCode + "' And SubGlCode = '" + PrCode + "' ";
GlCode = conn.sExecuteScalar(sql);
if (Convert.ToDouble(GlCode) > 0)
{
sql = "Select (Case When LastNo Is Null Then 1 Else (LastNo+1) End) LastNo From GlMast Where BrCd = '" + BrCode + "' And SubGlCode = '" + PrCode + "' ";
AccNo = conn.sExecuteScalar(sql);
if (Convert.ToDouble(AccNo.ToString()) > 0)
{
sql = "Insert Into Avs_Acc(BrCd, GlCode, SubGlCode, CustNo, AccNo, OpeningDate, Acc_Status, Stage, Mid, PcMac, Acc_Type, Opr_Type, SystemDate) " +
"Values('" + BrCode + "', '" + GlCode + "', '" + PrCode + "', '" + CustNo + "', '" + AccNo + "', '" + conn.ConvertDate(EDate).ToString() + "', '1', '1003', '" + Mid + "','" + conn.PCNAME() + "', '1', '1', GetDate())";
Result = conn.sExecuteQuery(sql);
if (Result > 0)
{
sql = "Update GlMast Set LastNo = '" + Convert.ToInt32(AccNo) + "' Where BrCd = '" + BrCode + "' And SubGlCode = '" + PrCode + "'";
Result = conn.sExecuteQuery(sql);
}
}
}
}
}
catch (Exception Ex)
{
ExceptionLogging.SendErrorToText(Ex);
}
}