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