public static ReturnValue add(ModuleInfo info, UserInfo user)
{
ReturnValue err = new ReturnValue();
#region 验证
if (info.moduleName.Trim() == "")
{
err.errNo = -1;
err.errMsg = "栏目名不能为空";
return(err);
}
if (info.dirName.Trim() == "")
{
err.errNo = -1;
err.errMsg = "目录名不能为空";
return(err);
}
#endregion
info.id = double.Parse(Tools.GetId());
int count = int.Parse(Sql.ExecuteScalar("select count(1) from module where dirName=@dirName", new MySqlParameter[] {
new MySqlParameter("dirName", info.dirName.ToLower())
}).ToString());
if (count > 0)
{
throw new Exception("频道目录名已存在");
}
if (info.type)
{
ColumnInfo column = new ColumnInfo();
column.id = info.id;
column.className = info.moduleName;
column.classId = 7;
column.moduleId = info.id;
column.custom = info.custom;
column.thumbnailWidth = info.thumbnailWidth;
column.thumbnailHeight = info.thumbnailHeight;
column.thumbnailForce = info.thumbnailForce;
column.saveRemoteImages = info.saveRemoteImages;
column.inherit = info.inherit;
column.dirName = info.dirName;
column.saveDataType = info.saveDataType;
column.titleRepeat = info.titleRepeat;
ColumnClass.add(column, user);
}
Sql.ExecuteNonQuery("insert into module " +
"(id,moduleName,type,saveDataType,dirName,createDate,updateDate,custom,thumbnailWidth,thumbnailHeight,thumbnailForce,saveRemoteImages,orderId,titleRepeat,watermark)" +
"values" +
"(@id,@moduleName,@type,@saveDataType,@dirName,@createDate,@updateDate,@custom,@thumbnailWidth,@thumbnailHeight,@thumbnailForce,@saveRemoteImages,@orderId,@titleRepeat,@watermark)"
, new MySqlParameter[] {
new MySqlParameter("id", info.id),
new MySqlParameter("moduleName", info.moduleName),
new MySqlParameter("type", info.type),
new MySqlParameter("saveDataType", info.saveDataType),
new MySqlParameter("dirName", info.dirName),
new MySqlParameter("createDate", info.createDate),
new MySqlParameter("updateDate", info.updateDate),
new MySqlParameter("custom", info.custom),
new MySqlParameter("thumbnailWidth", info.thumbnailWidth),
new MySqlParameter("thumbnailHeight", info.thumbnailHeight),
new MySqlParameter("thumbnailForce", info.thumbnailForce),
new MySqlParameter("saveRemoteImages", info.saveRemoteImages),
new MySqlParameter("orderId", info.orderId),
new MySqlParameter("titleRepeat", info.titleRepeat),
new MySqlParameter("watermark", info.watermark)
}
);
err.userData = info.id;
return(err);
}
public static ReturnValue edit(ModuleInfo info, UserInfo user)
{
ReturnValue err = new ReturnValue();
#region 验证
if (info.moduleName.Trim() == "")
{
err.errNo = -1;
err.errMsg = "模块名不能为空";
return(err);
}
#endregion
if (info.id > 0)
{
Sql.ExecuteNonQuery("update module " +
"set id=@id,moduleName=@moduleName,saveDataType=@saveDataType,updateDate=@updateDate,custom=@custom,thumbnailWidth=@thumbnailWidth,thumbnailHeight=@thumbnailHeight,thumbnailForce=@thumbnailForce,saveRemoteImages=@saveRemoteImages,titleRepeat=@titleRepeat,watermark=@watermark" +
" where id=@id"
, new MySqlParameter[] {
new MySqlParameter("id", info.id),
new MySqlParameter("moduleName", info.moduleName),
new MySqlParameter("saveDataType", info.saveDataType),
new MySqlParameter("createDate", info.createDate),
new MySqlParameter("updateDate", info.updateDate),
new MySqlParameter("custom", info.custom),
new MySqlParameter("thumbnailWidth", info.thumbnailWidth),
new MySqlParameter("thumbnailHeight", info.thumbnailHeight),
new MySqlParameter("thumbnailForce", info.thumbnailForce),
new MySqlParameter("saveRemoteImages", info.saveRemoteImages),
new MySqlParameter("titleRepeat", info.titleRepeat),
new MySqlParameter("watermark", info.watermark)
}
);
if (info.type)
{
Sql.ExecuteNonQuery("update class " +
"set className=@className,classId=@classId,moduleId=@moduleId,rootId=@rootId,custom=@custom,thumbnailWidth=@thumbnailWidth,thumbnailHeight=@thumbnailHeight,thumbnailForce=@thumbnailForce,saveRemoteImages=@saveRemoteImages,inherit=@inherit,updateDate=@updateDate,dirName=@dirName,dirPath=@dirPath,keyword=@keyword,info=@info,domainName=@domainName,_domainName=@_domainName,titleRepeat=@titleRepeat where id=@id", new MySqlParameter[] {
new MySqlParameter("id", info.id),
new MySqlParameter("className", info.moduleName),
new MySqlParameter("classId", 7),
new MySqlParameter("moduleId", info.id),
new MySqlParameter("rootId", info.id),
new MySqlParameter("custom", info.custom),
new MySqlParameter("thumbnailWidth", info.thumbnailWidth),
new MySqlParameter("thumbnailHeight", info.thumbnailHeight),
new MySqlParameter("thumbnailForce", info.thumbnailForce),
new MySqlParameter("saveRemoteImages", info.saveRemoteImages),
new MySqlParameter("inherit", info.inherit),
new MySqlParameter("createDate", info.createDate),
new MySqlParameter("updateDate", info.updateDate),
new MySqlParameter("dirName", info.dirName),
new MySqlParameter("dirPath", info.dirName),
new MySqlParameter("keyword", info.keyword),
new MySqlParameter("info", info.info),
new MySqlParameter("domainName", info.domainName),
new MySqlParameter("_domainName", info._domainName),
new MySqlParameter("titleRepeat", info.titleRepeat)
});
}
}
else
{
err = add(info, user);
return(err);
}
err.userData = info.id;
return(err);
}
