internal string SetCommonSettings(CommonSettings commonSettings,bool Exist)
{
string val = JsonConvert.SerializeObject(commonSettings);
if (Exist)
{
return string.Format("update commonsetting set jsonsettinginfodata='{0}'", val);
}
else
{
return string.Format("insert into commonsetting(jsonsettinginfodata) values('{0}')", val);
}
}
public int SetCommonSettingInfo(string AuthKey, string serviceURL, CommonSettings CommonSettings)
{
if (!securityManager.CheckSecurityToken(AuthKey))
{
throw new Exception("인증된 사용자가 아닙니다");
}
//기존 정보가 있는지 검증
bool Exist = false;
DataTable dt = DBController.getInstance().GetData(serviceURL, new CommonSettingsQuery().GetCommonSettings());
if (dt != null && dt.Rows.Count > 0)
{
Exist = true;
}
string Query = new CommonSettingsQuery().SetCommonSettings(CommonSettings, Exist);
return DBController.getInstance().SetData(serviceURL, Query);
}