Easy image modification SQL code

Easy image modification SQL Code

Strsql. append ("Update usertemplate set ");
Strsql. append ("titleimg_path = case when Len (@ titleimg_path)> 0 then @ titleimg_path else titleimg_path end ,");
Strsql. append ("logo_path = case when Len (@ logo_path)> 0 then @ logo_path else logo_path end ,");
Strsql. append ("banner_1 = case when Len (@ banner_1)> 0 then @ banner_1 else banner_1 end ,");
Strsql. append ("banner_2 = @ banner_2 ,");
Strsql. append ("banner_3 = @ banner_3 ,");
Strsql. append ("defaultmodel = @ defaultmodel ,");
Strsql. append ("adddate = @ adddate,"); // fontstyle
Strsql. append ("fontstyle = @ fontstyle"); // fontstyle
Strsql. append ("where c_id = @ c_id ");