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