public static void UpdateUserTheme(UserCustomizeThemeVM ctheme)
{
var sql = "update UserCustomizeTheme set "
+ "Theme = '<Theme>', UpdateTime = '<UpdateTime>' "
+ "where MachineName = '<MachineName>'";
sql = sql.Replace("<Theme>", ctheme.Theme.ToString())
.Replace("<UpdateTime>", ctheme.UpdateTime)
.Replace("<MachineName>", ctheme.MachineName);
DBUtility.ExeLocalSqlNoRes(sql);
}
public static void CreateUserTheme(UserCustomizeThemeVM ctheme)
{
var sql = "insert into UserCustomizeTheme "
+ "(MachineName, Theme, CreateTime, UpdateTime) "
+ "values ('<MachineName>', '<Theme>', '<CreateTime>', '<UpdateTime>')";
sql = sql.Replace("<MachineName>", ctheme.MachineName)
.Replace("<Theme>", ctheme.Theme.ToString())
.Replace("<CreateTime>", ctheme.CreateTime)
.Replace("<UpdateTime>", ctheme.UpdateTime);
DBUtility.ExeLocalSqlNoRes(sql);
}
public static void UpdateTheme(UserCustomizeThemeVM ctheme)
{
var UserTheme = GetUserTheme(ctheme.MachineName);
if (UserTheme.ID > 0)
{
UpdateUserTheme(ctheme);
}
else
{
CreateUserTheme(ctheme);
}
}
public static UserCustomizeThemeVM GetUserTheme(string machine)
{
var sql = "select ID, MachineName, Theme, CreateTime, UpdateTime "
+ "from UserCustomizeTheme "
+ "where MachineName = '<MachineName>'";
sql = sql.Replace("<MachineName>", machine);
var dbret = DBUtility.ExeLocalSqlWithRes(sql);
var ret = new UserCustomizeThemeVM();
if (dbret.Count > 0)
{
ret.ID = Convert.ToInt32(dbret[0][0]);
ret.MachineName = Convert.ToString(dbret[0][1]);
ret.Theme = Convert.ToInt32(dbret[0][2]);
ret.CreateTime = Convert.ToString(dbret[0][3]);
ret.UpdateTime = Convert.ToString(dbret[0][4]);
}
return(ret);
}
