/// <summary>
/// 判断是否可以反结账结账
/// </summary>
/// <returns></returns>
/// <remarks>
///
/// </remarks>
public string isFinish(string repDate, string status)
{
int count = 0;
ExceResult res = new ExceResult();
string CId = CompanyId();
List <Co_Tr_ThirdAccount> rep = new List <Co_Tr_ThirdAccount>();
rep = new IESvc().isFinish(repDate, status, out count, CId);
string msg = string.Empty;
bool result = false;
if (rep.Count == 0)
{
msg = General.Resource.Common.Success;
result = true;
}
else
{
msg = General.Resource.Common.Failed;
result = false;
}
return(string.Format("{{\"Result\":{0},\"Msg\":\"{1}\"}}"
, result.ToString().ToLower(), msg));
}
public string CreateTaxSettlement(string repDate, string Amount, string Rep_status, string GUID, string Flag, string State)
{
bool result = false;
ExceResult res = new ExceResult();
string msg = string.Empty;
if (string.IsNullOrEmpty(GUID))
{
GUID = Guid.NewGuid().ToString();
}
string C_GUID = Session["CurrentCompanyGuid"].ToString();
result = new IESvc().CreateTaxSettlement(GUID, repDate, Amount, Rep_status, C_GUID, Flag, State, "非期初");
if (result)
{
res.success = true;
msg = General.Resource.Common.Success;
}
else
{
res.success = false;
msg = General.Resource.Common.Failed;
}
return(Newtonsoft.Json.JsonConvert.SerializeObject(res));
}
public String CreateTaxRecord(List <T_IERecord> TaxList)
{
bool result = false;
ExceResult res = new ExceResult();
string msg = string.Empty;
foreach (T_IERecord form in TaxList)
{
form.C_GUID = Session["CurrentCompanyGuid"].ToString();
form.Creator = base.userData.LoginFullName;
form.Currency = Session["Currency"].ToString();
if (form.IEGroup == "增值税")
{
form.IE_Flag = "E";
}
result = new IESvc().UpdVoucherFL(form, "NV");
if (result)
{
msg = General.Resource.Common.Success;
}
else
{
msg = General.Resource.Common.Failed;
}
}
return(string.Format("{{\"Result\":{0},\"Msg\":\"{1}\"}}"
, result.ToString().ToLower(), msg));
}
public string UpdWcRecord(string id, decimal total, string Currency, string name, string RPType, string Profit_Name)
{
bool result = false;
ExceResult res = new ExceResult();
string msg = string.Empty;
T_WageCost wag = new T_WageCost();
wag.PayType = RPType;
wag.C_GUID = Session["CurrentCompanyGuid"].ToString();
wag.W_GUID = id;
wag.Total = total;
wag.Currency = Currency;
wag.Employee = name;
wag.Date = DateTime.Now;
wag.State = "未付";
wag.Profit_Name = Profit_Name;
wag.SalaryType = 1;
string strVouchID = Guid.NewGuid().ToString();
result = new IESvc().UpdWageCost(wag, strVouchID);
if (result)
{
res.success = true;
msg = General.Resource.Common.Success;
}
else
{
res.success = false;
msg = General.Resource.Common.Failed;
}
return(JsonConvert.SerializeObject(res));
}
/// <summary>
/// 更新费用数据
/// </summary>
/// <param name="head">费用主数据</param>
/// <param name="list">费用明细数据</param>
/// <returns></returns>
public string UpdTaxProvisionRecord(T_IERecord form)
{
bool result = false;
string msg = string.Empty;
form.C_GUID = Session["CurrentCompanyGuid"].ToString();
form.Creator = base.userData.LoginFullName;
form.CreateDate = GetNowDate();
if (form.IEGroup == "ac23eded-9c74-4781-8d14-797a5bccdc79" || form.IEGroup == "234218e9-87c5-4854-814a-7d5671bf1fd9" || form.IEGroup == "8e777b91-f3f9-4907-ba1a-2e0842967500")
{
form.Profit_GUID = "51BFDD3E-2253-4FBF-A946-19C18C25C6FC";
}
if (form.IEGroup == "d136bf9c-c3a3-4f33-ab1e-820526dcbc24")
{
form.Profit_GUID = "082CD9EB-9947-43C4-A7C6-F2B7FAB6EE54";
}
result = new IESvc().UpdExpenseRecord(form);
if (result)
{
msg = General.Resource.Common.Success;
}
else
{
msg = General.Resource.Common.Failed;
}
return(string.Format("{{\"Result\":{0},\"Msg\":\"{1}\"}}"
, result.ToString().ToLower(), msg));
}
public string GetSalaryCollectByID(string strPar)
{
string C_GUID = Session["CurrentCompanyGuid"].ToString();
List <T_WageCost> wageCollectList = new List <T_WageCost>();
wageCollectList = new IESvc().GetSalaryCollectById(strPar);
return(new JavaScriptSerializer().Serialize(wageCollectList));
}
/// <summary>
/// 获取一级费用科目分类的成本与费用比较
/// </summary>
/// <returns></returns>
///
public string GetOnceClassifyCompareList(string InvType, string dateBegin, string dateEnd)
{
string C_GUID = Session["CurrentCompanyGuid"].ToString();
List <T_IERecord> Record = new List <T_IERecord>();
Record = new IESvc().GetOnceClassifyCompareList(InvType, C_GUID, dateBegin, dateEnd);
return(new JavaScriptSerializer().Serialize(Record));
}
public string GetIEVoucher(string rows, string page, string IE_GUID)
{
int count = 0;
List <T_IERecord> List = new IESvc().GetVoucher(1, -1, out count, IE_GUID, "I");
string json = new JavaScriptSerializer().Serialize(List);
return(json);
}
/// <summary>
/// 获取已结转增值税数据
/// </summary>
/// <returns></returns>
/// <remarks>
/// </remarks>
public string GetTaxReportIsend(string reportDate, string period, string isend)
{
string CId = CompanyId();
List <Co_Tr_ThirdAccount> lst = IESvc.GetTaxReportIsend(CId, reportDate, period, isend);
return(JsonConvert.SerializeObject(lst));
}
public string GetDetailZZHShui(string strPar)
{
string C_GUID = Session["CurrentCompanyGuid"].ToString();
List <T_DetailTaxSettle> TaxDetailList = new List <T_DetailTaxSettle>();
TaxDetailList = new IESvc().GetDetailZZHShui(strPar);
return(new JavaScriptSerializer().Serialize(TaxDetailList));
}
public string GetTaxDetailInfoByRecID(string strPar, string taskDetailID)
{
string C_GUID = Session["CurrentCompanyGuid"].ToString();
List <T_DetailTaxSettle> TaxDetailList = new List <T_DetailTaxSettle>();
TaxDetailList = new IESvc().GetDetailTaxByRecID(strPar, taskDetailID);
return(new JavaScriptSerializer().Serialize(TaxDetailList));
}
public string GetIETaxList(string Flag, string MounthDate)
{
string C_GUID = Session["CurrentCompanyGuid"].ToString();
List <T_IERecord> IERcord = new List <T_IERecord>();
IERcord = new IESvc().GetIETaxList(Flag, MounthDate, C_GUID);
return(new JavaScriptSerializer().Serialize(IERcord));
}
public string GetTaxSettlement(string repDate, string Flag)
{
string C_GUID = Session["CurrentCompanyGuid"].ToString();
List <T_TaxSettlement> TaxSetList = new List <T_TaxSettlement>();
TaxSetList = new IESvc().GetTaxSettlement(repDate, C_GUID, Flag);
return(new JavaScriptSerializer().Serialize(TaxSetList));
}
/// <summary>
/// 获取增值税
/// </summary>
/// <returns></returns>
/// <remarks>
/// </remarks>
public string GetTaxReportList(string reportDate, string type)
{
string CId = CompanyId();
List <Co_Tr_ThirdAccount> lst = IESvc.GetTaxReportList(CId, reportDate, type);
return(JsonConvert.SerializeObject(lst));
}
public string GetComIETaxList(string Year, string Quarter)
{
string C_GUID = Session["CurrentCompanyGuid"].ToString();
List <T_IERecord> IERcord = new List <T_IERecord>();
IERcord = new IESvc().GetComIETaxList(Year, Quarter, C_GUID);
return(new JavaScriptSerializer().Serialize(IERcord));
}
public string GetIncomeRecord(string id)
{
string C_GUID = Session["CurrentCompanyGuid"].ToString();
T_IERecord rec = new IESvc().GetIE(id, C_GUID);
string json = new JavaScriptSerializer().Serialize(rec);
return(json);
}
/// <summary>
/// 获取营业税子类别特殊类别
/// </summary>
/// <param name="repDate"></param>
/// <param name="Flag"></param>
/// <returns></returns>
public string GetSalesTaxDetail(string name)
{
string C_GUID = Session["CurrentCompanyGuid"].ToString();
List <T_DetailedAccount> TaxSetList = new List <T_DetailedAccount>();
TaxSetList = new IESvc().GetSalesTaxDetail(C_GUID, name);
return(new JavaScriptSerializer().Serialize(TaxSetList));
}
public string CreatTaxSettlement(List <T_TaxSettlement> TaxList)
{
bool result = false;
ExceResult res = new ExceResult();
string msg = string.Empty;
string Flag = null;
string C_GUID = Session["CurrentCompanyGuid"].ToString();
using (TransactionScope scope = new TransactionScope(TransactionScopeOption.Required))
{
foreach (T_TaxSettlement tax in TaxList)
{
if (string.IsNullOrEmpty(tax.GUID))
{
tax.GUID = Guid.NewGuid().ToString();
}
switch (tax.Flag)
{
case "增值税":
Flag = "TA";
break;
case "营业税金及附加":
Flag = "YT";
break;
case "所得税费用":
Flag = "CT";
break;
case "个人所得税":
Flag = "SA";
break;
default:
break;
}
result = new IESvc().CreateTaxSettlement(tax.GUID, tax.Rep_date, tax.Amount.ToString(), tax.Rep_status, C_GUID, Flag, tax.State, "期初");
}
if (result)
{
scope.Complete();
}
}
if (result)
{
res.success = true;
msg = General.Resource.Common.Success;
}
else
{
res.success = false;
msg = General.Resource.Common.Failed;
}
return(Newtonsoft.Json.JsonConvert.SerializeObject(res));
}
/// <summary>
/// 获取收入纪录列表数据
/// </summary>
/// <param name="page">页索引</param>
/// <param name="rows">页大小</param>
/// <returns></returns>
public string CancelIncomeList(string page, string rows, string dateBegin, string dateEnd, string customer, string state, string incomeGrp)
{
int count = 0;
List <T_IERecord> recs = new IESvc().GetAllExpenseList(Session["CurrentCompanyGuid"].ToString(), int.Parse(page), int.Parse(rows), out count,
dateBegin, dateEnd, customer, state, incomeGrp);
return(string.Format("{{\"count\":{0},\"rows\":{1}}}",
count, new JavaScriptSerializer().Serialize(recs)));
}
public string GetIEVoucher(string rows, string page, string IE_GUID)
{
string C_GUID = Session["CurrentCompanyGuid"].ToString();
int count = 0;
List <T_IERecord> List = new IESvc().GetVoucher(1, -1, out count, IE_GUID, "E");
string json = new JavaScriptSerializer().Serialize(List);
return(json);
}
public String GetIERecord(string rows, string page, string id)
{
string C_GUID = Session["CurrentCompanyGuid"].ToString();
int count = 0;
List <T_IERecord> DC = new List <T_IERecord>();
DC = new IESvc().GetIERecord(1, -1, out count, id, C_GUID);
return(new JavaScriptSerializer().Serialize(DC));
}
/// <summary>
/// 查询供应商成本与费用汇总
/// </summary>
/// <returns></returns>
public string GetSupplierTotalCollectList(int pageIndex = 1, int pageSize = 10)
{
int count = 0;
string C_GUID = Session["CurrentCompanyGuid"].ToString();
List <T_IERecord> Record = new List <T_IERecord>();
Record = new IESvc().GetSupplierTotalCollectList(C_GUID, pageIndex, -1, out count);
return(new JavaScriptSerializer().Serialize(Record));
}
public string UpdWageCostsRecord(string id, string rper, decimal money, decimal money1, decimal money2, decimal money3, string invtype, string remark, string currency, string addstyle, DateTime date)
{
bool result = false;
string msg = string.Empty;
T_IERecord Record = new T_IERecord();
Record.Creator = base.userData.LoginFullName;
Record.C_GUID = Session["CurrentCompany"].ToString();
Record.IE_GUID = id;
Record.RPer = rper;
Record.AffirmDate = date;
Record.Date = date;
Record.SumAmount = money;
Record.InvType = invtype;
Record.IEGroup = "1544d862-b1ab-42b8-9e97-9c2e1704665c";//工资类别guid
Record.Remark = remark;
Record.Currency = currency;
Record.CreateDate = DateTime.Now;
Record.TaxationAmount = 0;
Record.TaxationType = "";
Record.State = "应付";
Record.Profit_GUID = "51BFDD3E-2253-4FBF-A946-19C18C25C6FC";
T_WageCost WageCostRecord = new T_WageCost();
WageCostRecord.W_GUID = id;
WageCostRecord.C_GUID = Session["CurrentCompany"].ToString();
WageCostRecord.Date = date;
WageCostRecord.Employee = remark;
WageCostRecord.Cash = money1;
WageCostRecord.PersonalTaxes = money2;
WageCostRecord.SocialSecurity = money3;
WageCostRecord.Total = money1 + money2 + money3;
new IESvc().UpdWageCost(WageCostRecord);
DateTime EditThreshold = DateTime.Parse(Session["EditThreshold"].ToString());
if (Record.Date <= DateTime.Now && Record.Date >= EditThreshold)
{
result = new IESvc().UpdExpenseRecord(Record);
if (result)
{
msg = General.Resource.Common.Success;
}
else
{
msg = General.Resource.Common.Failed;
}
}
else
{
result = false;
msg = FMS.Resource.Finance.Finance.DateError;
}
return(string.Format("{{\"Result\":{0},\"Msg\":\"{1}\"}}"
, result.ToString().ToLower(), msg));
}
/// <summary>
/// 获取二级费用科目分类的成本与费用汇总行
/// </summary>
/// <returns></returns>
public string GetSecondClassifyTotalCollectList(string IEGroup, string dateBegin, string dateEnd, int pageIndex = 1, int pageSize = 10)
{
int count = 0;
string C_GUID = Session["CurrentCompanyGuid"].ToString();
List <T_IERecord> Record = new List <T_IERecord>();
Record = new IESvc().GetSecondClassifyTotalCollectList(IEGroup, dateBegin, dateEnd, C_GUID, pageIndex, -1, out count);
return(new JavaScriptSerializer().Serialize(Record));
}
/// <summary>
/// 20180622 zm添加，获取工资明细
/// </summary>
/// <param name="rows"></param>
/// <param name="page"></param>
/// <param name="state"></param>
/// <param name="id"></param>
/// <returns></returns>
public string GetWageCostInfonew(string SalaryName, string Name)
{
string C_GUID = Session["CurrentCompanyGuid"].ToString();
StringBuilder strJson = new StringBuilder();
List <T_DetailSalary> List = new List <T_DetailSalary>();
List = new IESvc().GetWageCostInfonew(C_GUID, SalaryName, Name);
return(new JavaScriptSerializer().Serialize(List));
}
/// <summary>
/// 获取应收款列表数据
/// </summary>
/// <param name="page">页索引</param>
/// <param name="rows">页大小</param>
/// <returns></returns>
public string GetReceivableList(string page, string rows)
{
int count = 0;
string strFormatter = "{{\"total\":\"{0}\",\"rows\":{1}}}";
StringBuilder strJson = new StringBuilder();
List <T_IERecord> recs = new IESvc().GetReceivableList(Session["CurrentCompanyGuid"].ToString(), int.Parse(page), int.Parse(rows), out count);
strJson.AppendFormat(strFormatter, count, new JavaScriptSerializer().Serialize(recs));
return(strJson.ToString());
}
public string GetWageCostList(string rows, string page, string state, string id)
{
int count = 0;
string C_GUID = Session["CurrentCompanyGuid"].ToString();
StringBuilder strJson = new StringBuilder();
List <T_WageCost> List = new List <T_WageCost>();
List = new IESvc().GetWageCost(C_GUID, 1, -1, out count, state, id);
return(new JavaScriptSerializer().Serialize(List));
}
/// <summary>
/// 获取费用列表数据
/// </summary>
/// <param name="page">页索引</param>
/// <param name="rows">页大小</param>
/// <returns></returns>
public string GetExpenseList(string page, string rows, string dateBegin, string dateEnd, string customer, string state, string incomeGrp, string IncomeGrpDts)
{
int count = 0;
StringBuilder strJson = new StringBuilder();
string strFormatter = "{{\"total\":\"{0}\",\"rows\":{1}}}";
List <T_IERecord> recs = new IESvc().GetAllExpenseList(Session["CurrentCompany"].ToString(), int.Parse(page), int.Parse(rows), out count, dateBegin, dateEnd, customer, state, incomeGrp, IncomeGrpDts);
strJson.AppendFormat(strFormatter, count, new JavaScriptSerializer().Serialize(recs));
return(strJson.ToString());
}
public string GetDetailTaxList(string AffirmDate, string period)
{
int count = 0;
StringBuilder strJson = new StringBuilder();
List <T_DetailTaxSettle> List = new IESvc().GetDetailTaxList(Session["CurrentCompanyGuid"].ToString(), 1, -1, out count, AffirmDate, period);
string json = new JavaScriptSerializer().Serialize(List);
return(json);
}
/// <summary>
/// 获取收入纪录列表数据Bootstraptable
/// </summary>
/// <param name="page">页索引</param>
/// <param name="rows">页大小</param>
/// <returns></returns>
public string GetIncomeList_Bootstraptable(string dateBegin, string dateEnd, string zdateBegin, string zdateEnd, string customer, string state, string incomeGrp, string currency, string business_GUID, string subBusiness_GUID, string TaxationGUID, string MounthDate)
{
int count = 0;
StringBuilder strJson = new StringBuilder();
//string strFormatter = "{{\"total\":\"{0}\",\"rows\":{1}}}";//"{{\"count\":{0},\"rows\":{1}}}"
List <T_IERecord> List = new IESvc().GetAllIncomeList(Session["CurrentCompanyGuid"].ToString(), 1, -1, out count, dateBegin, dateEnd, zdateBegin, zdateEnd, customer, state, incomeGrp, currency, business_GUID, subBusiness_GUID, TaxationGUID, MounthDate);
string json = new JavaScriptSerializer().Serialize(List);
return(json);
}
