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(); } }
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(); } }
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 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(); } }
//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 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(); } }
public void FM091102(int webDelay, int maxCusSvrConnLevel, int maxUserConnNum, int cusSvrUserMaxAmount) { using (DBMA1DataContext dbma1 = new DBMA1DataContext()) { var data = dbma1.configs.First(); data.webDelay = webDelay; data.maxCusSvrConnLevel = maxCusSvrConnLevel; data.maxUserConnNum = maxUserConnNum; data.cusSvrUserMaxAmount = cusSvrUserMaxAmount; //添加后台修改记录 B00 B000 b000 = new B000(); b000.bgOperateSN = C101.FC10102("B000", 5, "B"); b000.tableName = "configs"; b000.pkSN = data.config_id.ToString(); b000.actionTypeSN = "B0X"; int operatorSN = Convert.ToInt32(session["internalUserId"].ToString()); //int operatorSN = 1032; b000.operatorSN = operatorSN; b000.operateDate = DateTime.Now; dbma1.B000s.InsertOnSubmit(b000); dbma1.SubmitChanges(); } }
//0:成功; 1:岗位已经删除; 2:用户已经添加到此岗位; 3:用户已经添加到其他岗位; public string FM100403(string roleSN, int internalUserSN) { using (DBMA1DataContext dbma1 = new DBMA1DataContext()) { //岗位已经删除 var dataVarify1 = dbma1.B004s.Where(c => c.roleTypeSN == roleSN && c.deleteDate == null).FirstOrDefault(); if (dataVarify1 == null) { return("1"); } //用户已经添加到此岗位 var dataVarify2 = dbma1.B003s.Where(c => c.roleTypeSN == roleSN && c.internalUserSN == internalUserSN && c.deleteDate == null).FirstOrDefault(); if (dataVarify2 != null) { return("2"); } //用户已经添加到其他岗位 var dataVarify3 = dbma1.B003s.Where(c => c.roleTypeSN != roleSN && c.internalUserSN == internalUserSN && c.deleteDate == null).FirstOrDefault(); if (dataVarify3 != null) { return("3"); } B003 b003 = new B003(); b003.roleAssignmentSN = C101.FC10102("B003", 3, "B"); b003.internalUserSN = internalUserSN; b003.roleTypeSN = roleSN.Trim();; b003.assignDate = DateTime.Now; dbma1.B003s.InsertOnSubmit(b003); //添加后台修改记录 B00 B000 b000 = new B000(); b000.bgOperateSN = C101.FC10102("B000", 5, "B"); b000.tableName = "B003"; b000.pkSN = b003.roleAssignmentSN; b000.actionTypeSN = "B1B"; int operatorSN = Convert.ToInt32(session["internalUserId"].ToString()); //int operatorSN = 1032; b000.operatorSN = operatorSN; b000.operateDate = DateTime.Now; dbma1.B000s.InsertOnSubmit(b000); dbma1.SubmitChanges(); return("0"); } }
//"0":成功; “1“:岗位已经删除; ”2“:该岗位有用户 public string FM100405(string roleSN) { using (DBMA1DataContext dbma1 = new DBMA1DataContext()) { //岗位已经删除 var data = dbma1.B004s.Where(c => c.roleTypeSN == roleSN && c.deleteDate == null).FirstOrDefault(); if (data == null) { return("1"); } //该岗位有用户 var data1 = (from c in dbma1.B004s from o in c.B003s where c.roleTypeSN == roleSN && c.deleteDate == null && o.deleteDate == null select c).FirstOrDefault(); if (data1 != null) { return("2"); } var data2 = (from c in dbma1.B004s where c.roleTypeSN == roleSN select c).First(); data2.deleteDate = DateTime.Now; //添加后台修改记录 B00 B000 b000 = new B000(); b000.bgOperateSN = C101.FC10102("B000", 5, "B"); b000.tableName = "B004"; b000.pkSN = data2.roleTypeSN; b000.actionTypeSN = "B1D"; int operatorSN = Convert.ToInt32(session["internalUserId"].ToString()); //int operatorSN = 1032; b000.operatorSN = operatorSN; b000.operateDate = DateTime.Now; dbma1.B000s.InsertOnSubmit(b000); dbma1.SubmitChanges(); return("0"); } }
//成功:"0"; 客户经理无效:"1" public string FM020504(string userSN, string workNum) { using (DBMA1DataContext dbma1 = new DBMA1DataContext()) { int internalUserSN = dbma1.internal_users.Where(c => c.work_num == workNum).First().internal_user_id; //查看客户经理是否有效 var data = (from c in dbma1.B003s where c.deleteDate == null && c.internalUserSN == internalUserSN && c.roleTypeSN.Trim() == "B01" select c).FirstOrDefault(); if (data == null) { return("1"); } //修改客户经理 B005 b005 = (from c in dbma1.B005s where c.userSN == userSN select c).First(); b005.internalUserSN = internalUserSN; b005.assignDate = DateTime.Now; //添加后台修改记录 B00 B000 b000 = new B000(); b000.bgOperateSN = C101.FC10102("B000", 5, "B"); b000.tableName = "B005"; b000.pkSN = b005.userSN; b000.actionTypeSN = "B0D"; int operatorSN = Convert.ToInt32(session["internalUserId"].ToString()); //int operatorSN = 1032; b000.operatorSN = operatorSN; b000.operateDate = DateTime.Now; dbma1.B000s.InsertOnSubmit(b000); dbma1.SubmitChanges(); return("0"); } }
public void FM020412(string userSN, string status) { using (DBMA1DataContext dbma1 = new DBMA1DataContext()) { var data = dbma1.U001s.Where(c => c.userSN == userSN).First(); data.consultantStatus = status == "1" ? true : false; B000 b000 = new B000(); b000.bgOperateSN = C101.FC10102("B000", 5, "B"); b000.tableName = "U001"; b000.pkSN = data.userSN; b000.actionTypeSN = status == "1" ? "B0B" : "B0C"; int internalUserSN = Convert.ToInt32(session["internalUserId"].ToString()); //int internalUserSN = 1032; b000.operatorSN = internalUserSN; b000.operateDate = DateTime.Now; dbma1.B000s.InsertOnSubmit(b000); dbma1.SubmitChanges(); } }
//0:成功; 1:客户经理有服务的客户,无法删除; public string FM100402(string roleSN, int internalUserSN) { using (DBMA1DataContext dbma1 = new DBMA1DataContext()) { if (roleSN.Trim() == "B01") { var dataTemp = dbma1.B005s.Where(c => c.internalUserSN == internalUserSN).FirstOrDefault(); if (dataTemp != null) { return("1"); } } var data = dbma1.B003s.Where(c => c.roleTypeSN == roleSN && c.internalUserSN == internalUserSN && c.deleteDate == null).FirstOrDefault(); if (data == null) { return("0"); } data.deleteDate = DateTime.Now; //添加后台修改记录 B00 B000 b000 = new B000(); b000.bgOperateSN = C101.FC10102("B000", 5, "B"); b000.tableName = "B003"; b000.pkSN = data.roleAssignmentSN; b000.actionTypeSN = "B1A"; int operatorSN = Convert.ToInt32(session["internalUserId"].ToString()); //int operatorSN = 1032; b000.operatorSN = operatorSN; b000.operateDate = DateTime.Now; dbma1.B000s.InsertOnSubmit(b000); dbma1.SubmitChanges(); return("0"); } }
public string FM020409(string userSN, string act, string auditNote) { using (DBMA1DataContext dbma1 = new DBMA1DataContext()) { int?operatorSN = Convert.ToInt32(session["internalUserId"].ToString()); //int? operatorSN = 1032; //更新U006 U006 u006 = (from c in dbma1.U006s where c.userSN == userSN orderby c.applyDate descending select c).First(); u006.auditStatus = Convert.ToInt16(act == "1" ? "2" : "3"); u006.auditDate = DateTime.Now; u006.auditerUserSN = operatorSN; u006.auditNote = auditNote; //更新U001 U001 u001 = dbma1.U001s.Where(c => c.userSN == userSN).First(); u001.consultantApplyStatus = Convert.ToInt16(act == "1" ? "2" : "3"); //添加B000 B000 b000 = new B000(); b000.bgOperateSN = C101.FC10102("B000", 5, "B"); b000.tableName = "B005"; b000.pkSN = u006.recordSN; b000.actionTypeSN = act == "1" ? "B0E" : "B0F"; b000.operatorSN = Convert.ToInt32(operatorSN); b000.operateDate = DateTime.Now; dbma1.B000s.InsertOnSubmit(b000); string name = dbma1.internal_users.Where(c => c.internal_user_id == Convert.ToInt32(operatorSN)).First().name; dbma1.SubmitChanges(); return(name); } }
public void FM091101(int mode) { using (DBMA1DataContext dbma1 = new DBMA1DataContext()) { var data = dbma1.configs.First(); data.cusSvrMode = mode; //添加后台修改记录 B00 B000 b000 = new B000(); b000.bgOperateSN = C101.FC10102("B000", 5, "B"); b000.tableName = "configs"; b000.pkSN = data.config_id.ToString(); b000.actionTypeSN = "B0W"; 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 FM090802(decimal shortMessageCost) { using (DBMA1DataContext dbma1 = new DBMA1DataContext()) { var data = dbma1.A028s.First(); data.shortMessageCost = shortMessageCost; //添加后台修改记录 B00 B000 b000 = new B000(); b000.bgOperateSN = C101.FC10102("B000", 5, "B"); b000.tableName = "A028"; b000.pkSN = data.moneyParamsSN.ToString(); b000.actionTypeSN = "B0U"; 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 FM091003(decimal serviceRate) { using (DBMA1DataContext dbma1 = new DBMA1DataContext()) { var data = dbma1.A027s.First(); data.serviceRate = serviceRate; //添加后台修改记录 B00 B000 b000 = new B000(); b000.bgOperateSN = C101.FC10102("B000", 5, "B"); b000.tableName = "A027"; b000.pkSN = data.sellingParamsSN.ToString(); b000.actionTypeSN = "B0S"; 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 FM090401(bool switchStatus) { using (DBMA1DataContext dbma1 = new DBMA1DataContext()) { var data = dbma1.A034s.First(); data.switchStatus = switchStatus; //添加后台修改记录 B00 B000 b000 = new B000(); b000.bgOperateSN = C101.FC10102("B000", 5, "B"); b000.tableName = "A034"; b000.pkSN = data.SN; b000.actionTypeSN = "B18"; 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 FM090904(int value, decimal rate) { using (DBMA1DataContext dbma1 = new DBMA1DataContext()) { var data = dbma1.A029s.First(); data.vip3_originateValue = value; data.vip3_rewardRate = rate; //添加后台修改记录 B00 B000 b000 = new B000(); b000.bgOperateSN = C101.FC10102("B000", 5, "B"); b000.tableName = "A029"; b000.pkSN = data.vipParamsSN.ToString(); b000.actionTypeSN = "B13"; int operatorSN = Convert.ToInt32(session["internalUserId"].ToString()); //int operatorSN = 1032; b000.operatorSN = operatorSN; b000.operateDate = DateTime.Now; dbma1.B000s.InsertOnSubmit(b000); dbma1.SubmitChanges(); } }
//"0":成功; “1“:相同名称的岗位已经存在 public string FM100404(string roleName, string note) { using (DBMA1DataContext dbma1 = new DBMA1DataContext()) { B004 b004 = new B004(); var data = dbma1.B004s.Where(c => c.value == roleName && c.deleteDate == null).FirstOrDefault(); if (data != null) { return("{\"status\":\"1\"}"); } b004.roleTypeSN = C101.FC10102("B004", 2, "B"); b004.value = roleName; b004.note = note; b004.assignDate = DateTime.Now; dbma1.B004s.InsertOnSubmit(b004); //添加后台修改记录 B00 B000 b000 = new B000(); b000.bgOperateSN = C101.FC10102("B000", 5, "B"); b000.tableName = "B004"; b000.pkSN = b004.roleTypeSN; b000.actionTypeSN = "B1C"; int operatorSN = Convert.ToInt32(session["internalUserId"].ToString()); //int operatorSN = 1032; b000.operatorSN = operatorSN; b000.operateDate = DateTime.Now; dbma1.B000s.InsertOnSubmit(b000); dbma1.SubmitChanges(); return(string.Format("{{\"status\":\"0\",\"SN\":\"{0}\"}}", b004.roleTypeSN)); } }
public void FM090701(decimal openServerCost, decimal assetsReserveCost) { using (DBMA1DataContext dbma1 = new DBMA1DataContext()) { var data = dbma1.A026s.First(); data.openServerCost = openServerCost; data.assetsReserveCost = assetsReserveCost; //添加后台修改记录 B00 B000 b000 = new B000(); b000.bgOperateSN = C101.FC10102("B000", 5, "B"); b000.tableName = "A026"; b000.pkSN = data.purchaseParamsSN.ToString(); b000.actionTypeSN = "B0P"; int operatorSN = Convert.ToInt32(session["internalUserId"].ToString()); //int operatorSN = 1032; b000.operatorSN = operatorSN; b000.operateDate = DateTime.Now; dbma1.B000s.InsertOnSubmit(b000); dbma1.SubmitChanges(); } }
//“0”:成功; “1”:交易密码错误; "2":姓名错误 public string FM060301(string phone, string name, decimal changeAmount, string changeReasonType, string pwd, string note) { using (DBMA1DataContext dbma1 = new DBMA1DataContext()) { //查看密码是否正确 int operatorSN = Convert.ToInt32(session["internalUserId"].ToString()); var data = dbma1.internal_users.Where(c => c.internal_user_id == operatorSN && c.pwd == pwd).FirstOrDefault(); if (data == null) { return("{\"sucStatus\":\"1\"}"); } var u000 = dbma1.U000s.Where(c => c.phone == phone).First(); string userSN = u000.userSN; //姓名是否正确 if (u000.name.Trim() != name) { return("{\"sucStatus\":\"2\"}"); } //更新余额表 F000 F000 f000 = dbma1.F000s.Where(c => c.userSN == userSN).First(); f000.balance += changeAmount; //添加调账表 F007 F007 f007 = new F007(); f007.changeAccountSN = C101.FC10102("F007", 7, "UF"); f007.userSN = userSN; f007.phone = phone; f007.name = name; f007.changeAmount = changeAmount; f007.changeReasonType = changeReasonType; f007.note = note; f007.changeDate = DateTime.Now; dbma1.F007s.InsertOnSubmit(f007); //添加收支明细表 F003 F003 f003 = new F003(); f003.revenueExpenditureSN = C101.FC10102("F003", 8, "UA"); f003.generetorUserSN = userSN; f003.generateDate = DateTime.Now; f003.type = changeReasonType; f003.revenue = changeAmount; f003.expenditure = 0; f003.balance = f000.balance; f003.referSN = f007.changeAccountSN; dbma1.F003s.InsertOnSubmit(f003); //添加后台修改记录 B00 B000 b000 = new B000(); b000.bgOperateSN = C101.FC10102("B000", 5, "B"); b000.tableName = "B005"; b000.pkSN = f007.changeAccountSN; b000.actionTypeSN = "B0G"; b000.operatorSN = operatorSN; b000.operateDate = DateTime.Now; dbma1.B000s.InsertOnSubmit(b000); dbma1.SubmitChanges(); dbma1.SubmitChanges(); return(string.Format("{{\"sucStatus\":\"0\",\"SN\":\"{0}\",\"date\":{1}}}", f007.changeAccountSN, C101.FC10107(DateTime.Now))); } }