//0:成功。1:密码错误。2:余额不足 public string FP30103(string assetsData, string pwd) { string userSN = session["userSN"].ToString(); //string userSN = "U00003"; P300 assetsDataObj = C101.FC10108(assetsData, typeof(P300)) as P300; using (DBMA1DataContext dbma1 = new DBMA1DataContext()) { //密码是否正确 if (C201.FC20146(dbma1, userSN, pwd) == false) { return("{\"resStatus\":\"1\"}"); } //余额是否充足 decimal publishAssetsFee = Convert.ToDecimal(dbma1.A027s.First().publishAssetsCost); //扣款 if (C201.FC20147(dbma1, userSN, publishAssetsFee, "资产发布", null) == false) { return("{\"resStatus\":\"2\"}"); } //加入资产表 P300 string max33SN = C101.FC10102("P300", 6, "G"); assetsDataObj.assetsSN = max33SN; assetsDataObj.publisherUserSN = userSN; assetsDataObj.publishDate = DateTime.Now; dbma1.P300s.InsertOnSubmit(assetsDataObj); //加入成长值表 F006 F006 f006 = new F006(); f006.groupUpSN = C101.FC10102("F006", 7, "UD"); f006.userSN = userSN; f006.businessSN = max33SN; f006.businessType = "资产发布"; f006.transactionMoneyAmount = publishAssetsFee; f006.groupUpValue = publishAssetsFee; f006.acquireDate = DateTime.Now; dbma1.F006s.InsertOnSubmit(f006); dbma1.SubmitChanges(); string assetsDataStr = C101.FC10107(dbma1.VP301001s.Where(c => c.assetsSN == max33SN).First() as VP301001); return(string.Format("{{\"resStatus\":\"{0}\",\"assetsData\":{1}}}", "0", assetsDataStr)); } }
public void FP30104(string assetsSN) { using (DBMA1DataContext dbma1 = new DBMA1DataContext()) { //有效性检查(1、取消。2、预约) var data1 = dbma1.P300s.Where(c => c.assetsSN == assetsSN && c.cancelDate != null).FirstOrDefault(); var data2 = dbma1.P400s.Where(c => c.assetsSN == assetsSN).FirstOrDefault(); if (data1 != null || data2 != null) { return; } P300 p300 = dbma1.P300s.Where(c => c.assetsSN == assetsSN).First(); p300.cancelDate = DateTime.Now; dbma1.SubmitChanges(); } }