/// <summary>
/// 保存事件
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void ButtonSave_Click(object sender, EventArgs e)
{
try
{
WebBean bean = WebBean.GetInstance();
var model = new UrlDataModel
{
GUID = "add".Equals(AddOrUpdate) ? Guid.NewGuid().ToString() : UrlGuid,
ParentGUID = null,
Url = TextBoxUrl.Text.Trim(),
UrlCode = TextBoxUrlCode.Text.Trim(),
UrlParams = TextBoxParams.Text.Trim(),
UrlName = TextBoxUrlName.Text.Trim(),
UserAuthentication = DropDownListAuthentication.SelectedValue == "0",
Show = DropDownListShow.SelectedValue == "0"
};
if ("add".Equals(AddOrUpdate))
{
bean.AddUrl(model);
}
else
{
bean.UpdateUrl(model);
}
Show(this.Page, "保存成功！");
}
catch (Exception ex)
{
Show(this.Page, "保存失败！");
WriteLog.WriteExceptionLog(ex.ToString());
}
}
/// <summary>
/// 修改一条数据
/// </summary>
/// <param name="model"></param>
public void UpdateUrl(UrlDataModel model)
{
var s = DatabaseUtil.SelectBuilder.GetInstance();
s.ConnectionString = DALArgs.GetInstance().CurrentConnectString;
s.Header.Append(@" Update [Url_Data]
SET [Url] = @Url
,[ParentGUID]=@ParentGuid
,[UrlCode] = @UrlCode
,[UrlParams] = @UrlParams
,[UrlName] = @UrlName
,[UrlIndex] = @UrlIndex
,[UserAuthentication] = @UserAuthentication
,[Show] = @Show where [GUID]=@GUID");
s.Parameters.Add(new SqlParameter("@GUID", model.GUID));
s.Parameters.Add(new SqlParameter("@ParentGUID", model.ParentGUID));
s.Parameters.Add(new SqlParameter("@Url", model.Url));
s.Parameters.Add(new SqlParameter("@UrlCode", model.UrlCode));
s.Parameters.Add(new SqlParameter("@UrlParams", model.UrlParams));
s.Parameters.Add(new SqlParameter("@UrlName", model.UrlName));
s.Parameters.Add(new SqlParameter("@UrlIndex", model.UrlIndex));
s.Parameters.Add(new SqlParameter("@UserAuthentication", model.UserAuthentication));
s.Parameters.Add(new SqlParameter("@Show", model.Show));
DALArgs.GetInstance().CurrentDatabaseUtil.ExecuteDataAdapter(s);
}
/// <summary>
/// 插入一条数据
/// </summary>
/// <param name="model"></param>
public void AddUrl(UrlDataModel model)
{
var s = DatabaseUtil.SelectBuilder.GetInstance();
s.ConnectionString = DALArgs.GetInstance().CurrentConnectString;
s.Header.Append(@" INSERT INTO [Url_Data]
([GUID]
,[ParentGUID]
,[Url]
,[UrlCode]
,[UrlParams]
,[UrlName]
,[UserAuthentication]
,[Show])
VALUES
(@GUID
,@ParentGUID
,@Url
,@UrlCode
,@UrlParams
,@UrlName
,@UserAuthentication
,@Show)");
s.Parameters.Add(new SqlParameter("@GUID", model.GUID));
s.Parameters.Add(new SqlParameter("@ParentGUID", model.ParentGUID));
s.Parameters.Add(new SqlParameter("@Url", model.Url));
s.Parameters.Add(new SqlParameter("@UrlCode", model.UrlCode));
s.Parameters.Add(new SqlParameter("@UrlParams", model.UrlParams));
s.Parameters.Add(new SqlParameter("@UrlName", model.UrlName));
s.Parameters.Add(new SqlParameter("@UserAuthentication", model.UserAuthentication));
s.Parameters.Add(new SqlParameter("@Show", model.Show));
DALArgs.GetInstance().CurrentDatabaseUtil.ExecuteDataAdapter(s);
}
/// <summary>
/// 保存按钮事件
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void ButtonSave_Click(object sender, EventArgs e)
{
var selectedValue = string.Empty;
foreach (RepeaterItem item in Repeater1.Items)
{
if (((RadioButton)item.FindControl("RadioButtonSelect")).Checked)
{
selectedValue = ((HiddenField)item.FindControl("HiddenFieldGUID")).Value.Trim();
break;
}
}
if (Request.QueryString["urlGuid"] == null)
{
return;
}
var urlGuid = Request.QueryString["urlGuid"];
if (urlGuid != selectedValue.Trim())
{
WebBean bean = WebBean.GetInstance();
DataSet dataSet = bean.Select_Url_Data(urlGuid, string.Empty);
if (dataSet == null || dataSet.Tables.Count <= 0 || dataSet.Tables[0].Rows.Count <= 0)
{
return;
}
UrlDataModel model = new UrlDataModel();
foreach (DataRow row in dataSet.Tables[0].Rows)
{
model = new UrlDataModel
{
GUID = row["Url_GUID"].ToString(),
ParentGUID = selectedValue,
Url = row["Url"].ToString(),
UrlCode = row["UrlCode"].ToString(),
UrlParams = row["UrlParams"].ToString(),
UrlName = row["UrlName"].ToString(),
UrlIndex = int.Parse(row["UrlIndex"].ToString()),
UserAuthentication = (Boolean)row["UserAuthentication"],
Show = (Boolean)row["Show"]
};
}
try
{
bean.UpdateUrl(model);
}
catch (Exception)
{
throw;
}
if (!Page.ClientScript.IsStartupScriptRegistered("close"))
{
Page.ClientScript.RegisterStartupScript(Page.GetType(), "close",
"<script language='javascript'>top.$.close('select');</script>");
}
}
}
/// <summary>
/// 数据绑定到列表
/// </summary>
private void DataBind()
{
WebBean bean = WebBean.GetInstance();
var model = new UrlDataModel
{
GUID = string.Empty,
Url = TextBoxUrl.Text.Trim(),
UrlName = TextBoxUrlName.Text.Trim()
};
DataSet dataSet = bean.SelectUrlData(model);
Repeater1.DataSource = dataSet;
Repeater1.DataBind();
}
/// <summary>
/// 获取Module_Data数据
/// </summary>
public DataSet SelectUrlData(UrlDataModel model)
{
var s = DatabaseUtil.SelectBuilder.GetInstance();
s.ConnectionString = DALArgs.GetInstance().CurrentConnectString;
s.From.Append(@" FROM [Url_Data] ");
s.Select.Append(@" SELECT [GUID]
,[ParentGUID]
,[Url]
,[UrlCode]
,[UrlParams]
,[UrlName]
,[UserAuthentication]
,[Show]");
s.Where.Append(@" where 1=1 ");
if (!string.IsNullOrEmpty(model.GUID))
{
s.Where.Append(@" and [GUID]=@GUID ");
s.Parameters.Add(new SqlParameter("@GUID", model.GUID));
}
if (!string.IsNullOrEmpty(model.UrlName))
{
s.Where.Append(@" and [UrlName] like @urlName escape '\' ");
s.Parameters.Add(new SqlParameter("@urlName", string.Format("%{0}%", DatabaseUtil.FormatSqlParameterValue(model.UrlName.Trim()))));
}
if (!string.IsNullOrEmpty(model.Url))
{
s.Where.Append(@" and [Url] like @url escape '\' ");
s.Parameters.Add(new SqlParameter("@url", string.Format("%{0}%", DatabaseUtil.FormatSqlParameterValue(model.Url.Trim()))));
}
if (model.UserAuthentication != null)
{
s.Where.Append(@" and [UserAuthentication]=@userAuthentication ");
s.Parameters.Add(new SqlParameter("@userAuthentication", model.UserAuthentication));
}
if (model.Show != null)
{
s.Where.Append(@" and [Show]=@show ");
s.Parameters.Add(new SqlParameter("@show", model.Show));
}
s.OrderBy.Append(@" order by [UrlIndex]");
return(DALArgs.GetInstance().CurrentDatabaseUtil.ExecuteDataAdapter(s));
}
public async Task <PlayerUrlResponseModel> CreatePlayerUrlAsync(string playerID, PlayerUrlModel playerUrlModel)
{
if (string.IsNullOrWhiteSpace(playerID))
{
throw new NullReferenceException($"You need a player id to update this player");
}
if (playerUrlModel == null)
{
throw new ArgumentNullException(nameof(playerUrlModel), "PlayerUrlModel Object cannot be null");
}
var urlData = new UrlDataModel
{
Url = playerUrlModel
};
var result = await CreateActionAsync <UrlDataModel, PlayerUrlReadModel>($"/{playerID}/urls", urlData, null).ConfigureAwait(false);
return(result?.Url ?? null);
}
/// <summary>
/// 数据绑定到列表
/// </summary>
private void DataBind()
{
WebBean bean = WebBean.GetInstance();
bool?authentication = null;
switch (DropDownListAuthentication.SelectedValue)
{
case "1":
authentication = true;
break;
case "2":
authentication = false;
break;
}
bool?show = null;
switch (DropDownListShow.SelectedValue)
{
case "1":
show = true;
break;
case "2":
show = false;
break;
}
UrlDataModel model = new UrlDataModel
{
GUID = string.Empty,
Url = TextBoxUrl.Text.Trim(),
UrlName = TextBoxUrlName.Text.Trim(),
UserAuthentication = authentication,
Show = show
};
DataSet dataSet = bean.SelectUrlData(model);
Repeater1.DataSource = dataSet;
Repeater1.DataBind();
}
/// <summary>
/// 初始化页面
/// </summary>
/// <param name="urlGuid"></param>
private void InitPage(string urlGuid)
{
//如果传入的参数为空，则是插入调用
if (String.IsNullOrEmpty(urlGuid))
{
AddOrUpdate = "add";
TextBoxUrl.ReadOnly = false;
ClearTextBox();
}
else
{
AddOrUpdate = "update";
UrlDataModel model = new UrlDataModel
{
GUID = urlGuid,
UrlName = string.Empty,
UserAuthentication = null,
Show = null
};
WebBean bean = WebBean.GetInstance();
DataSet dataSet = bean.SelectUrlData(model);
if (dataSet == null || dataSet.Tables.Count <= 0 || dataSet.Tables[0].Rows.Count <= 0)
{
return;
}
foreach (DataRow row in dataSet.Tables[0].Rows)
{
TextBoxUrlName.Text = row["UrlName"].ToString();
TextBoxUrlCode.Text = row["UrlCode"].ToString();
TextBoxUrl.Text = row["Url"].ToString();
TextBoxParams.Text = row["UrlParams"].ToString();
DropDownListAuthentication.Items.FindByValue(Convert.ToBoolean(row["UserAuthentication"].ToString()) ? "0" : "1").Selected = true;
DropDownListShow.Items.FindByValue(Convert.ToBoolean(row["Show"].ToString()) ? "0" : "1").Selected = true;
}
}
}
/// <summary>
/// 修改一条数据
/// </summary>
/// <param name="model"></param>
public void UpdateUrl(UrlDataModel model)
{
WebAccess.GetInstance().UpdateUrl(model);
}
/// <summary>
/// 插入一条数据
/// </summary>
/// <param name="model"></param>
public void AddUrl(UrlDataModel model)
{
WebAccess.GetInstance().AddUrl(model);
}
/// <summary>
/// 获取所有Module_Data
/// </summary>
public DataSet SelectUrlData(UrlDataModel model)
{
return(WebAccess.GetInstance().SelectUrlData(model));
}
/// <summary>
/// 获取所有Module_Data
/// </summary>
public DataSet SelectUrlData(UrlDataModel model)
{
var access = BLLAccess.GetInstance();
return(access.SelectUrlData(model));
}
/// <summary>
/// 修改一条数据
/// </summary>
/// <param name="model"></param>
public void UpdateUrl(UrlDataModel model)
{
var access = BLLAccess.GetInstance();
access.UpdateUrl(model);
}
/// <summary>
/// 插入一条数据
/// </summary>
/// <param name="model"></param>
public void AddUrl(UrlDataModel model)
{
var access = BLLAccess.GetInstance();
access.AddUrl(model);
}
