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