/// <summary>
/// 保存频道修改/添加
/// </summary>
protected void UserGroupSave()
{
mUG.Title = this.Title.Text;
mUG.ParentId = StringDeal.ToInt(this.ParentId.Text);
mUG.Note = this.Note.Text;
mUG.Model = StringDeal.ToInt(this.Model.Text);
mUG.RegIntegral = StringDeal.ToInt(this.RegIntegral.Text);
mUG.LoginIntegral = StringDeal.ToInt(this.LoginIntegral.Text);
mUG.Collection = StringDeal.ToInt(this.Collection.Text);
mUG.Invite = StringDeal.ToInt(this.Invite.Text);
mUG.RegState = StringDeal.ToBool(this.RegState.Text);
mUG.GroupSetting = StringDeal.StrFormat(Request.Form["GroupSetting"]);
if (mUG.Id > 0)
{
if (bUG.UserGroupUpdate(mUG) == 1)
{
StringDeal.Alter("父级用户组不能为其本身！");
}
}
else
{
bUG.UserGroupInsert(mUG);
}
StringDeal.Alter("保存完成！", "UserGroup_Manage.aspx");
}
/// <summary>
/// 添加字段
/// </summary>
/// <param name="Info"></param>
public bool FieldInsert(mField Info)
{
SqlParameter[] par = new SqlParameter[]
{
new SqlParameter("@TableName", Info.TableName),
new SqlParameter("@Field", Info.Field),
new SqlParameter("@Title", Info.Title),
new SqlParameter("@Note", Info.Note),
new SqlParameter("@Prompt", Info.Prompt),
new SqlParameter("@Type", Info.Type)
};
return(StringDeal.ToBool(SQLHelper.ExecuteNonQuery("FieldInsert", par)));
}
/// <summary>
/// 保存管理员信息
/// </summary>
protected void AdminSave()
{
mA.GroupId = StringDeal.ToInt(this.GroupId.Text);
mA.UserName = this.UserName.Text;
mA.UserPwd = Encryp.DESEncrypt(this.UserPwd.Text);
mA.TrueName = this.TrueName.Text;
mA.Tel = this.Tel.Text;
mA.Email = this.Email.Text;
mA.IsModifyPassword = StringDeal.ToBool(this.IsModifyPassword.Text);
mA.IsMultiLogin = StringDeal.ToBool(this.IsMultiLogin.Text);
if (mA.Id == 0)
{
bA.AdminInsert(mA);
}
else
{
bA.AdminUpdate(mA);
}
StringDeal.Alter("保存完成！", "Admin_Manage.aspx");
}
/// <summary>
/// 根据ID读取单条管理员信息
/// </summary>
/// <param name="Info"></param>
/// <returns></returns>
public IList <mAdmin> AdminReader(mAdmin Info)
{
IList <mAdmin> list = new List <mAdmin>();
using (SqlDataReader dr = SQLHelper.ExecuteReader("AdminRead", Info.Id))
{
if (dr.Read())
{
mAdmin mA = new mAdmin();
mA.GroupId = StringDeal.ToInt(dr[0]);
mA.UserName = dr[1].ToString();
mA.UserPwd = dr[2].ToString();
mA.TrueName = dr[3].ToString();
mA.Tel = dr[4].ToString();
mA.Email = dr[5].ToString();
mA.IsModifyPassword = StringDeal.ToBool(dr[6]);
mA.IsMultiLogin = StringDeal.ToBool(dr[7]);
list.Add(mA);
}
}
return(list);
}
/// <summary>
/// 根据ID读取单个用户组信息
/// </summary>
/// <param name="Info"></param>
/// <returns></returns>
public IList <mUserGroup> UserGroupReader(mUserGroup Info)
{
IList <mUserGroup> list = new List <mUserGroup>();
using (SqlDataReader dr = SQLHelper.ExecuteReader("UserGroupRead", Info.Id))
{
if (dr.Read())
{
mUserGroup mUG = new mUserGroup();
mUG.Title = dr[0].ToString();
mUG.ParentId = StringDeal.ToInt(dr[1]);
mUG.Note = dr[2].ToString();
mUG.Model = StringDeal.ToInt(dr[3]);
mUG.RegIntegral = StringDeal.ToInt(dr[4]);
mUG.LoginIntegral = StringDeal.ToInt(dr[5]);
mUG.Collection = StringDeal.ToInt(dr[6]);
mUG.Invite = StringDeal.ToInt(dr[7]);
mUG.RegState = StringDeal.ToBool(dr[8]);
mUG.GroupSetting = dr[9].ToString();
list.Add(mUG);
}
}
return(list);
}
/// <summary>
/// 判断数据库中是否存在某表名
/// </summary>
/// <param name="Info"></param>
/// <returns></returns>
public bool IsTable(mTable Info)
{
return(StringDeal.ToBool(SQLHelper.ExecuteScalar("IsExistTable", Info.TableName)));
}
/// <summary>
/// 获取模型是否为系统模型
/// </summary>
/// <param name="Info"></param>
/// <returns></returns>
public bool GetIsSystem(mTable Info)
{
return(StringDeal.ToBool(SQLHelper.ExecuteScalar("GetTableIsSystem", Info.Id)));
}
/// <summary>
/// 提交后保存
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void btnUpload_Click(object sender, EventArgs e)
{
// mapFilePath = HttpContext.Current.Server.MapPath(filePath);
string UploadImageName = "";
string UploadType = Request.Form["Upload"]; //图片方式
int ImageSize = StringDeal.ToInt(GetConfig.Image("ImageSize")); //图片最大上传
string UploadImagePath = GetConfig.Image("UploadImagePath"); //图片上传路径
string ImageType = GetConfig.Image("ImageType"); //允许图片类型
bool IsThumbnail = StringDeal.ToBool(Request.Form["IsThumbnail"]); //是否生成缩略图
int ThumbWidth = StringDeal.ToInt(Request.Form["ThumbWidth"]); //缩略图宽
int ThumbHeight = StringDeal.ToInt(Request.Form["ThumbHeight"]); //缩略图高
string ThumbMode = Request.Form["ThumbMode"];
bool IsWatermark = StringDeal.ToBool(Request.Form["IsWatermark"]); //加水印
string WatermarkImage = GetConfig.Image("WatermarkImage"); //水印图地址
int WatermarkPos = StringDeal.ToInt(GetConfig.Image("WatermarkPos")); //水印放置位置
string SelectImage = Request.Form["SelectImage"]; //选择服务器上的图片名
string WebUrl = Request.Form["WebUrl"]; //网络图片地址
if (String.IsNullOrEmpty(UploadImagePath))
{
UploadImagePath = "../../Upload/image/";
}
if (ImageSize == 0)
{
ImageSize = 1020000;
}
else
{
ImageSize = ImageSize * 1024;
}
if (String.IsNullOrEmpty(ImageType))
{
ImageType = "jpg,gif,png,bmp,jpeg";
}
if (UploadType == "upload1")
{
UploadImagePath = UploadImagePath + DateTime.Today.ToString("yyyyMM") + "/";
Files.CreateFolder(UploadImagePath);
#region 大文件上传
try
{
foreach (Telerik.WebControls.UploadedFile file in RadUploadContext.Current.UploadedFiles)
{
System.Drawing.Image image = System.Drawing.Image.FromStream(file.InputStream);
if (file.FileName != "")
{
if (file.ContentLength > ImageSize)
{
StringDeal.Alter("文件大小不能超过" + ImageSize / 1024 + "KB");
}
else if (StringDeal.GetExtNameIsArry(ImageType.Split(','), file.FileName))
{
string FileExt = file.GetExtension();
System.Threading.Thread.Sleep(1000);
string FileName = StringDeal.GetGuid() + FileExt;
file.SaveAs(this.Server.MapPath(UploadImagePath + FileName), true);
Response.StatusCode = 200;
#region 生成缩略图
if (IsThumbnail)
{
Thumbnail th = new Thumbnail();
th.Mode = ThumbMode;
th.FileName = FileName;
th.OriginalImagePath = UploadImagePath;
th.Width = ThumbWidth;
th.Height = ThumbHeight;
th.MakeThumbnail();
}
#endregion
UploadImageName = UploadImagePath + FileName;
}
else
{
StringDeal.Alter("上传图片格式不正确！");
}
}
image.Dispose();
}
}
catch
{
}
#endregion
}
else if (UploadType == "upload2")
{
#region 择服务器上的保存
if (IsThumbnail)
{
if (SelectImage != string.Empty)
{
if (!HXD.Common.Utils.IsUrl(SelectImage))
{
if (HXD.Common.Utils.isPhotoIco(SelectImage))
{
System.IO.File.Delete(Server.MapPath("~" + HXD.Common.Utils.PhotoIco(SelectImage)));
}
string FileName = string.Empty;
FileName = SelectImage.Substring(SelectImage.LastIndexOf('/') + 1);
UploadImagePath = SelectImage.Remove(SelectImage.LastIndexOf('/') + 1);
Thumbnail th = new Thumbnail();
th.Mode = ThumbMode;
th.FileName = FileName;
th.OriginalImagePath = UploadImagePath;
th.Width = ThumbWidth;
th.Height = ThumbHeight;
th.MakeThumbnail();
}
}
}
UploadImageName = SelectImage;
#endregion
}
else
{
#region 输入网络图片地址保存
UploadImageName = WebUrl;
#endregion
}
Response.Write("<script language='javascript' type='text/javascript'>window.parent.loadinndlg().document.getElementById('" + InputName + "').value='" + UploadImageName + "';window.parent.cancel();</script>");
}
/// <summary>
/// 栏目列表信息遍历
/// </summary>
/// <param name="ParentId"></param>
/// <param name="Line"></param>
protected void MenuListBind(int ParentId, string Line)
{
DataView dv = new DataView(dsList.Tables[0]);
dv.RowFilter = "ParentId = " + ParentId;
foreach (DataRowView dr in dv)
{
MenuList += "<tr onMouseOver=\"over()\" onClick=\"change()\" onMouseOut=\"out()\" class=\"td_bg\">\n";
MenuList += "<td align=\"center\">" + dr[0] + "</td>\n";
foreach (string j in GetField())
{
MenuList += "<td>";
if (Getnext(Convert.ToInt32(dr[0])))
{
MenuList += "<a href='../Model/Model_Manage.aspx?MenuId=" + dr[0] + "'>";
}
if (j == "Title")
{
MenuList += Line + bM.GetMenuIsSub((int)dr[0]);
}
MenuList += StringDeal.StrFormat(dr[j]);
if (Getnext(Convert.ToInt32(dr[0])))
{
MenuList += "</a>";
}
MenuList += "</td>\n";
}
if (MenuId == 0)
{
MenuList += "<td align=\"center\" nowrap=\"nowrap\"><a href=\"MenuModel_Set.aspx?Id=" + dr[0] + "\" title=\"设置此栏目以及下属栏目的所需要字段\">栏目</a> <a href=\"Model_Set.aspx?Id=" + dr[0] + "\" title=\"设置此栏目以及下属栏目信息的所需要字段\">信息</a></td>";
}
MenuList += "<td align=\"center\" nowrap=\"nowrap\">";
MenuList += "<a href=\"?MenuId=" + MenuId + "&Action=up&Id=" + dr[0] + "\">上移</a>";
MenuList += " <a href=\"?MenuId=" + MenuId + "&Action=down&Id=" + dr[0] + "\">下移</a>";
MenuList += " <a href=\"?MenuId=" + MenuId + "&Action=top&Id=" + dr[0] + "\">" + StringDeal.GetTop(StringDeal.ToBool(dr["IsTop"]), "栏目") + "</a>";
MenuList += " <a href=\"?MenuId=" + MenuId + "&Action=lock&Id=" + dr[0] + "\">" + StringDeal.GetLock(StringDeal.ToBool(dr["IsLock"]), "栏目") + "</a>";
MenuList += " <a href=\"Menu_Edit.aspx?MenuId=" + MenuId + "&Id=" + dr[0] + "\">修改</a>";
MenuList += " <a onClick=\"return confirm('确认删除')\" href=\"?MenuId=" + MenuId + "&Action=del&Id=" + dr[0] + "\">删除</a>";
MenuList += "</td>\n</tr>\n";
MenuListBind(StringDeal.ToInt(dr[0]), "<img alt=\"\" src=\"../skin/01/ico/tree_treemiddle.gif\" width=\"18\" height=\"18\" align=\"absmiddle\">" + Line);
}
Depth++;
}
/// <summary>
/// 获取用户锁定状态
/// </summary>
/// <returns></returns>
public bool GetUserLock(mUser Info)
{
return(StringDeal.ToBool(SQLHelper.ExecuteScalar("GetUserLock", Info.Id)));
}
/// <summary>
/// 字段信息保存
/// </summary>
protected void FieldSave()
{
//获取入库的信息
mF.Field = this.Field.Text;
mF.Title = this.Title.Text;
mF.Note = this.Note.Text;
mF.Prompt = this.Prompt.Text;
mF.Type = this.Type.SelectedValue;
#region 获取要生成表及XML字段所有属性
HXD.ModelField.Model.Field mf = new HXD.ModelField.Model.Field();
mf.TableName = this.TableName.Text;
mf.Type = this.Type.SelectedValue;
mf.Name = this.Field.Text;
mf.Title = this.Title.Text;
mf.Note = this.Note.Text;
mf.Prompt = this.Prompt.Text;
mf.MaxLength = StringDeal.ToInt(Request.Form["MaxLength"]);
mf.Size = StringDeal.ToInt(Request.Form["Size"]);
mf.Default = Request.Form["Default"];
mf.Width = StringDeal.ToInt(Request.Form["Width"]);
mf.Height = StringDeal.ToInt(Request.Form["Height"]);
mf.PwdMode = Request.Form["PwdMode"];
mf.EditorType = StringDeal.ToInt(Request.Form["EditorType"]);
mf.Options = Request.Form["Options"];
mf.OptionsType = Request.Form["OptionsType"];
mf.Bit = StringDeal.ToInt(Request.Form["Bit"]);
mf.DateTime = Request.Form["DateTime"];
mf.IsUploadPhoto = StringDeal.ToBool(Request.Form["IsUploadPhoto"]);
mf.UploadPhotoSize = StringDeal.ToInt(Request.Form["UploadPhotoSize"]);
mf.UploadPhotoType = Request.Form["UploadPhotoType"];
mf.IsSelect = StringDeal.ToBool(Request.Form["IsSelect"]);
mf.IsMark = StringDeal.ToBool(Request.Form["IsMark"]);
mf.MarkImage = Request.Form["MarkImage"];
mf.IsThumb = StringDeal.ToBool(Request.Form["IsThumb"]);
mf.ThumbSize = Request.Form["ThumbSize"];
mf.IsUploadFile = StringDeal.ToBool(Request.Form["IsUploadFile"]);
mf.UploadFileSize = StringDeal.ToInt(Request.Form["UploadFileSize"]);
mf.UploadFileType = Request.Form["UploadFileType"];
mf.Validator = Request.Form["Validator"];
#endregion
if (mF.Id == 0)
{
if (bF.FieldInsert(mF))
{
StringDeal.Alter("此字段名已经存在，请更换其他名称！");
}
else
{
HXD.ModelField.BLL.Field bf = new HXD.ModelField.BLL.Field();
bf.Val = mf;
bf.InsertXml();
bf.InsertField();
Response.Redirect("Field_Manage.aspx?TableId=" + TableId + "");
}
}
else
{
if (bF.FieldUpdate(mF))
{
StringDeal.Alter("此字段名已经存在，请更换其他名称！");
}
else
{
HXD.ModelField.BLL.Field bf = new HXD.ModelField.BLL.Field();
bf.Val = mf;
bf.UpdateXml();
bf.UpdateField();
Response.Redirect("Field_Manage.aspx?TableId=" + TableId + "");
}
}
}
/// <summary>
/// 获取管理员是否允许多人同时登陆
/// </summary>
/// <param name="Info"></param>
/// <returns></returns>
public bool GetAdminMultiLogin(mAdmin Info)
{
return(StringDeal.ToBool(SQLHelper.ExecuteScalar("GetAdminMultiLogin", Info.UserName)));
}
/// <summary>
/// 获取管理员是否允许修改密码
/// </summary>
/// <param name="Info"></param>
/// <returns></returns>
public bool GetAdminEditPwd(mAdmin Info)
{
return(StringDeal.ToBool(SQLHelper.ExecuteScalar("GetAdminEditPwd", Info.UserName)));
}
/// <summary>
/// 获取管理员锁定状态
/// </summary>
/// <returns></returns>
public bool GetAdminLock(mAdmin Info)
{
return(StringDeal.ToBool(SQLHelper.ExecuteScalar("GetAdminLock", Info.Id)));
}
