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