public string CreateCheckPlan(Dictionary <string, object> d) { List <string> SqlList = new List <string>(); string PLAN_ID = Guid.NewGuid().ToString(); string CheckPlanSql = "INSERT INTO wy_checkPlan (PLAN_ID,JHND,JHMC,JHSM,JHSJ,REMARK,CJR,CJSJ,IS_DELETE)values("; CheckPlanSql += GetSqlStr(PLAN_ID); CheckPlanSql += GetSqlStr(d["JHND"]); CheckPlanSql += GetSqlStr(d["JHMC"]); CheckPlanSql += GetSqlStr(d["JHSM"]); CheckPlanSql += GetSqlStr(d["JHSJ"]); CheckPlanSql += GetSqlStr(d["REMARK"]); CheckPlanSql += GetSqlStr(d["userId"]); CheckPlanSql += GetSqlStr(DateTime.Now.ToString("yyyyMMdd")); CheckPlanSql += GetSqlStr(0, 1); CheckPlanSql = CheckPlanSql.TrimEnd(',') + ")"; SqlList.Add(CheckPlanSql); foreach (Dictionary <string, object> CheckPlanDetail in JArray.FromObject(d["CheckPlanDetail"]).ToObject <List <Dictionary <string, object> > >()) { if (CheckPlanDetail.ContainsValue("")) { return("您输入的详细计划内有空值!请仔细修改后再提交表单"); } else { string PLAN_DETAIL_ID = Guid.NewGuid().ToString(); string DetailSql = "INSERT INTO wy_checkPlan_detail(PLAN_DETAIL_ID,PLAN_ID,JCQY,JCNR,JCLX,PCCS,CJR,CJSJ,IS_DELETE)VALUES("; string JHQYstr = ""; foreach (string jhqy in JArray.FromObject(CheckPlanDetail["JCQY"]).ToObject <string[]>()) { JHQYstr += jhqy + ","; string mapSql = "INSERT INTO wy_map_region(PLAN_DETAIL_ID,REGION_CODE)values("; mapSql += GetSqlStr(PLAN_DETAIL_ID); mapSql += GetSqlStr(jhqy); mapSql = mapSql.TrimEnd(',') + ")"; SqlList.Add(mapSql); } DetailSql += GetSqlStr(PLAN_DETAIL_ID); DetailSql += GetSqlStr(PLAN_ID); DetailSql += GetSqlStr(JHQYstr); DetailSql += GetSqlStr(CheckPlanDetail["JCNR"]); DetailSql += GetSqlStr(CheckPlanDetail["JCLX"]); DetailSql += GetSqlStr(CheckPlanDetail["PCCS"], 1); DetailSql += GetSqlStr(d["userId"]); DetailSql += GetSqlStr(DateTime.Now.ToString("yyyyMMdd")); DetailSql += GetSqlStr(0, 1); DetailSql = DetailSql.TrimEnd(',') + ")"; SqlList.Add(DetailSql); } } return(db.Executs(SqlList)); }
public string UpdateCheckPlan(Dictionary <string, object> d) { List <string> SqlList = new List <string>(); string CheckPlanSql = "UPDATE wy_checkPlan SET JHND=" + GetSqlStr(d["JHND"]); CheckPlanSql += "JHMC=" + GetSqlStr(d["JHMC"]); CheckPlanSql += "JHSM=" + GetSqlStr(d["JHSM"]); CheckPlanSql += "JHSJ=" + GetSqlStr(d["JHSJ"]); CheckPlanSql += "REMARK=" + GetSqlStr(d["REMARK"]); CheckPlanSql += "BJR=" + GetSqlStr(d["userId"]); CheckPlanSql += "BJSJ=" + GetSqlStr(DateTime.Now.ToString("yyyyMMdd")); CheckPlanSql += "IS_DELETE=" + GetSqlStr(0, 1); CheckPlanSql = CheckPlanSql.TrimEnd(','); CheckPlanSql += " WHERE PLAN_ID='" + d["PLAN_ID"] + "'"; SqlList.Add(CheckPlanSql); foreach (Dictionary <string, object> CheckPlanDetail in JArray.FromObject(d["CheckPlanDetail"]).ToObject <List <Dictionary <string, object> > >()) { if (!CheckPlanDetail.ContainsKey("PLAN_DETAIL_ID")) { if (CheckPlanDetail.ContainsValue("")) { return("您输入的详细计划内有空值!请仔细修改后再提交表单"); } else { string PLAN_DETAIL_ID = Guid.NewGuid().ToString(); string DetailSql = "INSERT INTO wy_checkPlan_detail(PLAN_DETAIL_ID,PLAN_ID,JCQY,JCNR,JCLX,PCCS,CJR,CJSJ,IS_DELETE)VALUES("; string JHQYstr = ""; foreach (string jhqy in JArray.FromObject(CheckPlanDetail["JCQY"]).ToObject <string[]>()) { JHQYstr += jhqy + ","; string mapSql = "INSERT INTO wy_map_region(PLAN_DETAIL_ID,REGION_CODE)values("; mapSql += GetSqlStr(PLAN_DETAIL_ID); mapSql += GetSqlStr(jhqy); mapSql = mapSql.TrimEnd(',') + ")"; SqlList.Add(mapSql); } DetailSql += GetSqlStr(PLAN_DETAIL_ID); DetailSql += GetSqlStr(d["PLAN_ID"]); DetailSql += GetSqlStr(JHQYstr); DetailSql += GetSqlStr(CheckPlanDetail["JCNR"]); DetailSql += GetSqlStr(CheckPlanDetail["JCLX"]); DetailSql += GetSqlStr(CheckPlanDetail["PCCS"], 1); DetailSql += GetSqlStr(d["userId"]); DetailSql += GetSqlStr(DateTime.Now.ToString("yyyyMMdd")); DetailSql += GetSqlStr(0, 1); DetailSql = DetailSql.TrimEnd(',') + ")"; SqlList.Add(DetailSql); } } else { //if (CheckPlanDetail.ContainsValue("")) //{ // return "您输入的详细计划内有空值!请仔细修改后再提交表单"; //} //else //{ if (CheckPlanDetail["IS_DELETE"].ToString() == "0") { string DelMapSql = "DELETE FROM wy_map_region WHERE PLAN_DETAIL_ID='" + CheckPlanDetail["PLAN_DETAIL_ID"] + "'"; SqlList.Add(DelMapSql); string JHQYstr = ""; foreach (string jhqy in JArray.FromObject(CheckPlanDetail["JCQY"]).ToObject <string[]>()) { JHQYstr += jhqy + ","; string mapSql = "INSERT INTO wy_map_region(PLAN_DETAIL_ID,REGION_CODE)values("; mapSql += GetSqlStr(CheckPlanDetail["PLAN_DETAIL_ID"]); mapSql += GetSqlStr(jhqy); mapSql = mapSql.TrimEnd(',') + ")"; SqlList.Add(mapSql); } string DetailSql = "UPDATE wy_checkPlan_detail SET JCQY=" + GetSqlStr(JHQYstr); DetailSql += " JCNR=" + GetSqlStr(CheckPlanDetail["JCNR"]); DetailSql += " JCLX=" + GetSqlStr(CheckPlanDetail["JCLX"]); DetailSql += " PCCS=" + GetSqlStr(CheckPlanDetail["PCCS"], 1); DetailSql += " BJR=" + GetSqlStr(d["userId"]); DetailSql += " BJSJ=" + GetSqlStr(DateTime.Now.ToString("yyyyMMdd")); DetailSql = DetailSql.TrimEnd(',') + " where PLAN_DETAIL_ID='" + CheckPlanDetail["PLAN_DETAIL_ID"] + "'"; SqlList.Add(DetailSql); } else { string DetailSql = "UPDATE wy_checkPlan_detail SET IS_DELETE=1 " + " where PLAN_DETAIL_ID='" + CheckPlanDetail["PLAN_DETAIL_ID"] + "'"; SqlList.Add(DetailSql); string DelMapSql = "DELETE FROM wy_map_region WHERE PLAN_DETAIL_ID='" + CheckPlanDetail["PLAN_DETAIL_ID"] + "'"; SqlList.Add(DelMapSql); } //} } } return(db.Executs(SqlList)); }