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>());
}
public int SaveCompanyConnectRecord(CompanyConnectRecord dataModel)
{
dataModel.UpdateDateTime = DateTime.Now;
return(_companyDal.SaveCompanyConnectRecord(dataModel));
}
private List <string> GetOneCellData(Area area, Company company, CompanyConnectRecord record)
{
var companyState = "";
switch (record.CompanyState)
{
case 1:
companyState = "已注销";
break;
case 2:
companyState = "存续";
break;
case 3:
companyState = "待确认";
break;
}
var isValidateAddress = "";
switch (record.IsValidateAddress)
{
case 1:
isValidateAddress = "有效";
break;
case 2:
isValidateAddress = "无效";
break;
}
var cooperationIntention = "";
switch (record.CooperationIntention)
{
case 1:
cooperationIntention = "无意向";
break;
case 2:
cooperationIntention = "有意向";
break;
case 3:
cooperationIntention = "待确认";
break;
}
var result = new List <string>();
result.Add(area == null ? "" : area.AreaName);
result.Add(company.CompanyName);
result.Add(company.ArtificialPerson);
result.Add(company.SetUpTime.GetFormatStr());
result.Add(company.CompanyPhone);
result.Add(company.Address);
result.Add(record.PhoneConnectDate.GetFormatStr());
result.Add(companyState);
result.Add(isValidateAddress);
result.Add(record.ConfirmAddress);
result.Add(record.GoHomePerson);
result.Add(record.GoHomeTime.GetFormatStr());
result.Add(record.PhoneConnectState);
result.Add(cooperationIntention);
return(result);
}