/// <summary>
/// 更新自定义页
/// </summary>
/// <param name="gamePageItem"></param>
public void UpdateGamePageItem(GamePageItem gamePageItem)
{
StringBuilder sqlQuery = new StringBuilder();
sqlQuery.Append("UPDATE GamePageItem SET ")
.Append("NodeID=@NodeID, ")
.Append("KindID=@KindID, ")
.Append("SortID=@SortID, ")
.Append("OperateType=@OperateType, ")
.Append("DisplayName=@DisplayName, ")
.Append("ResponseUrl=@ResponseUrl, ")
.Append("Nullity=@Nullity ")
.Append("WHERE PageID=@PageID");
var prams = new List <DbParameter>();
prams.Add(Database.MakeInParam("PageID", gamePageItem.PageID));
prams.Add(Database.MakeInParam("NodeID", gamePageItem.NodeID));
prams.Add(Database.MakeInParam("KindID", gamePageItem.KindID));
prams.Add(Database.MakeInParam("SortID", gamePageItem.SortID));
prams.Add(Database.MakeInParam("OperateType", gamePageItem.OperateType));
prams.Add(Database.MakeInParam("DisplayName", gamePageItem.DisplayName));
prams.Add(Database.MakeInParam("ResponseUrl", gamePageItem.ResponseUrl));
prams.Add(Database.MakeInParam("Nullity", gamePageItem.Nullity));
Database.ExecuteNonQuery(CommandType.Text, sqlQuery.ToString(), prams.ToArray());
}
/// <summary>
/// 获取自定义页实体
/// </summary>
/// <param name="pageID"></param>
/// <returns></returns>
public GamePageItem GetGamePageItemInfo(int pageID)
{
string sqlQuery = string.Format("(NOLOCK) WHERE PageID= {0}", pageID);
GamePageItem gamePageItem = aideGamePageItemProvider.GetObject <GamePageItem>(sqlQuery);
return(gamePageItem);
}
public bool IsExistsPageID(int pageID)
{
GamePageItem gamePageItemInfo = GetGamePageItemInfo(pageID);
if (gamePageItemInfo == null)
{
return(false);
}
return(true);
}
/// <summary>
/// 判断页面是否存在，true-存在，false-不存在
/// </summary>
/// <param name="pageID"></param>
/// <returns></returns>
public bool IsExistsPageID(int pageID)
{
GamePageItem item = GetGamePageItemInfo(pageID);
if (item == null)
{
return(false);
}
else
{
return(true);
}
}
/// <summary>
/// 新增自定义页
/// </summary>
/// <param name="gamePageItem"></param>
public void InsertGamePageItem(GamePageItem gamePageItem)
{
DataRow dr = aideGamePageItemProvider.NewRow();
dr[GamePageItem._PageID] = gamePageItem.PageID;
dr[GamePageItem._NodeID] = gamePageItem.NodeID;
dr[GamePageItem._KindID] = gamePageItem.KindID;
dr[GamePageItem._SortID] = gamePageItem.SortID;
dr[GamePageItem._OperateType] = gamePageItem.OperateType;
dr[GamePageItem._DisplayName] = gamePageItem.DisplayName;
dr[GamePageItem._ResponseUrl] = gamePageItem.ResponseUrl;
dr[GamePageItem._Nullity] = gamePageItem.Nullity;
aideGamePageItemProvider.Insert(dr);
}
private void BindData( )
{
if (StrCmd == "add")
{
litInfo.Text = "新增";
txtPageID.Enabled = true;
}
else
{
litInfo.Text = "更新";
txtPageID.Enabled = false;
}
if (IntParam <= 0)
{
return;
}
//获取信息
GamePageItem gamePageItem = FacadeManage.aidePlatformFacade.GetGamePageItemInfo(IntParam);
if (gamePageItem == null)
{
ShowError("页面信息不存在");
Redirect("GamePageItemList.aspx");
return;
}
CtrlHelper.SetText(txtPageID, gamePageItem.PageID.ToString( ).Trim( ));
CtrlHelper.SetText(txtPageName, gamePageItem.DisplayName.Trim( ));
ddlGameKind.SelectedValue = gamePageItem.KindID.ToString( ).Trim( );
ddlNode.SelectedValue = gamePageItem.NodeID.ToString( ).Trim( );
ddlOperateType.SelectedValue = gamePageItem.OperateType.ToString( ).Trim( );
CtrlHelper.SetText(txtSortID, gamePageItem.SortID.ToString( ).Trim( ));
CtrlHelper.SetText(txtResponseUrl, gamePageItem.ResponseUrl.ToString( ).Trim( ));
rbtnNullity.SelectedValue = gamePageItem.Nullity.ToString( ).Trim( );
}
/// <summary>
/// 更新自定义页
/// </summary>
/// <param name="gamePageItem"></param>
public Message UpdateGamePageItem(GamePageItem gamePageItem)
{
aidePlatformData.UpdateGamePageItem(gamePageItem);
return(new Message(true));
}
/// <summary>
/// 新增自定义页
/// </summary>
/// <param name="gamePageItem"></param>
public Message InsertGamePageItem(GamePageItem gamePageItem)
{
aidePlatformData.InsertGamePageItem(gamePageItem);
return(new Message(true));
}
private void ProcessData( )
{
string pageID = CtrlHelper.GetText(txtPageID);
string sortID = CtrlHelper.GetText(txtSortID);
if (!Utils.Validate.IsPositiveInt(pageID))
{
ShowError("页面标识不规范，页面标识只能为正整数");
return;
}
if (!Utils.Validate.IsPositiveInt(sortID))
{
ShowError("排序不规范，排序只能为0或正整数");
return;
}
GamePageItem gamePageItem = new GamePageItem( );
gamePageItem.PageID = Convert.ToInt32(pageID);
gamePageItem.DisplayName = CtrlHelper.GetText(txtPageName);
gamePageItem.KindID = int.Parse(ddlGameKind.SelectedValue);
gamePageItem.NodeID = int.Parse(ddlNode.SelectedValue);
gamePageItem.OperateType = int.Parse(ddlOperateType.SelectedValue);
gamePageItem.SortID = Convert.ToInt32(sortID);
gamePageItem.ResponseUrl = CtrlHelper.GetText(txtResponseUrl);
gamePageItem.Nullity = Convert.ToByte(rbtnNullity.SelectedValue.Trim( ));
Message msg = new Message( );
if (StrCmd == "add")
{
//判断权限
AuthUserOperationPermission(Permission.Add);
if (FacadeManage.aidePlatformFacade.IsExistsPageID(gamePageItem.PageID))
{
ShowError("页面标识已经存在");
return;
}
msg = FacadeManage.aidePlatformFacade.InsertGamePageItem(gamePageItem);
}
else
{
//判断权限
AuthUserOperationPermission(Permission.Edit);
msg = FacadeManage.aidePlatformFacade.UpdateGamePageItem(gamePageItem);
}
if (msg.Success)
{
if (StrCmd == "add")
{
ShowInfo("页面信息增加成功", "GamePageItemList.aspx", 1200);
}
else
{
ShowInfo("页面信息修改成功", "GamePageItemList.aspx", 1200);
}
}
else
{
ShowError(msg.Content);
}
}