private string submitForm() { UserInfo userInfo = (UserInfo)Session["user"]; string formData = Request.Form["formData"]; string formName = Request.Form["formName"]; string id = Request.Form["id"]; JObject dt = JsonHelper.Json2DtbByLQ(formData); dt.Add("Level", "1"); dt.Add("Status", "审批中"); string docCode = GenerateDocCode.getYLFormCode(formName); dt.Add("DocCode", docCode); DateTime date = System.DateTime.Now; dt.Add("CreateTime", date.ToString()); string informerJSON = Request.Form["defaultInformer"]; string processJSON = Request.Form["processJson"]; return(FormBuilderHelper.saveFormRecord(formName, dt, processJSON, informerJSON, id, userInfo, docCode)); }
public static Dictionary <String, String> SaveNetSales(string hospital, string product, string sales, string netSalesNumber, string docCode, string time) { List <string> list = new List <string>(); string sql = string.Format("select Id from organization where name = '{0}'", hospital); list.Add(sql); sql = string.Format("select Id from products where name = '{0}'", product); list.Add(sql); sql = string.Format("select userId from users where userName = '******'", sales); list.Add(sql); string[] Ids = SqlHelper.Scalar(list.ToArray()); Dictionary <string, string> dict = new Dictionary <string, string>(); if (string.IsNullOrEmpty(Ids[0])) { dict.Add("returnMsg", "未找到医院信息"); return(dict); } else if (string.IsNullOrEmpty(Ids[1])) { dict.Add("returnMsg", "未找到产品信息"); return(dict); } else if (string.IsNullOrEmpty(Ids[2])) { dict.Add("returnMsg", "未找到业务员信息"); return(dict); } list.Clear(); sql = string.Format("select ManagerId from cost_sharing where HospitalId = {0} " + "and ProductId = {1} and SalesId={2}", Ids[0], Ids[1], Ids[2]); String ManagerId = ""; object obj = SqlHelper.Scalar(sql); if (obj != null) { ManagerId = obj.ToString(); } else { dict.Add("returnMsg", "未找到网点销售经理信息"); return(dict); } SqlExceRes res = null; // 判断是否之前有相同的单据,有则更新,没有则新增 if (docCode == null || "".Equals(docCode)) { docCode = GenerateDocCode.getDocCode(); dict.Add("HospitalId", Ids[0]); dict.Add("ProductId", Ids[1]); dict.Add("SalesId", Ids[2]); dict.Add("NetSalesNumber", netSalesNumber.ToString()); //dict.Add("ApproverId", ManagerId); //DateTime date = DateTime.Now.AddMonths(-1); dict.Add("CorrespondingTime", time); dict.Add("CreateTime", DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss")); dict.Add("State", "未提交"); dict.Add("Editable", "1"); dict.Add("DocCode", docCode); String insertSql = SqlHelper.GetInsertIgnoreString(dict, "net_sales"); res = new SqlExceRes(SqlHelper.Exce(insertSql)); } else { // 根据docCode来更新纯销数量 String updateSql = String.Format("update net_sales set NetSalesNumber = {0}, CorrespondingTime = '{1}' where DocCode = {2}", netSalesNumber.ToString(), time, docCode); res = new SqlExceRes(SqlHelper.Exce(updateSql)); } dict.Clear(); dict.Add("docCode", docCode); dict.Add("returnMsg", res.GetResultString("success", "单据已保存,请勿重复保存", "ErrorMsg:")); return(dict); }
private string uploadWageExcel() { DataTable dtExl = ExcelHelperV2_0.Import(Request, 3); DataTable dt = new DataTable(); if (dtExl.Rows.Count == 0) { return(JsonHelper.DataTable2Json(dt)); } // 再新增 int startId = 0; string sql = "select max(Id) from wages;"; object obj = SqlHelper.Scalar(sql); if (obj != null) { startId = Convert.ToInt32(obj) + 1; } dt.Columns.Add("Id"); dt.Columns.Add("DocCode"); dt.Columns.Add("Level"); dt.Columns.Add("Status"); dt.Columns.Add("Name"); dt.Columns.Add("Company"); dt.Columns.Add("Department"); dt.Columns.Add("Position"); dt.Columns.Add("AttendanceDay"); dt.Columns.Add("AbsenceDay"); dt.Columns.Add("PositionSalary"); dt.Columns.Add("SecretSalary"); dt.Columns.Add("LevelSalary"); dt.Columns.Add("TechnicalSalary"); dt.Columns.Add("StableSalary"); dt.Columns.Add("OtherSalary"); dt.Columns.Add("EducationAllowance"); dt.Columns.Add("OtherAllowance"); dt.Columns.Add("TotalStableSalary"); dt.Columns.Add("MonthlyPerformance"); dt.Columns.Add("QuarterlyPerformance"); dt.Columns.Add("YearlyPerformance"); dt.Columns.Add("ActualPerformance"); dt.Columns.Add("CSalesBonus"); dt.Columns.Add("QSalesBonus"); dt.Columns.Add("HeadBonus"); dt.Columns.Add("ManageBonus"); dt.Columns.Add("UnusualBonus"); dt.Columns.Add("TesterBonus"); dt.Columns.Add("OvertimeBonus"); dt.Columns.Add("ProductBonus"); dt.Columns.Add("GMBonus"); dt.Columns.Add("RDBonus"); dt.Columns.Add("OtherBonus1"); dt.Columns.Add("OtherBonus2"); dt.Columns.Add("TotalBonus"); dt.Columns.Add("TotalPerformanceBonus"); dt.Columns.Add("AttendaceFine"); dt.Columns.Add("SanitaryFine"); dt.Columns.Add("AbsenceFine"); dt.Columns.Add("ExpireFine"); dt.Columns.Add("ViolationFine"); dt.Columns.Add("OtherFine1"); dt.Columns.Add("OtherFine2"); dt.Columns.Add("TotalFine"); dt.Columns.Add("MutualFund"); dt.Columns.Add("OtherFund"); dt.Columns.Add("TotalFineAndFund"); dt.Columns.Add("TotalPay"); dt.Columns.Add("TotalPay1"); dt.Columns.Add("TotalPay2"); dt.Columns.Add("SocialInsurance"); dt.Columns.Add("SocialInsurance1"); dt.Columns.Add("PublicFund"); dt.Columns.Add("PublicFund1"); dt.Columns.Add("PersonalTax"); dt.Columns.Add("PersonalTax1"); dt.Columns.Add("Rent"); dt.Columns.Add("PersonalTaxAdjust"); dt.Columns.Add("PersonalTaxAdjust1"); dt.Columns.Add("ActualPay"); dt.Columns.Add("ActualPay1"); dt.Columns.Add("ActualPay2"); dt.Columns.Add("ActualPay2Decimal"); dt.Columns.Add("Remark"); dt.Columns.Add("SubmitterId"); dt.Columns.Add("Year"); dt.Columns.Add("Month"); dt.Columns.Add("CreateTime"); UserInfo user = (UserInfo)Session["user"]; string year = Request.Form["year"]; string month = Request.Form["month"]; string company = Request.Form["company"]; string docCode = GenerateDocCode.generateRandomDocCode(); foreach (DataRow dr in dtExl.Rows) { if (string.IsNullOrEmpty(dr["序号"].ToString()) || dr["序号"].ToString().Contains("合计")) { continue; } DataRow r = dt.NewRow(); r["SubmitterId"] = user.userId.ToString(); r["Year"] = year; r["Month"] = month; r["CreateTime"] = DateTime.Now; r["Company"] = company; r["Id"] = startId++; r["DocCode"] = docCode; r["Level"] = 1; r["Status"] = "审批中"; r["Name"] = dr["姓名"]; r["Department"] = dr["中心"].ToString() + dr["部门"] + dr["战区"] + dr["大区"] + dr["地区"]; r["Position"] = dr["职务"]; r["AttendanceDay"] = dr["考勤"]; r["AbsenceDay"] = dr["缺勤天数"]; r["PositionSalary"] = dr["职位工资"]; r["SecretSalary"] = dr["保密工资"]; r["LevelSalary"] = dr["档位工资"]; r["TechnicalSalary"] = dr["技衔工资"]; r["OtherSalary"] = dr["其他工资"]; r["StableSalary"] = dr["固定工资小计"]; r["EducationAllowance"] = dr["学历津贴"]; r["OtherAllowance"] = dr["其它津贴"]; r["TotalStableSalary"] = dr["固定工资合计"]; r["MonthlyPerformance"] = dr["月度绩效"]; r["QuarterlyPerformance"] = dr["季度绩效"]; r["YearlyPerformance"] = dr["年度绩效"]; r["ActualPerformance"] = dr["实发绩效"]; r["CSalesBonus"] = dr["纯销代表奖金"]; r["QSalesBonus"] = dr["渠道代表奖金"]; r["HeadBonus"] = dr["主管奖金"]; r["ManageBonus"] = dr["管理层奖金"]; r["UnusualBonus"] = dr["异样考核"]; r["TesterBonus"] = dr["实验奖金"]; r["OvertimeBonus"] = dr["加班"]; r["ProductBonus"] = dr["生产产能"]; r["GMBonus"] = dr["总经理特别贡献"]; r["RDBonus"] = dr["研发项目奖金"]; r["OtherBonus1"] = dr["其他奖励1"]; r["OtherBonus2"] = dr["其他奖励2"]; r["TotalBonus"] = dr["奖励合计"]; r["TotalPerformanceBonus"] = dr["绩效及奖励小计"]; r["AttendaceFine"] = dr["考勤扣款"]; r["SanitaryFine"] = dr["卫生检查罚款"]; r["AbsenceFine"] = dr["出勤扣款"]; r["ExpireFine"] = dr["产品过期罚款"]; r["ViolationFine"] = dr["违反制度罚款"]; r["OtherFine1"] = dr["其他罚款1"]; r["OtherFine2"] = dr["其他罚款2"]; r["TotalFine"] = dr["罚款合计"]; r["MutualFund"] = dr["代扣基金"]; r["OtherFund"] = dr["其它减项"]; r["TotalFineAndFund"] = dr["工资减项小计"]; r["TotalPay"] = dr["应发合计"]; r["TotalPay1"] = dr["应发1"]; r["TotalPay2"] = dr["应发2"]; r["SocialInsurance"] = dr["社保"]; r["SocialInsurance1"] = dr["社保1"]; r["PublicFund"] = dr["公积金"]; r["PublicFund1"] = dr["公积金1"]; r["PersonalTax"] = dr["个人所得税"]; r["PersonalTax1"] = dr["个人所得税1"]; r["Rent"] = dr["代扣房租"]; r["PersonalTaxAdjust"] = dr["个税调整项"]; r["PersonalTaxAdjust1"] = dr["个税调整项1"]; r["ActualPay"] = dr["实发合计工资"]; r["ActualPay1"] = dr["实发1"]; r["ActualPay2"] = dr["实发2"]; r["ActualPay2Decimal"] = dr["实发合计保留两位"]; r["Remark"] = dr["备注"]; dt.Rows.Add(r); } return(JsonHelper.DataTable2Json(dt)); }
private string uploadAmortizeExcel() { DataTable dtExl = ExcelHelperV2_0.Import(Request, 2); DataTable dt = new DataTable(); if (dtExl.Rows.Count == 0) { return(JsonHelper.DataTable2Json(dt)); } // 再新增 int startId = 0; string sql = "select max(Id) from tax;"; object obj = SqlHelper.Scalar(sql); if (obj != null) { startId = Convert.ToInt32(obj) + 1; } dt.Columns.Add("Id"); dt.Columns.Add("DocCode"); dt.Columns.Add("Level"); dt.Columns.Add("Status"); dt.Columns.Add("Company"); dt.Columns.Add("Type"); dt.Columns.Add("Project"); dt.Columns.Add("OriginValue"); dt.Columns.Add("CurrentA"); dt.Columns.Add("AccumulatedA"); dt.Columns.Add("FinalValue"); dt.Columns.Add("Remark"); dt.Columns.Add("SubmitterId"); dt.Columns.Add("Year"); dt.Columns.Add("Month"); dt.Columns.Add("CreateTime"); UserInfo user = (UserInfo)Session["user"]; string year = Request.Form["year"]; string month = Request.Form["month"]; string company = Request.Form["company"]; string docCode = GenerateDocCode.generateRandomDocCode(); foreach (DataRow dr in dtExl.Rows) { if (string.IsNullOrEmpty(dr["类型"].ToString()) || dr["类型"].ToString().Trim().Contains("合计") || dr["类型"].ToString().Contains("总经理")) { continue; } DataRow r = dt.NewRow(); r["SubmitterId"] = user.userId.ToString(); r["Year"] = year; r["Month"] = month; r["CreateTime"] = DateTime.Now; r["Company"] = company; r["Id"] = startId++; r["DocCode"] = docCode; r["Level"] = 1; r["Status"] = "审批中"; r["Type"] = dr["类型"]; r["Project"] = dr["项目"]; r["OriginValue"] = dr["原值"]; r["CurrentA"] = dr["本月摊销"]; r["AccumulatedA"] = dr["累计摊销"]; r["FinalValue"] = dr["期末余额"]; r["Remark"] = dr["备注"]; dt.Rows.Add(r); } return(JsonHelper.DataTable2Json(dt)); }
private string uploadInterestExcel() { DataTable dtExl = ExcelHelperV2_0.Import(Request, 2); DataTable dt = new DataTable(); if (dtExl.Rows.Count == 0) { return(JsonHelper.DataTable2Json(dt)); } // 再新增 int startId = 0; string sql = "select max(Id) from tax;"; object obj = SqlHelper.Scalar(sql); if (obj != null) { startId = Convert.ToInt32(obj) + 1; } dt.Columns.Add("Id"); dt.Columns.Add("DocCode"); dt.Columns.Add("Level"); dt.Columns.Add("Status"); dt.Columns.Add("Company"); dt.Columns.Add("Name"); dt.Columns.Add("LoanDate"); dt.Columns.Add("DueDate"); dt.Columns.Add("Frequency"); dt.Columns.Add("Amount"); dt.Columns.Add("YearRate"); dt.Columns.Add("MonthRate"); dt.Columns.Add("PaidInterest"); dt.Columns.Add("Proviston"); dt.Columns.Add("NotProviston"); dt.Columns.Add("PaidPrincipal"); dt.Columns.Add("ProvistonDate"); dt.Columns.Add("Remark"); dt.Columns.Add("LastPrincipal"); UserInfo user = (UserInfo)Session["user"]; string year = Request.Form["year"]; string month = Request.Form["month"]; string company = Request.Form["company"]; string docCode = GenerateDocCode.generateRandomDocCode(); foreach (DataRow dr in dtExl.Rows) { //if (string.IsNullOrEmpty(dr["税种"].ToString()) || dr["税种"].ToString().Trim().Contains("合 计") || dr["税种"].ToString().Contains("总经理")) // continue; DataRow r = dt.NewRow(); r["SubmitterId"] = user.userId.ToString(); r["Year"] = year; r["Month"] = month; r["CreateTime"] = DateTime.Now; r["Company"] = company; r["Id"] = startId++; r["DocCode"] = docCode; r["Level"] = 1; r["Status"] = "审批中"; r["Name"] = dr["名称"]; r["LoanDate"] = dr["借款时间"]; r["DueDate"] = dr["到期时间"]; r["Frequency"] = dr["利息支付频率"]; r["Amount"] = dr["借款金额"]; r["YearRate"] = dr["年利率"]; r["MonthRate"] = dr["月利息"]; r["PaidInterest"] = dr["已付银行利息"]; r["Proviston"] = dr["已计提"]; r["NotProviston"] = dr["还应计提"]; r["PaidPrincipal"] = dr["已还本金"]; r["ProvistonDate"] = dr["利息计提期间"]; r["Remark"] = dr["摘要"]; r["LastPrincipal"] = dr["期末结余本金"]; dt.Rows.Add(r); } return(JsonHelper.DataTable2Json(dt)); }
private string uploadOuterWageExcel() { DataTable dtExl = ExcelHelperV2_0.Import(Request, 2); DataTable dt = new DataTable(); if (dtExl.Rows.Count == 0) { return(JsonHelper.DataTable2Json(dt)); } // 再新增 int startId = 0; string sql = "select max(Id) from tax;"; object obj = SqlHelper.Scalar(sql); if (obj != null) { startId = Convert.ToInt32(obj) + 1; } dt.Columns.Add("Id"); dt.Columns.Add("DocCode"); dt.Columns.Add("Level"); dt.Columns.Add("Status"); dt.Columns.Add("Name"); dt.Columns.Add("Company"); dt.Columns.Add("Department"); dt.Columns.Add("Position"); dt.Columns.Add("WorkingHour"); dt.Columns.Add("WorkingPrice"); dt.Columns.Add("WorkingAmount"); dt.Columns.Add("TotalSalary"); dt.Columns.Add("ActualPerformance"); dt.Columns.Add("Bonus"); dt.Columns.Add("TotalPerformanceBonus"); dt.Columns.Add("RubbishFine"); dt.Columns.Add("ProductFine"); dt.Columns.Add("Fine"); dt.Columns.Add("MutualFund"); dt.Columns.Add("OtherFund"); dt.Columns.Add("TotalFineAndFund"); dt.Columns.Add("TotalPay"); dt.Columns.Add("SocialInsurance"); dt.Columns.Add("PublicFund"); dt.Columns.Add("PersonalTax"); dt.Columns.Add("Rent"); dt.Columns.Add("ActualPay"); dt.Columns.Add("ActualPay2Decimal"); dt.Columns.Add("Remark"); dt.Columns.Add("SubmitterId"); dt.Columns.Add("Year"); dt.Columns.Add("Month"); dt.Columns.Add("CreateTime"); UserInfo user = (UserInfo)Session["user"]; string year = Request.Form["year"]; string month = Request.Form["month"]; string company = Request.Form["company"]; string docCode = GenerateDocCode.generateRandomDocCode(); foreach (DataRow dr in dtExl.Rows) { if (string.IsNullOrEmpty(dr["序号"].ToString()) || dr["序号"].ToString().Contains("合计")) { continue; } DataRow r = dt.NewRow(); r["SubmitterId"] = user.userId.ToString(); r["Year"] = year; r["Month"] = month; r["CreateTime"] = DateTime.Now; r["Company"] = company; r["Id"] = startId++; r["DocCode"] = docCode; r["Level"] = 1; r["Status"] = "审批中"; r["Name"] = dr["姓名"]; r["Department"] = dr["部门"]; r["Position"] = dr["职位"]; r["WorkingHour"] = dr["出勤小时"]; r["WorkingPrice"] = dr["计件标准(元/件)"]; r["WorkingAmount"] = dr["计件数"]; r["TotalSalary"] = dr["计件工资合计"]; r["ActualPerformance"] = dr["实发绩效"]; r["Bonus"] = dr["奖励金额"]; r["TotalPerformanceBonus"] = dr["绩效及奖励小计"]; r["RubbishFine"] = dr["残次品扣款"]; r["ProductFine"] = dr["产品扣罚"]; r["Fine"] = dr["罚款"]; r["MutualFund"] = dr["代扣基金"]; r["OtherFund"] = dr["其它"]; r["TotalFineAndFund"] = dr["工资减项小计"]; r["TotalPay"] = dr["应发合计"]; r["SocialInsurance"] = dr["社保"]; r["PublicFund"] = dr["公积金"]; r["PersonalTax"] = dr["个人所得税"]; r["Rent"] = dr["代扣房租"]; r["ActualPay"] = dr["实发工资"]; r["ActualPay2Decimal"] = dr["保留两位"]; r["Remark"] = dr["备注"]; dt.Rows.Add(r); } return(JsonHelper.DataTable2Json(dt)); }
private string submitReimburse() { UserInfo user = (UserInfo)Session["user"]; string apply_time = Request.Form["apply_time"]; string product = Request.Form["product"]; string branch = Request.Form["branch"]; string fee_department = Request.Form["fee_department"]; string fee_company = Request.Form["fee_company"]; string fee_detail = Request.Form["fee_detail"]; string fee_amount = Request.Form["fee_amount"]; string file = Request.Form["file"]; string remark = SqlHelper.DesEncrypt(Request.Form["remark"]); string approver = Request.Form["approvers"]; string department = Request.Form["department"]; string informer = Request.Form["chooseInformerId"]; string approverData = Request.Form["approverData"]; string uploadFileUrls = Request.Form["uploadFileUrls"]; string docCode = Request.Form["docCode"]; string project = Request.Form["project"]; string isOverBudget = Request.Form["isOverBudget"];//是否是预算外的标志,1表示预算外,0表示预算内 string isPrepaid = Request.Form["isPrepaid"]; string isHasReceipt = Request.Form["isHasReceipt"]; string reimburseDetail = Request.Form["reimburseDetail"]; string travelCode = Request.Form["travelCode"]; string loanCode = Request.Form["loanCode"]; List <string> informerList = JsonHelper.DeserializeJsonToList <string>(informer); List <JObject> approverDataList = JsonHelper.DeserializeJsonToList <JObject>(approverData); List <string> uploadFileUrlsList = JsonHelper.DeserializeJsonToList <string>(uploadFileUrls); List <JObject> reimburseDetailList = JsonHelper.DeserializeJsonToList <JObject>(reimburseDetail); string msg = ""; JObject res = ReimbursementManage.IsOverBudget(fee_department, fee_detail, Convert.ToDouble(fee_amount) , Convert.ToDateTime(apply_time)); if (res == null || Convert.ToDouble(res["budget"]) >= Convert.ToDouble(res["hasApprove"]) + Convert.ToDouble(fee_amount) || isOverBudget == "1") { msg = MobileReimburseManage.insertMobileReimburse(apply_time, product, branch, fee_department, fee_detail, fee_amount, file, remark, user, approver, department, informerList, approverDataList, uploadFileUrlsList, docCode, project, isOverBudget, isPrepaid, isHasReceipt, reimburseDetailList, fee_company, travelCode, loanCode); } else { string code = GenerateDocCode.getReimburseCode(); if (department == null || "".Equals(department)) { department = MobileReimburseSrv.findDepartmentNameByWechatUserId(user.wechatUserId).Tables[0].Rows[0][0].ToString(); } if (string.IsNullOrEmpty(docCode)) { MobileReimburseSrv.insertMobileReimburse(code, apply_time, product, branch, fee_department, fee_detail, fee_amount, file, remark, user, approver, department, project, isOverBudget, isPrepaid, isHasReceipt, fee_company, ""); SqlHelper.Exce(string.Format("update yl_reimburse set status = '草稿' where code = '{0}'", code)); } msg = "本月预算为" + res["budget"].ToString() + ",已用" + res["hasApprove"].ToString() + ",预算不足,请减少申请金额或者走预算外报销申请," + code; } return(msg); }
public static string submissionOfCostSharingUpdating(JObject jObject, UserInfo userInfo) { JObject costSharingRecordJObject = new JObject(); string code = GenerateDocCode.getUpdateCostSharingCode(); costSharingRecordJObject.Add("Code", code); costSharingRecordJObject.Add("NewCostSharingId", jObject["newCostSharingId"]); costSharingRecordJObject.Add("SubmitterUserId", userInfo.userId.ToString()); costSharingRecordJObject.Add("InsertOrUpdate", 1); costSharingRecordJObject.Add("State", "审批中"); costSharingRecordJObject.Add("Level", 1); costSharingRecordJObject.Add("CreateTime", DateTime.Now); // 获取下级审批人 string findApproverUserIdSql = string.Format("(select case when ((select directorId from new_cost_sharing where id = {0}) " + "is not null and (select directorId from new_cost_sharing where id = {0}) != '100000145' " + "and (select managerId from new_cost_sharing where id = {0}) != '100000154' " + "and (select managerId from new_cost_sharing where id = {0}) != '100000180') " + "then (SELECT DirectorId FROM `new_cost_sharing` where id = {0}) " + "else (SELECT managerId FROM `new_cost_sharing` where id = {0}) end ApproverUserId)", jObject["newCostSharingId"]); costSharingRecordJObject.Add("ApproverUserId", findApproverUserIdSql); List <string> withoutQuoteColumn = new List <string>(); withoutQuoteColumn.Add("ApproverUserId"); JObject InsertAndGetLastIdJObject = JsonHelper.DeserializeJsonToObject <JObject>(SqlHelper.InsertAndGetLastId( SqlHelper.GetInsertStringWithoutQuotes(costSharingRecordJObject, "cost_sharing_record", withoutQuoteColumn))); JObject resJObject = new JObject(); // 找到刚插入的记录的id if ("1".Equals(InsertAndGetLastIdJObject["Success"].ToString()) || "-1".Equals(InsertAndGetLastIdJObject["Id"].ToString())) { resJObject.Add("ErrCode", 3); resJObject.Add("ErrMsg", "数据库插入失败"); return(resJObject.ToString()); } string lastId = InsertAndGetLastIdJObject["Id"].ToString(); // 获取页面上修改后的所有值 JObject detailJObject = JsonHelper.DeserializeJsonToObject <JObject>(jObject["detail"].ToString()); JObject detailJObjectForInsert = new JObject(); detailJObjectForInsert.Add("RegistrationCode", code); detailJObjectForInsert.Add("Level", 0); detailJObjectForInsert.Add("ApproverUserId", userInfo.userId.ToString()); detailJObjectForInsert.Add("CreateTime", DateTime.Now); List <string> detailJObjectForInsertSqls = new List <string>(); foreach (var key in detailJObject) { if (key.Key.Contains("Id")) { continue; } detailJObjectForInsert.Remove("FieldName"); detailJObjectForInsert.Add("FieldName", key.Key); detailJObjectForInsert.Remove("NewValue"); detailJObjectForInsert.Add("NewValue", detailJObject[key.Key + "Id"]); detailJObjectForInsert.Remove("OldValue"); detailJObjectForInsert.Add("OldValue", detailJObject[key.Key]); string sql = SqlHelper.GetInsertString(detailJObjectForInsert, "cost_sharing_detail"); detailJObjectForInsertSqls.Add(sql); } SqlExceRes res = new SqlExceRes(SqlHelper.Exce(detailJObjectForInsertSqls.ToArray())); if (res.Result == SqlExceRes.ResState.Success) { // 插入成功 resJObject.Add("ErrCode", 0); resJObject.Add("ErrMsg", "修改成功"); } else { // 插入失败 resJObject.Add("ErrCode", 3); resJObject.Add("ErrMsg", "修改失败"); } return(resJObject.ToString()); }