/// <summary>
/// SaveStatisticalCallsRecord
/// </summary>
/// <param name="model"></param>
public void SaveStatisticalCallsRecord(StatisticalCallsRecordModel model)
{
CurrentConnectStringContext.StoredProcedure("FinancialData_StatisticalCallsRecord_Save_V2")
.Parameter("v_ActionName", model.ActionName)
.Parameter("v_CreateDateTime", model.CreateDateTime)
.Parameter("v_IPAddress", model.IpAddress)
.Parameter("v_SessionId", model.SessionId)
.Execute();
}
/// <summary>
/// SaveExcelRecord
/// </summary>
/// <returns></returns>
public int SaveExcelRecord(ExcelRecordModel model)
{
return(CurrentConnectStringContext.StoredProcedure("Excelrecord_Save")
.Parameter("v_ExcelRecordId", model.ExcelRecordId)
.Parameter("v_ExcelName", model.ExcelName)
.Parameter("v_CreateDateTime", model.CreateDateTime)
.Parameter("v_ExcelUrl", model.ExcelUrl)
.Parameter("v_StatusFlag", model.StatusFlag)
.QuerySingle <int>());
}
public int SaveArea(Area dataModel)
{
return(CurrentConnectStringContext.StoredProcedure("Financialdataanalysis_SP_Area_Save")
.Parameter("v_AreaId", dataModel.AreaId)
.Parameter("v_AreaName", dataModel.AreaName)
.Parameter("v_UserId", dataModel.UserId)
.Parameter("v_CreateDateTime", dataModel.CreateDateTime)
.Parameter("v_UpdateDateTime", dataModel.UpdateDateTime)
.QuerySingle <int>());
}
/// <summary>
/// GetFinancialDataByFilter
/// </summary>
/// <param name="filter"></param>
/// <returns></returns>
public List <FinancialDataModel> GetFinancialDataByFilter(FinancialDataModel filter)
{
return(CurrentConnectStringContext.StoredProcedure("FinancialData_GetByFilter")
.Parameter("v_ExcelRecordId", filter.ExcelRecordId)
.Parameter("v_XiangMuIdId", filter.XiangMuIdId)
.Parameter("v_XingZhiId", filter.XingZhiId)
.Parameter("v_PianQuId", filter.PianQuId)
.Parameter("v_ShiYeBuId", filter.ShiYeBuId)
.Parameter("v_AccountCode", filter.AccountCode)
.Parameter("v_QiJianTypeId", filter.QiJianTypeId)
.QueryMany <FinancialDataModel>());
}
public int SaveCompany(Company dataModel)
{
return(CurrentConnectStringContext.StoredProcedure("Financialdataanalysis_SP_Company_Save")
.Parameter("v_CompanyId", dataModel.CompanyId)
.Parameter("v_AreaId", dataModel.AreaId)
.Parameter("v_CompanyName", dataModel.CompanyName)
.Parameter("v_ArtificialPerson", dataModel.ArtificialPerson)
.Parameter("v_SetUpTime", dataModel.SetUpTime)
.Parameter("v_CompanyPhone", dataModel.CompanyPhone)
.Parameter("v_Address", dataModel.Address)
.Parameter("v_CreateDateTime", dataModel.CreateDateTime)
.Parameter("v_UpdateDateTime", dataModel.UpdateDateTime)
.QuerySingle <int>());
}
/// <summary>
/// GetFinancialDataByPaging
/// </summary>
/// <param name="request"></param>
/// <param name="totalCount"></param>
/// <returns></returns>
public List <GetFinancialDataByPagingResponse> GetFinancialDataByPaging(GetFinancialDataByPagingRequest request, out int totalCount)
{
var store = CurrentConnectStringContext.StoredProcedure("FinancialData_GetDetailByPaging")
.Parameter("v_ExcelRecordId", request.ExcelRecordId)
.Parameter("v_AccountCode", request.AccountCode)
.Parameter("v_QiJianTypeId", request.QiJianTypeId)
.Parameter("v_XiangMuTypeId", request.XiangMuTypeId)
.Parameter("v_XiangMuItemId", request.XiangMuItemId)
.Parameter("v_PageIndex", request.Page)
.Parameter("v_PageSize", request.Limit)
.ParameterOut("v_TotalCount", DataTypes.Int32);
var result = store.QueryMany <GetFinancialDataByPagingResponse>();
totalCount = store.ParameterValue <int>("v_TotalCount");
return(result);
}
public int SaveCompanyConnectRecord(CompanyConnectRecord dataModel)
{
return(CurrentConnectStringContext.StoredProcedure("Financialdataanalysis_SP_Companyconnectrecord_Save")
.Parameter("v_CompanyConnectRecordId", dataModel.CompanyConnectRecordId)
.Parameter("v_CompanyId", dataModel.CompanyId)
.Parameter("v_PhoneConnectDate", dataModel.PhoneConnectDate)
.Parameter("v_CompanyState", dataModel.CompanyState)
.Parameter("v_IsValidateAddress", dataModel.IsValidateAddress)
.Parameter("v_ConfirmAddress", dataModel.ConfirmAddress)
.Parameter("v_GoHomePerson", dataModel.GoHomePerson)
.Parameter("v_GoHomeTime", dataModel.GoHomeTime)
.Parameter("v_PhoneConnectState", dataModel.PhoneConnectState)
.Parameter("v_CooperationIntention", dataModel.CooperationIntention)
.Parameter("v_CreateDateTime", dataModel.CreateDateTime)
.Parameter("v_UpdateDateTime", dataModel.UpdateDateTime)
.QuerySingle <int>());
}
/// <summary>
/// GetFinancialDataItemByExcelRecordId
/// </summary>
/// <param name="excelRecordId"></param>
/// <returns></returns>
public List <FinancialDataItemModel> GetFinancialDataItemByExcelRecordId(int excelRecordId)
{
return(CurrentConnectStringContext.StoredProcedure("FinancialDataItem_GetByExcelRecordId")
.Parameter("v_ExcelRecordId", excelRecordId)
.QueryMany <FinancialDataItemModel>());
}
public List <Area> GetAllArea()
{
return(CurrentConnectStringContext.StoredProcedure("Financialdataanalysis_SP_Area_ReadAll")
.QueryMany <Area>());
}
public Area GetAreaByKey(int areaId)
{
return(CurrentConnectStringContext.StoredProcedure("Financialdataanalysis_SP_Area_ReadByKey")
.Parameter("v_AreaId", areaId)
.QuerySingle <Area>());
}
public void DeleteCompanyconnectrecordByCompanyId(int companyConnectRecordId)
{
CurrentConnectStringContext.StoredProcedure("Financialdataanalysis_SP_Companyconnectrecord_Delete")
.Parameter("v_CompanyConnectRecordId", companyConnectRecordId)
.Execute();
}
public List <CompanyConnectRecord> GetCompanyconnectrecordByCompanyId(int companyId)
{
return(CurrentConnectStringContext.StoredProcedure("Financialdataanalysis_SP_Companyconnectrecord_ReadByCompanyId")
.Parameter("v_CompanyId", companyId)
.QueryMany <CompanyConnectRecord>());
}
public CompanyConnectRecord GetCompanyconnectrecordByKey(int companyConnectRecordId)
{
return(CurrentConnectStringContext.StoredProcedure("Financialdataanalysis_SP_Companyconnectrecord_ReadByKey")
.Parameter("v_CompanyConnectRecordId", companyConnectRecordId)
.QuerySingle <CompanyConnectRecord>());
}
public List <Company> GetCompanyByAreaId(int areaId)
{
return(CurrentConnectStringContext.StoredProcedure("Financialdataanalysis_SP_Company_ReadByAreaId")
.Parameter("v_AreaId", areaId)
.QueryMany <Company>());
}
/// <summary>
/// DeleteExcelRecord
/// </summary>
/// <returns></returns>
public void DeleteExcelRecord(int excelRecordId)
{
CurrentConnectStringContext.StoredProcedure("ExcelRecord_DeleteById")
.Parameter("v_ExcelRecordId", excelRecordId)
.Execute();
}
/// <summary>
/// DeleteFinancialData
/// </summary>
/// <param name="excelRecordId"></param>
public void DeleteFinancialData(int excelRecordId)
{
CurrentConnectStringContext.StoredProcedure("FinancialData_DeleteByExcelRecordId")
.Parameter("v_ExcelRecordId", excelRecordId)
.Execute();
}
/// <summary>
/// 获取所有导入的excel
/// </summary>
/// <returns></returns>
public List <ExcelRecordModel> GetAllExcelRecord()
{
return(CurrentConnectStringContext.StoredProcedure("ExcelRecord_Get")
.QueryMany <ExcelRecordModel>());
}
/// <summary>
/// 根据excelRecordId删除所有科目
/// </summary>
/// <param name="excelRecordId"></param>
public void DeleteAccountByExcelRecordId(int excelRecordId)
{
CurrentConnectStringContext.StoredProcedure("AccountItem_DeleteByExcelRecordId")
.Parameter("v_ExcelRecordId", excelRecordId)
.Execute();
}
/// <summary>
/// 根据excelRecordId获取所有科目
/// </summary>
/// <returns></returns>
public List <AccountItemModel> GetAccountByExcelRecordId(int excelRecordId)
{
return(CurrentConnectStringContext.StoredProcedure("AccountItem_GetByExcelRecordId")
.Parameter("v_ExcelRecordId", excelRecordId)
.QueryMany <AccountItemModel>());
}
