public string Save() { string masterId = System.Web.HttpContext.Current.Request.Form["masterid"]; string masterdata = System.Web.HttpContext.Current.Request.Form["masterData"]; string sysdata = System.Web.HttpContext.Current.Request.Form["sysdata"]; string userdata = System.Web.HttpContext.Current.Request.Form["userdata"]; string detailtabledata = System.Web.HttpContext.Current.Request.Form["detailtabledata"]; string queryPropData = System.Web.HttpContext.Current.Request.Form["queryPropData"]; string richQueryData = System.Web.HttpContext.Current.Request.Form["richQueryData"]; DataTable masterdt = new DataTable(); DataTable sysdt = new DataTable(); DataTable userdt = new DataTable(); DataTable detaildt = new DataTable(); DataTable queryPropDt = new DataTable(); DataTable richQueryDt = new DataTable(); if (!string.IsNullOrWhiteSpace(masterdata)) { masterdt = DataConverterHelper.ToDataTable(masterdata, "select * from fg_helpinfo_master"); } if (!string.IsNullOrWhiteSpace(sysdata)) { sysdt = DataConverterHelper.ToDataTable(sysdata, "select * from fg_helpinfo_sys"); } if (!string.IsNullOrWhiteSpace(userdata)) { userdt = DataConverterHelper.ToDataTable(userdata, "select * from fg_helpinfo_user"); } if (!string.IsNullOrWhiteSpace(queryPropData)) { queryPropDt = DataConverterHelper.ToDataTable(queryPropData, "select * from fg_helpinfo_queryprop"); } if (!string.IsNullOrWhiteSpace(richQueryData)) { richQueryDt = DataConverterHelper.ToDataTable(richQueryData, "select * from fg_helpinfo_richquery"); } if (!string.IsNullOrWhiteSpace(detailtabledata)) { detaildt = DataConverterHelper.ToDataTable(detailtabledata, "select * from fg_helpinfo_detailtable"); } CommonHelpSettingEntity entity = new CommonHelpSettingEntity(); entity.MasterDt = masterdt; entity.SystemFieldDt = sysdt; entity.UserFieldDt = userdt; entity.QueryProperty = queryPropDt; entity.RichQuery = richQueryDt; entity.DetailDt = detaildt; ResponseResult result = proxy.Save(masterId, entity); string response = JsonConvert.SerializeObject(result); return(response); }
public ResponseResult Save(string masterID, CommonHelpSettingEntity entity) { ResponseResult result = new ResponseResult(); int iret = dac.Save(masterID, entity); if (iret > 0) { result.Status = ResponseStatus.Success; } else { result.Status = ResponseStatus.Error; } return(result); }
public int Save(string masterID, CommonHelpSettingEntity entity) { //处理查询条件的单引号 //entity.MasterDt.Rows[0]["sqlfilter"] = HttpUtility.UrlEncode(entity.MasterDt.Rows[0]["sqlfilter"].ToString()); foreach (DataRow dr in entity.UserFieldDt.Rows) { if (dr.RowState == DataRowState.Deleted) { continue; } if (dr.RowState == DataRowState.Added) { dr["code"] = Guid.NewGuid().ToString(); dr["masterid"] = masterID; } } foreach (DataRow dr in entity.DetailDt.Rows) { if (dr.RowState == DataRowState.Deleted) { continue; } if (dr.RowState == DataRowState.Added) { dr["code"] = Guid.NewGuid().ToString(); dr["masterid"] = masterID; } } foreach (DataRow dr in entity.QueryProperty.Rows) { if (dr.RowState == DataRowState.Deleted) { continue; } if (dr.RowState == DataRowState.Added) { dr["code"] = Guid.NewGuid().ToString(); dr["masterid"] = masterID; } if (!string.IsNullOrWhiteSpace(dr["tree_sql"].ToString())) { //dr["tree_sql"] = HttpUtility.UrlEncode(dr["tree_sql"].ToString()); } } foreach (DataRow dr in entity.RichQuery.Rows) { if (dr.RowState == DataRowState.Deleted) { continue; } if (dr.RowState == DataRowState.Added) { dr["code"] = Guid.NewGuid().ToString(); dr["masterid"] = masterID; } } int iret = 0; iret = DbHelper.Update(entity.MasterDt, "select * from fg_helpinfo_master"); iret += DbHelper.Update(entity.SystemFieldDt, "select * from fg_helpinfo_sys"); iret += DbHelper.Update(entity.UserFieldDt, "select * from fg_helpinfo_user"); iret += DbHelper.Update(entity.DetailDt, "select * from fg_helpinfo_detailtable"); iret += DbHelper.Update(entity.QueryProperty, "select * from fg_helpinfo_queryprop"); iret += DbHelper.Update(entity.RichQuery, "select * from fg_helpinfo_richquery"); return(iret); }