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