/// <summary>
/// 删除拒绝预约 （融资方取消）
/// </summary>
public void FP10217(string crSN)
{
using (DBMA1DataContext dbma1 = new DBMA1DataContext())
{
P203 p203 = (from c in dbma1.P203s
where c.creditRightSN == crSN &&
c.senderCancelReserveDate != null &&
c.receiverDeleteReserveDate == null
select c).FirstOrDefault();
if (p203 == null)
{
return;
}
p203.receiverDeleteReserveDate = DateTime.Now;
//P101 p101 = (from c in dbma1.P101s
// where c.creditRightReserveSN == p203.reserveSN
// && c.senderCancelReserveDate == null
// select c).FirstOrDefault();
//if (p101 != null)
//{
// p101.senderCancelReserveDate = DateTime.Now;
//}
dbma1.SubmitChanges();
}
}
public void FM090101(int minDeadline, int maxDeadline, decimal minFinancingMoneyAmount)
{
using (DBMA1DataContext dbma1 = new DBMA1DataContext())
{
var a024 = dbma1.A024s.First();
a024.minDeadline = minDeadline;
a024.maxDeadline = maxDeadline;
a024.minFinancingMoneyAmount = minFinancingMoneyAmount;
//添加后台修改记录 B00
B000 b000 = new B000();
b000.bgOperateSN = C101.FC10102("B000", 5, "B");
b000.tableName = "A024";
b000.pkSN = a024.financingParamsSN.ToString();
b000.actionTypeSN = "B0K";
int operatorSN = Convert.ToInt32(session["internalUserId"].ToString());
//int operatorSN = 1032;
b000.operatorSN = operatorSN;
b000.operateDate = DateTime.Now;
dbma1.B000s.InsertOnSubmit(b000);
dbma1.SubmitChanges();
}
}
public void FM090601(decimal minInvestMoneyAmount, decimal minDailyRate, decimal maxDailyRate)
{
using (DBMA1DataContext dbma1 = new DBMA1DataContext())
{
var a023 = dbma1.A023s.First();
a023.minInvestMoneyAmount = minInvestMoneyAmount;
a023.minDailyRate = minDailyRate;
a023.maxDailyRate = maxDailyRate;
//添加后台修改记录 B00
B000 b000 = new B000();
b000.bgOperateSN = C101.FC10102("B000", 5, "B");
b000.tableName = "A023";
b000.pkSN = a023.investParamsSN.ToString();;
b000.actionTypeSN = "B0H";
int operatorSN = Convert.ToInt32(session["internalUserId"].ToString());
//int operatorSN = 1032;
b000.operatorSN = operatorSN;
b000.operateDate = DateTime.Now;
dbma1.B000s.InsertOnSubmit(b000);
dbma1.SubmitChanges();
}
}
//如有邮箱信息，邮箱发送密码
//0：邮箱发送成功。2：用户没有邮箱信息，或者邮箱已经禁用。
private string IfSendSuccessByEmail(DBMA1DataContext dbma1, string phoneNum, string resetPwd, string content)
{
//发送邮箱禁用
var data = dbma1.A035s.FirstOrDefault();
if (data == null)
{
return("2");
}
else if (data.switchStatus == false)
{
return("2");
}
//没有接受邮箱
var linqData = dbma1.U002s.Where(c => c.phone == phoneNum && c.email != null).FirstOrDefault();
if (linqData == null)
{
return("2");
}
Comm.C101.FC10106(dbma1, linqData.userSN, data.userName.Trim(), data.pwd.Trim(), linqData.email.Trim(), data.SMTP.Trim(), Convert.ToInt32(data.port), "凡奇网账号新密码", content);
//Comm.C101.FC10106("*****@*****.**", "ningbo21152", linqData.email.Trim(),"",25, "新密码", content);
SaveResetPwd(dbma1, phoneNum, resetPwd);
return(string.Format("{{\"status\":\"0\",\"email\":\"{0}\"}}", linqData.email.Trim()));
}
//1:修改成功;0:操作失败 不返回结果:2:验证码不正确;
public int FP80310(string IC, string newPwd)
{
string userSN = session["userSN"].ToString();
//string userSN = "U00001";
using (DBMA1DataContext dbma1 = new DBMA1DataContext())
{
string phone = dbma1.U000s.Where(c => c.userSN == userSN).First().phone;
//检测验证码
if (IfIdentifyingCodeCorrect(dbma1, phone, IC, "修改交易密码") == false)
{
return(2);
}
//修改交易密码
string newPwdMd5 = C101.FC10103(newPwd);
U003 u003 = dbma1.U003s.Where(c => c.userSN == userSN).First();
u003.transactPwd = newPwdMd5;
u003.ifChangeTransactPwd = true;
dbma1.SubmitChanges();
return(1);
}
}
//更新用户信息基本表 U002
private void FinancingSvrUpdateU002(DBMA1DataContext dbma1, U002 financingSvrObj, string userSN)
{
U002 u002 = dbma1.U002s.Where(c => c.userSN == userSN).First();
u002.maritalStatusTypeSN = financingSvrObj.maritalStatusTypeSN;
u002.procreateStatus = financingSvrObj.procreateStatus;
u002.currentAddressProvinceSN = financingSvrObj.currentAddressProvinceSN;
u002.currentAddressCitySN = financingSvrObj.currentAddressCitySN;
u002.currentAddressDetails = financingSvrObj.currentAddressDetails;
u002.workEnterprise = financingSvrObj.workEnterprise;
u002.enterpriseTypeSN = financingSvrObj.enterpriseTypeSN;
u002.workTel = financingSvrObj.workTel;
u002.hiredate = financingSvrObj.hiredate;
u002.post = financingSvrObj.post;
u002.healthyStatusTypeSN = financingSvrObj.healthyStatusTypeSN;
u002.ifBasicLivingAllowance = financingSvrObj.ifBasicLivingAllowance;
u002.graduateSchool = financingSvrObj.graduateSchool;
u002.degreeTypeSN = financingSvrObj.degreeTypeSN;
u002.monthlyTotalIncome = financingSvrObj.monthlyTotalIncome;
u002.monthlyTotalExpenditure = financingSvrObj.monthlyTotalExpenditure;
u002.monthlyNetIncome = financingSvrObj.monthlyNetIncome;
u002.totalAssets = financingSvrObj.totalAssets;
u002.totalDebt = financingSvrObj.totalDebt;
u002.ifCourtImplementation = financingSvrObj.ifCourtImplementation;
u002.creditStatus = financingSvrObj.creditStatus;
}
public void FM090501(string smtp, string userName, string pwd, int port, bool switchStatus)
{
using (DBMA1DataContext dbma1 = new DBMA1DataContext())
{
var data = dbma1.A035s.First();
data.SMTP = smtp;
data.userName = userName;
data.pwd = pwd;
data.port = port;
data.switchStatus = switchStatus;
//添加后台修改记录 B00
B000 b000 = new B000();
b000.bgOperateSN = C101.FC10102("B000", 5, "B");
b000.tableName = "A035";
b000.pkSN = data.SN;
b000.actionTypeSN = "B19";
int operatorSN = Convert.ToInt32(session["internalUserId"].ToString());
//int operatorSN = 1032;
b000.operatorSN = operatorSN;
b000.operateDate = DateTime.Now;
dbma1.B000s.InsertOnSubmit(b000);
dbma1.SubmitChanges();
}
}
//P8010202 个人信息
public void FP8010202(string maritalStatusTypeSN, bool procreateStatus, string healthyStatusTypeSN, bool ifBasicLivingAllowance, string currentAddressProvinceSN, string currentAddressCitySN, string currentAddressDetails, string graduateSchool, string degreeTypeSN, string degreeCard, string friendName, string friendPhone)
{
string userSN = session["userSN"].ToString();
//string userSN = "U00001";
using (DBMA1DataContext dbma1 = new DBMA1DataContext())
{
U002 u002 = dbma1.U002s.Where(c => c.userSN == userSN).First();
u002.maritalStatusTypeSN = maritalStatusTypeSN;
u002.procreateStatus = procreateStatus;
u002.healthyStatusTypeSN = healthyStatusTypeSN;
u002.ifBasicLivingAllowance = ifBasicLivingAllowance;
u002.currentAddressProvinceSN = currentAddressProvinceSN;
u002.currentAddressCitySN = currentAddressCitySN;
u002.currentAddressDetails = currentAddressDetails;
u002.graduateSchool = graduateSchool;
u002.degreeTypeSN = degreeTypeSN;
u002.degreeCard = degreeCard;
u002.friendName = friendName;
u002.friendPhone = friendPhone;
dbma1.SubmitChanges();
}
}
//P8010503 工作信息
public void FP8010503(string workEnterprise, string enterpriseTypeSN, string industryTypeSN, DateTime?hiredate, string workTel, string post, string enterpriseSwitchboard, string enterpriseWebsite, string colleageName, string colleagePhone, string colleageIdCard)
{
string userSN = session["userSN"].ToString();
//string userSN = "U00001";
using (DBMA1DataContext dbma1 = new DBMA1DataContext())
{
U002 u002 = dbma1.U002s.Where(c => c.userSN == userSN).First();
u002.workEnterprise = workEnterprise;
u002.enterpriseTypeSN = enterpriseTypeSN;
u002.industryTypeSN = industryTypeSN;
u002.hiredate = hiredate;
u002.workTel = workTel;
u002.post = post;
u002.enterpriseSwitchboard = enterpriseSwitchboard;
u002.enterpriseWebsite = enterpriseWebsite;
u002.colleageName = colleageName;
u002.colleagePhone = colleagePhone;
u002.colleageIdCard = colleageIdCard;
dbma1.SubmitChanges();
}
}
//0:成功； 1：失效； 2：失败
public string FM020102(string crSN)
{
using (DBMA1DataContext dbma1 = new DBMA1DataContext())
{
var dataVerify = (from c in dbma1.P200s
where c.creditRightSN == crSN &&
c.cancelDate == null &&
!dbma1.P203s.Where(o => o.creditRightSN == crSN && o.senderCancelReserveDate == null && o.receiverRefuseReserveDate == null).Any() &&
!dbma1.P100s.Where(p => p.creditRightSN == crSN && p.senderCancelReserveDate == null && p.receiverRefuseReserveDate == null).Any()
select c).FirstOrDefault();
if (dataVerify == null)
{
return("1");
}
var data = dbma1.P200s.Where(c => c.creditRightSN == crSN).First();
data.cancelDate = DateTime.Now;
B000 b000 = new B000();
b000.bgOperateSN = C101.FC10102("B000", 5, "B");
b000.tableName = "P200";
b000.pkSN = data.creditRightSN;
b000.actionTypeSN = "B01";
int internalUserSN = Convert.ToInt32(session["internalUserId"].ToString());
//int internalUserSN = 1032;
b000.operatorSN = internalUserSN;
b000.operateDate = DateTime.Now;
dbma1.B000s.InsertOnSubmit(b000);
dbma1.SubmitChanges();
return("0");
}
}
public string FP90301(int pageSize)
{
string userSN = session["userSN"].ToString();
//string userSN = "U00001";
using (DBMA1DataContext dbma1 = new DBMA1DataContext())
{
var linqDataList = (from c in dbma1.F003s
where c.generetorUserSN == userSN
select new
{
c.revenueExpenditureSN,
c.generateDate,
c.type,
c.revenue,
c.expenditure,
c.balance
}
).Take(pageSize).ToList();
string linqDataListStr = C101.FC10107(linqDataList);
return(string.Format("{{\"dataList\":{0},\"maxDatetime\":\"{1}\"}}", linqDataListStr, DateTime.Now));
}
}
public void FP10209(string crSN)
{
using (DBMA1DataContext dbma1 = new DBMA1DataContext())
{
//有效性检查（1、未审核）
var data1 = dbma1.P500s.Where(c => c.creditRightSN == crSN && c.auditStatus != null).FirstOrDefault();
if (data1 != null)
{
return;
}
P101 p101 = (from c in dbma1.P101s
where c.creditRightSN == crSN &&
c.senderCancelReserveDate == null
select c).FirstOrDefault();
if (p101 == null)
{
return;
}
p101.senderCancelReserveDate = DateTime.Now;
dbma1.SubmitChanges();
}
}
//发送预约邮箱提醒
private int SendByEmail(DBMA1DataContext dbma1, string consultantUserSN, string investorUserSN)
{
string subject = "【凡奇金融】顾问预约";
string content = string.Format("亲爱的凡奇用户，您已经被用户{0}预约，请您查看。", investorUserSN);
return(C101.FC10105(dbma1, consultantUserSN, subject, content));
}
/// <summary>
/// 取消预约
/// </summary>
public void FP10207(string crSN, string cancelReasonTypeSN)
{
using (DBMA1DataContext dbma1 = new DBMA1DataContext())
{
//检查有效性（1、没有被投资。）
var data1 = dbma1.P102s.Where(c => c.creditRightSN == crSN).FirstOrDefault();
if (data1 != null)
{
return;
}
P100 p100 = (from c in dbma1.P100s
where c.creditRightSN == crSN &&
c.senderCancelReserveDate == null &&
c.receiverRefuseReserveDate == null
select c).FirstOrDefault();
if (p100 == null)
{
return;
}
p100.senderCancelReserveDate = DateTime.Now;
p100.senderCancelReserveReasonTypeSN = cancelReasonTypeSN;
//P101 p101 = (from c in dbma1.P101s
// where c.creditRightReserveSN == p100.reserveSN
// && c.senderCancelReserveDate == null
// select c).FirstOrDefault();
//if (p101 != null)
//{
// p101.senderCancelReserveDate = DateTime.Now;
//}
dbma1.SubmitChanges();
}
}
/// <summary>
/// 扣款
/// </summary>
public static bool FC20147(DBMA1DataContext dbma1, string userSN, decimal amount, string type, string referSN)
{
//从余额中扣除服务费 F000
F000 f000 = dbma1.F000s.Where(c => c.userSN == userSN).First();
if (f000.balance < amount)
{
return(false);
}
f000.balance -= amount;
//加入收支明细表中 F003
string F003max33SN = C101.FC10102("F003", 8, "UA");
F003 f003 = new F003();
f003.revenueExpenditureSN = F003max33SN;
f003.generetorUserSN = userSN;
f003.generateDate = DateTime.Now;
f003.type = type;
f003.expenditure = amount;
f003.balance = f000.balance;
f003.referSN = referSN;
dbma1.F003s.InsertOnSubmit(f003);
return(true);
}
//预约发送邮件提醒
private int SendByEmail(DBMA1DataContext dbma1, string financierSN, string crSN)
{
string subject = "【凡奇金融】债权预约";
string content = string.Format("亲爱的凡奇用户，您的债权({0})已经被预约，请您查看。", crSN);
return(C101.FC10105(dbma1, financierSN, subject, content));
}
//更新用户信息基本表 U002
private void InvestSvrUpdateU002(DBMA1DataContext dbma1, U002 investSvrObj, string userSN)
{
U002 u002 = dbma1.U002s.Where(c => c.userSN == userSN).First();
u002.maritalStatusTypeSN = investSvrObj.maritalStatusTypeSN;
u002.procreateStatus = investSvrObj.procreateStatus;
u002.currentAddressProvinceSN = investSvrObj.currentAddressProvinceSN;
u002.currentAddressCitySN = investSvrObj.currentAddressCitySN;
u002.currentAddressDetails = investSvrObj.currentAddressDetails;
u002.workEnterprise = investSvrObj.workEnterprise;
u002.enterpriseTypeSN = investSvrObj.enterpriseTypeSN;
u002.workTel = investSvrObj.workTel;
u002.hiredate = investSvrObj.hiredate;
u002.post = investSvrObj.post;
u002.investMainTypeSN = investSvrObj.investMainTypeSN;
u002.financingMain = investSvrObj.financingMain;
u002.maxMortgageRate = investSvrObj.maxMortgageRate;
u002.guaranteeTypeSN = investSvrObj.guaranteeTypeSN;
u002.investProvinceSN = investSvrObj.investProvinceSN;
u002.investCitySN = investSvrObj.investCitySN;
u002.minInvestMoneyAmount = investSvrObj.minInvestMoneyAmount;
u002.minInterestRate = investSvrObj.minInterestRate;
u002.minInvestDays = investSvrObj.minInvestDays;
u002.maxInvestDays = investSvrObj.maxInvestDays;
u002.collateralDemand = investSvrObj.collateralDemand;
}
public string FP40101(int pageSize)
{
//判断是否登录
if (session["userSN"] == null)
{
return("notLogin");
}
string userSN = session["userSN"].ToString();
using (DBMA1DataContext dbma1 = new DBMA1DataContext())
{
//判断是否有权限
var data = dbma1.U001s.Where(c => c.userSN == userSN).First();
bool ifBillOverdue = C201.FC20153(dbma1, userSN);
if (data.assetsPruchaseStatus != true || ifBillOverdue == true)
{
return("{\"status\":\"false\"}");
}
string userName = dbma1.U000s.Where(c => c.userSN == userSN).First().name;
string CancelReason = C201.FC20137(dbma1);
var vp401001List = (from c in dbma1.VP401001s
orderby c.publishDate descending
select c).Take(pageSize).ToList();
string vp401001ListStr = C101.FC10107(vp401001List);
return(string.Format("{{\"status\":\"true\",\"userName\":\"{0}\",\"CancelReason\":{1},\"dataList\":{2},\"maxDatetime\":\"{3}\",\"userSN\":\"{4}\"}}", userName, CancelReason, vp401001ListStr, DateTime.Now, userSN));
}
}
//更新用户信息基本表 U002
private void ConcultantSvrUpdateU002(DBMA1DataContext dbma1, U002 consultantSvrObj, string userSN)
{
U002 u002 = dbma1.U002s.Where(c => c.userSN == userSN).First();
u002.maritalStatusTypeSN = consultantSvrObj.maritalStatusTypeSN;
u002.procreateStatus = consultantSvrObj.procreateStatus;
u002.currentAddressProvinceSN = consultantSvrObj.currentAddressProvinceSN;
u002.currentAddressCitySN = consultantSvrObj.currentAddressCitySN;
u002.currentAddressDetails = consultantSvrObj.currentAddressDetails;
u002.workEnterprise = consultantSvrObj.workEnterprise;
u002.enterpriseTypeSN = consultantSvrObj.enterpriseTypeSN;
u002.industryTypeSN = consultantSvrObj.industryTypeSN;
u002.workTel = consultantSvrObj.workTel;
u002.hiredate = consultantSvrObj.hiredate;
u002.post = consultantSvrObj.post;
u002.graduateSchool = consultantSvrObj.graduateSchool;
u002.degreeTypeSN = consultantSvrObj.degreeTypeSN;
u002.serviceProvinceSN = consultantSvrObj.serviceProvinceSN;
u002.serviceCitySN = consultantSvrObj.serviceCitySN == "" ? null : consultantSvrObj.serviceCitySN;
u002.investigate = consultantSvrObj.investigate;
u002.assetsEvaluate = consultantSvrObj.assetsEvaluate;
u002.creditRightGuarantee = consultantSvrObj.creditRightGuarantee;
u002.badLoanCollect = consultantSvrObj.badLoanCollect;
u002.consultantDetails = consultantSvrObj.consultantDetails;
}
/// <summary>
/// 获取邮箱参数，并发送邮箱
/// 0:成功。1：没有可发送的邮箱。2：发送邮箱被禁用。3：没有接受邮箱。
/// </summary>
public static int FC10105(DBMA1DataContext dbma1, string userSN, string subject, string content)
{
//发送邮箱禁用
var data = dbma1.A035s.FirstOrDefault();
if (data == null)
{
return(1);
}
else if (data.switchStatus == false)
{
return(2);
}
//没有接受邮箱
var linqData = dbma1.U002s.Where(c => c.userSN == userSN && c.email != null).FirstOrDefault();
if (linqData == null)
{
return(3);
}
FC10106(dbma1, userSN, data.userName.Trim(), data.pwd.Trim(), linqData.email.Trim(), data.SMTP.Trim(), Convert.ToInt32(data.port), subject, content);
return(0);
}
/// <summary>
/// 发送短信验证码
/// </summary>
public bool FP80402(string phoneNum)
{
using (DBMA1DataContext dbma1 = new DBMA1DataContext())
{
if (dbma1.U000s.Where(c => c.phone == phoneNum).FirstOrDefault() != null)
{
return(false);
}
//判断是否需要产生新的验证码
string identifyingCode = IfIdentifyCodePastDue(dbma1, phoneNum);
if (identifyingCode == null)
{
//产生6位新的验证码
identifyingCode = GenerateIdentifyingCode();
}
//发送验证码
string content = string.Format("您的验证码为{0}，有效时间为10分钟。", identifyingCode);
if (Comm.SM.F001(dbma1, "U00000", phoneNum, content, 1, false) != "0")
{
dbma1.SubmitChanges();
return(false);
}
//验证码记录写入到数据库中
IdentifyingCodeInsertIntoDB(dbma1, phoneNum, identifyingCode);
dbma1.SubmitChanges();
return(true);
}
}
//unavailable：短信开关关闭。0：发送短信成功。其他：发送失败状态码。
public string CF10113(DBMA1DataContext dbma1, string userSN, string phone, string content, int seqid, int priority, bool ifNeedPay)
{
//验证短信开关是否打开
if (dbma1.A034s.First().switchStatus != true)
{
return("unavailable");
}
//发送短信
string res = CF10109(phone, content, seqid, priority);
//添加短信记录表
T000 t000 = new T000();
t000.smSN = C101.FC10102("T000", 8, "T");
t000.generateDate = DateTime.Now;
t000.sendDate = DateTime.Now;
t000.ifSuc = res == "0" ? true : false;
dbma1.T000s.InsertOnSubmit(t000);
//扣款
if (ifNeedPay == true && res == "0")
{
decimal smFee = Convert.ToInt32(dbma1.A028s.First().shortMessageCost);
C201.FC20154(dbma1, userSN, smFee, "短信发送", t000.smSN);
}
return("");
}
public string FP901020101(string billNo)
{
using (DBMA1DataContext dbma1 = new DBMA1DataContext())
{
return(dbma1.F005s.Where(c => c.rechargeSN == billNo).First().ifSuccess == true ? "1" : "0");
}
}
public string FP40204(string userSN)
{
using (DBMA1DataContext dbma1 = new DBMA1DataContext())
{
var sellerData = (from c in dbma1.VP801001s
where c.userSN == userSN
select new
{
c.userSN,
c.name,
c.birthday,
c.gender,
c.registeredResidence,
idCard = c.idCard.Substring(0, 6) + "*",
phone = c.phone,
c.email,
c.maritalStatusType,
c.procreateStatus,
c.currentAddressProvince,
c.currentAddressCity,
c.currentAddressDetails
}).First();
string sellerDataStr = C101.FC10107(sellerData);
int amount = (from c in dbma1.P300s.Where(c => c.cancelDate == null)
from o in c.P400s.Where(o => o.senderCancelReserveDate == null && o.receiverRefuseReserveDate == null)
from p in o.P401s
select c).Count();
return(string.Format("{{\"data\":{0},\"amount\":\"{1}\"}}", sellerDataStr, amount));
}
}
//检测验证码是否正确
private bool IfIdentifyingCodeCorrect(DBMA1DataContext dbma1, string phoneNum, string identifyingCode, string businessType)
{
//找到最新一条验证码
U004 identifyingCodeRecord = (from c in dbma1.U004s
where c.phone == phoneNum
//最新发送的验证码
&& c.sendTime == (dbma1.U004s.Where(o => o.phone == phoneNum && o.businessType == businessType).Max(p => p.sendTime))
select c).FirstOrDefault();
if (identifyingCodeRecord == null)
{
return(false);
}
//验证码是否已经过期，过期时间为20分钟
int deadlineMinites = 20;
TimeSpan ts = DateTime.Now - identifyingCodeRecord.sendTime;
if (ts.Minutes > deadlineMinites)
{
return(false);
}
//验证验证码是否正确
return(identifyingCodeRecord.identifyingCode == identifyingCode ? true : false);
}
//发送产生账单邮件
private int ReserveSendByEmail(DBMA1DataContext dbma1, string sellerUserSN, string assetsSN)
{
string subject = "【凡奇金融】资产预约";
string content = string.Format("亲爱的凡奇用户，您的资产({0})已经被预约，请您查看。", assetsSN);
return(C101.FC10105(dbma1, sellerUserSN, subject, content));
}
public void FM090103(decimal serviceRateDaily, decimal minServiceRateTotel, decimal maxServiceRateTotel)
{
using (DBMA1DataContext dbma1 = new DBMA1DataContext())
{
var a024 = dbma1.A024s.First();
a024.serviceRateDaily = serviceRateDaily;
a024.minServiceRateTotel = minServiceRateTotel;
a024.maxServiceRateTotel = maxServiceRateTotel;
//添加后台修改记录 B00
B000 b000 = new B000();
b000.bgOperateSN = C101.FC10102("B000", 5, "B");
b000.tableName = "A024";
b000.pkSN = a024.financingParamsSN.ToString();
b000.actionTypeSN = "B0M";
int operatorSN = Convert.ToInt32(session["internalUserId"].ToString());
//int operatorSN = 1032;
b000.operatorSN = operatorSN;
b000.operateDate = DateTime.Now;
dbma1.B000s.InsertOnSubmit(b000);
dbma1.SubmitChanges();
}
}
/// <summary>
/// 由省份获取市
/// </summary>
public static string FC20140(string provinceSN)
{
using (DBMA1DataContext dbma1 = new DBMA1DataContext())
{
return(Comm.C201.FC20122(dbma1, provinceSN));
}
}
public void FM090602(decimal openServerCost, decimal consultantReserveCost, decimal financingReserveCost)
{
using (DBMA1DataContext dbma1 = new DBMA1DataContext())
{
var a023 = dbma1.A023s.First();
a023.openServerCost = openServerCost;
a023.consultantReserveCost = consultantReserveCost;
a023.financingReserveCost = financingReserveCost;
//添加后台修改记录 B00
B000 b000 = new B000();
b000.bgOperateSN = C101.FC10102("B000", 5, "B");
b000.tableName = "A023";
b000.pkSN = a023.investParamsSN.ToString();
b000.actionTypeSN = "B0J";
int operatorSN = Convert.ToInt32(session["internalUserId"].ToString());
//int operatorSN = 1032;
b000.operatorSN = operatorSN;
b000.operateDate = DateTime.Now;
dbma1.B000s.InsertOnSubmit(b000);
dbma1.SubmitChanges();
}
}
/// <summary>
/// 结案
/// </summary>
public void FP10309(string crSN, DateTime repaymentDate)
{
using (DBMA1DataContext dbma1 = new DBMA1DataContext())
{
//检查有效性（1、是否已经结案）
var data = dbma1.P102s.Where(c => c.creditRightSN == crSN && c.closeCaseDate != null).FirstOrDefault();
if (data != null)
{
return;
}
var investCrData = dbma1.P102s.Where(c => c.creditRightSN == crSN).First();
investCrData.closeCaseDate = DateTime.Now;
string max33SN = C101.FC10102("P103", 6, "D");
P103 p103 = new P103();
p103.paymentSN = max33SN;
p103.investSN = investCrData.investSN;
p103.repayDate = repaymentDate;
p103.ifOverdue = repaymentDate > investCrData.deadlineDate ? true : false;
dbma1.P103s.InsertOnSubmit(p103);
dbma1.SubmitChanges();
}
}
