方便的图片修改Sql代码

方便的图片修改Sql代码

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

转载于:https://www.cnblogs.com/bestsaler/archive/2009/04/13/1835690.html