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