public List <COA> GetDonationReserveCOAList(string value_date, string inst_code) { List <COA> result = new List <COA>(); var ds = GetDonationReserveSummary(value_date, inst_code); var last_coa = new COA(); foreach (var dr in ds) { if (dr.Hospital != last_coa.Hospital || dr.Fund != last_coa.Fund || dr.Section != last_coa.Section || dr.Analytical != last_coa.Analytical) { COA new_coa = new COA(); new_coa.Hospital = dr.Hospital; new_coa.Fund = dr.Fund; new_coa.Section = dr.Section; new_coa.Analytical = dr.Analytical; result.Add(new_coa); last_coa.Hospital = dr.Hospital; last_coa.Fund = dr.Fund; last_coa.Section = dr.Section; last_coa.Analytical = dr.Analytical; } } return(result); }
// PUT api/ochatofaccount/5 public static RTNMANVAL Put(string id, [FromBody] COA value) { RTNMANVAL returnVal = null; SAPbobsCOM.Company oCompany = null; string newKey = ""; try { oCompany = Company.GetCompany(Properties.Settings.Default.StrDbServer, Properties.Settings.Default.StrDbUserName, Properties.Settings.Default.StrDbPassword, Properties.Settings.Default.StrDbName, Properties.Settings.Default.StrSapB1UserName, Properties.Settings.Default.StrSapB1Password, Properties.Settings.Default.StrSapB1LicenseServer); newKey = Logic.SAP.SAP_COA.update(oCompany, value, id); returnVal = new RTNMANVAL() { errorCode = "0", message = "Data has beed updated", value = id }; } catch (Exception e) { returnVal = new RTNMANVAL() { errorCode = "-1", message = e.Message.ToString() }; } return(returnVal); }
public static List <COA> GetCOA() { var dbUtil = new DatabaseManager(); var rfcoas = new List <COA>(); using (var conn = new SqlConnection(dbUtil.getSQLConnectionString("MainDB"))) { conn.Open(); using (SqlCommand cmd = conn.CreateCommand()) { cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = "spDisGetPCFCOA"; cmd.CommandTimeout = 180; using (SqlDataReader reader = cmd.ExecuteReader()) { while (reader.Read()) { var rfcoa = new COA { COAID = ReferenceEquals(reader["intCOAID"], DBNull.Value) ? 0 : Convert.ToInt32(reader["intCOAID"]), Description = ReferenceEquals(reader["strDescription"], DBNull.Value) ? string.Empty : Convert.ToString(reader["strDescription"]), Code = ReferenceEquals(reader["strCode"], DBNull.Value) ? string.Empty : Convert.ToString(reader["strCode"]), AccountSide = ReferenceEquals(reader["strAccountSide"], DBNull.Value) ? string.Empty : Convert.ToString(reader["strAccountSide"]) }; rfcoas.Add(rfcoa); } } } } return(rfcoas); }
/// <summary> /// 创建分录 /// </summary> /// <param name="reNum"></param> /// <param name="reType"></param> private void CreateDistribution(string reNum, string reType) { DbHelper db = new DbHelper(true); try { COA c = new COA(db); ArrayList al = c.Generate_Distribution(reNum, reType); string strType = "R"; if (reType == "UD") { strType = "U"; } db.ExecuteNonQuery("delete from AR_Line_Distribution where TRANSACTION_NO='" + reNum + "' and TRANSACTION_TYPE='" + strType + "' and post_status<>'P'"); c.Insert_Distribution(al); db.Commit(); } catch (Exception err) { db.Abort(); throw err; } }
public static string update(Company oCompany, COA model, string AcctCode) { SAPbobsCOM.ChartOfAccounts oObject; RTNMANVAL rtn = new RTNMANVAL(); int errCode; string errMessage, strResult = ""; try { oCompany.StartTransaction(); oObject = oCompany.GetBusinessObject(BoObjectTypes.oChartOfAccounts); oObject.GetByKey(AcctCode); oObject.Name = model.AccountName; oObject.AcctCurrency = model.AccountCurrency; if (model.AccountType == "Revenues") { oObject.AccountType = BoAccountTypes.at_Revenues; } else if (model.AccountType == "Expenses") { oObject.AccountType = BoAccountTypes.at_Expenses; } else { oObject.AccountType = BoAccountTypes.at_Other; } oObject.FatherAccountKey = model.FatherAccount; int statusCOA = oObject.Update(); if (statusCOA == 0) { oCompany.EndTransaction(BoWfTransOpt.wf_Commit); if (strResult == "") { strResult = oCompany.GetNewObjectKey(); } else { strResult = strResult + "," + oCompany.GetNewObjectKey(); } } else { if (oCompany.InTransaction) { oCompany.EndTransaction(BoWfTransOpt.wf_RollBack); } oCompany.GetLastError(out errCode, out errMessage); throw new Exception("Error Code : " + errCode + " | Error Message : " + errMessage); } } catch (Exception e) { if (oCompany.InTransaction) { oCompany.EndTransaction(BoWfTransOpt.wf_RollBack); } ; throw; } return(strResult); }
/// <summary> /// Function for Printing a COA Report. This function will take COA no as parameter. /// Created By: Lalit /// Created Date: 25july 2013 /// </summary> public string PrintCOA(Stream COA) { string File = ""; string[] Ht = new string[2]; try { COA _ObjCOA = new COA(); _ObjCOA = JsonHelper.DeserializeObj <COA>(COA); _Obj_Conn.ConnectionString = con.ConnectionString; string _COANo = _ObjCOA.COANo; cmd = new SqlCommand(); cmd.Connection = _Obj_Conn; _Obj_Conn.Open(); string str = @"Select a.vryr + a.CoaNo as CoaNo, a.CoaDate, a.SoNo, a.InvNO, a.FType, a.Thickness, a.Coapr, a.CoasPr, a.TestM, a.Units, a.Typical, a.Tmin, a.Tmax, a.REmarks, o.CustomerOrderNo, c.Name, f.FilmTypeName, a.ChkSno from tblcoa as a Inner Join dbo.Sal_Glb_OrderInformations o on a.Sono = o.sono Inner Join Sal_Glb_Customer_Mst c on o.SOCustomer = c.CustomerId Inner Join Com_FilmType_Mst f on a.FType = f.FilmTypeCode Where a.CoaNo = '" + _COANo + "' order by a.autoid"; _Obj_SDA = new SqlDataAdapter(str, _Obj_Conn); int i = _Obj_SDA.Fill(dsCOA, "COA"); if (i > 0) { int sno = 0; for (int jj = 0; jj < dsCOA.Tables["COA"].Rows.Count; jj++) { if (dsCOA.Tables["COA"].Rows[jj]["COAPR"].ToString().Trim().Length > 0 && Convert.ToBoolean(dsCOA.Tables["COA"].Rows[jj]["ChkSno"])) { sno += 1; dsCOA.Tables["COA"].Rows[jj]["Remarks"] = sno.ToString(); } if (dsCOA.Tables["COA"].Rows[jj]["COAPR"].ToString().Trim() == "Average Gauge Micron/Gauge") { if (dsCOA.Tables["COA"].Rows[jj]["Typical"].ToString() != "") { int xGa = Convert.ToInt32((Convert.ToDouble(dsCOA.Tables["COA"].Rows[jj]["Typical"].ToString()) * 4)); string xyz = dsCOA.Tables["COA"].Rows[jj]["Typical"].ToString().Trim() + "/" + xGa.ToString(); dsCOA.Tables["COA"].Rows[jj]["Typical"] = xyz; } } if (dsCOA.Tables["COA"].Rows[jj]["COAPR"].ToString().Trim() == "Tensile Strength") { if (dsCOA.Tables["COA"].Rows[jj]["Typical"].ToString() != "") { decimal xts = Convert.ToInt32((Convert.ToDouble(dsCOA.Tables["COA"].Rows[jj]["Typical"].ToString()) * 0.0142234)); string xyz = dsCOA.Tables["COA"].Rows[jj]["Typical"].ToString().Trim() + "/" + xts.ToString(); dsCOA.Tables["COA"].Rows[jj]["Typical"] = xyz; } } } dsCOA.Tables["COA"].AcceptChanges(); } if (dsCOA.Tables["COA"].Rows.Count > 0) { rptDoc.Close(); rptDoc.Load(ReportpathCoa); rptDoc.SetDataSource(dsCOA); ExportOptions exportOpts = new ExportOptions(); PdfRtfWordFormatOptions pdfOpts = ExportOptions.CreatePdfRtfWordFormatOptions(); exportOpts.ExportFormatType = ExportFormatType.PortableDocFormat; exportOpts.ExportFormatOptions = pdfOpts; _FlName = Guid.NewGuid().ToString() + ".pdf"; rptDoc.ExportToDisk(ExportFormatType.PortableDocFormat, (FileToSavepath + _FlName)); Ht[0] = FileAccessPath; Ht[1] = _FlName; File = JsonHelper.JsonSerializer <string[]>(Ht); rptDoc.Dispose(); } _Obj_Conn.Close(); _Obj_Conn.Dispose(); _Obj_SDA.Dispose(); cmd.Dispose(); dsCOA.Dispose(); } catch (Exception ex) { } return(File); }