public void SaveUserFieldGroup(string uid, FieldsSettingModel fieldsSettingModel)
{
string strSql = "DELETE FROM SYS_FieldGroupDetail WHERE UID = @UID AND GroupID = @GroupID";
DbHelperSQL.Query(strSql, new SqlParameter[] { new SqlParameter("@UID", uid), new SqlParameter("@GroupID", GroupID) });
strSql = "INSERT INTO SYS_FieldGroupDetail(GroupID, FieldID, UID, Sort) VALUES(@GroupID, @FieldID, @UID, @Sort)";
if (fieldsSettingModel.FieldIds != null)
{
for (int i = 0; i < fieldsSettingModel.FieldIds.Length; i++)
{
string fieldId = fieldsSettingModel.FieldIds[i];
if (!String.IsNullOrEmpty(fieldId))
{
SqlParameter[] ps =
{
new SqlParameter("@GroupID", this.GroupID),
new SqlParameter("@FieldID", fieldsSettingModel.FieldIds[i]),
new SqlParameter("@UID", uid),
new SqlParameter("@Sort", i)
};
DbHelperSQL.ExecuteSql(strSql, ps);
}
}
}
}
public JsonResult SaveListFields(FieldsSettingModel postModel)
{
string errMessage = "";
try
{
FieldGroup fg = new FieldGroup(postModel.ListName);
fg.SaveUserFieldGroup(AccessControl.CurrentLogonUser.Uid, postModel);
}
catch (Exception ex)
{
errMessage = ex.Message;
}
var result = new
{
success = (errMessage == "" ? true : false),
errMessage = errMessage
};
return Json(result);
}