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