/// <summary>
/// 初始绑定.由左边的树目录为传过来。如果没有传入。则取整个系统登入用户。Session[]
/// </summary>
public void InitdataBind()
{
/*
* IAgency agency = new Agency();
* SqlDataReader dr = null;
* int ParentAgencyID = 0;
*
* dr = agency.GetSingleAgency( AgencyName );
* try
* {
* if( dr.Read() )
* {
* ParentAgencyID = Convert.ToInt32( dr["AgencyID"] );
* }
* }
* catch( Exception ex )
* {
* throw ex;
* }
* finally
* {
* dr.Close();
* }
*/
string ParentAgencyID = new BLL.Agency().GetAgencyIdByName(AgencyName);
string sqlCondition = " And ParentAgencyID = " + ParentAgencyID;
string searchkey = CommonManager.Web.RequestUrlDecode("key", "");
if (!string.IsNullOrEmpty(searchkey))
{
sqlCondition += " and (AgencyName='" + searchkey + "' or TrueName='" + searchkey + "') ";
}
int counts;
DataTable dt = Agency.Default.AgencyList("*", "AgencyID", 1, anpPageIndex.PageSize, PageIndex, out counts, sqlCondition);
anpPageIndex.RecordCount = counts;
anpPageIndex.CurrentPageIndex = PageIndex;
rptDownAgencyList.DataSource = dt;
rptDownAgencyList.DataBind();
TotalMoney = DbSession.Default.FromSql("select ISNULL(Sum(convert(bigint,Account)),0) from web_agency where ParentAgencyID=" + ParentAgencyID).ToScalar <long>();
}
public void Balance()
{
string action = Utility.Common.GetStringOfUrl("action");
string id = Utility.Common.GetStringOfUrl("id");
if (action == "balance" && CommonManager.String.IsInteger(id))
{
//判断权限
AdminPopedom.IsHoldModel("17");
int balance = new BLL.Agency().BalanceSingle(id, AdminInfo["ID"].ToString());
if (balance >= 0)
{
Utility.Common.OutMsgBox("结算成功，共结算了" + UiCommon.StringConfig.MoneyChu100(balance) + "金币到ID为[" + id + "]的代理商帐号中！", Utility.Common.UrlValue);
databind();
}
else
{
Utility.Common.OutMsgBox("结算失败！", Utility.Common.UrlValue);
}
}
}
public void Balance()
{
string action = Utility.Common.GetStringOfUrl( "action" );
string id = Utility.Common.GetStringOfUrl("id");
if (action == "balance" && CommonManager.String.IsInteger(id))
{
//判断权限
AdminPopedom.IsHoldModel("17");
int balance = new BLL.Agency().BalanceSingle(id, AdminInfo["ID"].ToString());
if( balance >= 0 )
{
Utility.Common.OutMsgBox( "结算成功，共结算了" + UiCommon.StringConfig.MoneyChu100( balance ) + "金币到ID为[" + id + "]的代理商帐号中！", Utility.Common.UrlValue );
databind();
}
else
{
Utility.Common.OutMsgBox( "结算失败！", Utility.Common.UrlValue );
}
}
}
protected void btnSave_Click( object sender, EventArgs e )
{
if(!BCST.Common.CommonManager.Web.CheckPostSource())
{
return;
}
//---
if (tbxPassword.Text.Trim().Length > 0)
{
if (tbxPassword.Text.Trim().ToLower() != tbxPassword2.Text.Trim())
{
lblMsg.Text = "两次输入的帐号密码不一致，请重新输入！";
return;
}
}
//----
if( tbxDomain.Text.Trim().Length == 0 )
{
tbxDomain.Text = tbxUser.Text.Trim();
}
//---
string spareValue = tbxSpareValue.Text.Trim();
if (!BCST.Common.CommonManager.String.IsInteger(spareValue))
{
lblMsg.Text = "门票比例请输入整数！";
return;
}
else if (agency.ExistDomain(AgencyID, tbxDomain.Text.Trim()))
{
lblMsg.Text = "代理商二级域名已存在，请重新输入！";
return;
}
//----
if( tbxPostalCode.Text.Trim().Length == 0 )
{
tbxPostalCode.Text = "0";
}
int iRows = 0;
iRows = new BLL.Agency().Update(AgencyID, tbxPassword.Text.Trim(), tbxName.Text.Trim(), tbxPhone.Text.Trim(), tbxAddress.Text.Trim(), tbxPostalCode.Text.Trim(),
tbxQQ.Text.Trim(), tbxEmail.Text.Trim(), tbxMobile.Text.Trim(), tbxAccountNo.Text.Trim(),tbxAccountName.Text.Trim(), tbxBankName.Text.Trim(),
tbxBankAddress.Text.Trim(), tbxPayorNo.Text.Trim(), tbxDomain.Text.Trim(), txtRemark.Text.Trim(), txtTenpayNo.Text.Trim(),
tbxSpareValue.Text.Trim(), AdminInfo["ID"].ToString());
if (iRows == 0)
{
lblMsg.Text = "代理商资料修改成功！" + DateTime.Now;
//Response.Redirect("AgencyView.aspx");
}
else if (iRows == -2)
{
lblMsg.Text = "二级域名已存在，请重新输入！";
return;
}
else if (iRows == -3 || iRows == -4)
{
lblMsg.Text = "门票比例不能超出允许的变动范围！";
return;
}
else
{
lblMsg.Text = "代理商资料修改失败！";
}
/*
string agencyID = Utility.Common.GetStringOfUrl( "agencyid" );
//----
if( tbxDomain.Text.Trim().Length == 0 )
{
tbxDomain.Text = tbxUser.Text.Trim();
}
if( agency.ExistDomain( agencyID, tbxDomain.Text.Trim() ) )
{
lblMsg.Text = "二级域名已存在，请重新输入！";
return;
}
//----
if( tbxPostalCode.Text.Trim().Length == 0 )
{
tbxPostalCode.Text = "0";
}
int iRows = 0;
if( tbxPassword.Text.Trim().Length > 0 )
{
iRows = new BLL.Agency().Update( agencyID, tbxPassword.Text.Trim(), tbxName.Text.Trim(), tbxPhone.Text.Trim(),
tbxAddress.Text.Trim(), tbxPostalCode.Text.Trim(), tbxQQ.Text.Trim(), tbxEmail.Text.Trim(), tbxMobile.Text.Trim(), tbxAccountNo.Text.Trim(),
tbxAccountName.Text.Trim(), tbxBankName.Text.Trim(), tbxBankAddress.Text.Trim(), tbxPayorNo.Text.Trim(), tbxDomain.Text.Trim(), txtRemark.Text.Trim(), txtTenpayNo.Text.Trim() );
}
else
{
iRows = new BLL.Agency().UpdateNotPwd( agencyID, tbxName.Text.Trim(), tbxPhone.Text.Trim(),
tbxAddress.Text.Trim(), tbxPostalCode.Text.Trim(), tbxQQ.Text.Trim(), tbxEmail.Text.Trim(), tbxMobile.Text.Trim(), tbxAccountNo.Text.Trim(),
tbxAccountName.Text.Trim(), tbxBankName.Text.Trim(), tbxBankAddress.Text.Trim(), tbxPayorNo.Text.Trim(), tbxDomain.Text.Trim(), txtRemark.Text.Trim(), txtTenpayNo.Text.Trim() );
}
BLL.AdminLog alog = new BLL.AdminLog();
if( iRows > 0 )
{
alog.Add(UiCommon.AdminLoginInfo.UserName, "修改代理商[" + tbxUser.Text.Trim() + "]的资料");
Response.Redirect( "AgencyView.aspx" );
}
else
{
alog.Add( UiCommon.AdminLoginInfo.UserName, "修改代理商资料失败" );
lblMsg.Text = "修改失败！";
}*/
}
/// <summary>
/// 初始绑定.由左边的树目录为传过来。如果没有传入。则取整个系统登入用户。Session[]
/// </summary>
public void InitdataBind()
{
/*
IAgency agency = new Agency();
SqlDataReader dr = null;
int ParentAgencyID = 0;
dr = agency.GetSingleAgency( AgencyName );
try
{
if( dr.Read() )
{
ParentAgencyID = Convert.ToInt32( dr["AgencyID"] );
}
}
catch( Exception ex )
{
throw ex;
}
finally
{
dr.Close();
}
*/
string ParentAgencyID = new BLL.Agency().GetAgencyIdByName(AgencyName);
string sqlCondition = " And ParentAgencyID = " + ParentAgencyID;
string searchkey = CommonManager.Web.RequestUrlDecode( "key", "" );
if( !string.IsNullOrEmpty( searchkey ) )
{
sqlCondition += " and (AgencyName='" + searchkey + "' or TrueName='" + searchkey + "') ";
}
int counts;
DataTable dt = Agency.Default.AgencyList( "*", "AgencyID", 1, anpPageIndex.PageSize, PageIndex, out counts, sqlCondition );
anpPageIndex.RecordCount = counts;
anpPageIndex.CurrentPageIndex = PageIndex;
rptDownAgencyList.DataSource = dt;
rptDownAgencyList.DataBind();
TotalMoney = DbSession.Default.FromSql("select ISNULL(Sum(convert(bigint,Account)),0) from web_agency where ParentAgencyID=" + ParentAgencyID).ToScalar<long>();
}
protected void btnSave_Click(object sender, EventArgs e)
{
if (!BCST.Common.CommonManager.Web.CheckPostSource())
{
return;
}
//---
if (tbxPassword.Text.Trim().Length > 0)
{
if (tbxPassword.Text.Trim().ToLower() != tbxPassword2.Text.Trim())
{
lblMsg.Text = "两次输入的帐号密码不一致，请重新输入！";
return;
}
}
//----
if (tbxDomain.Text.Trim().Length == 0)
{
tbxDomain.Text = tbxUser.Text.Trim();
}
//---
string spareValue = tbxSpareValue.Text.Trim();
if (!BCST.Common.CommonManager.String.IsInteger(spareValue))
{
lblMsg.Text = "门票比例请输入整数！";
return;
}
else if (agency.ExistDomain(AgencyID, tbxDomain.Text.Trim()))
{
lblMsg.Text = "代理商二级域名已存在，请重新输入！";
return;
}
//----
if (tbxPostalCode.Text.Trim().Length == 0)
{
tbxPostalCode.Text = "0";
}
int iRows = 0;
iRows = new BLL.Agency().Update(AgencyID, tbxPassword.Text.Trim(), tbxName.Text.Trim(), tbxPhone.Text.Trim(), tbxAddress.Text.Trim(), tbxPostalCode.Text.Trim(),
tbxQQ.Text.Trim(), tbxEmail.Text.Trim(), tbxMobile.Text.Trim(), tbxAccountNo.Text.Trim(), tbxAccountName.Text.Trim(), tbxBankName.Text.Trim(),
tbxBankAddress.Text.Trim(), tbxPayorNo.Text.Trim(), tbxDomain.Text.Trim(), txtRemark.Text.Trim(), txtTenpayNo.Text.Trim(),
tbxSpareValue.Text.Trim(), AdminInfo["ID"].ToString());
if (iRows == 0)
{
lblMsg.Text = "代理商资料修改成功！" + DateTime.Now;
//Response.Redirect("AgencyView.aspx");
}
else if (iRows == -2)
{
lblMsg.Text = "二级域名已存在，请重新输入！";
return;
}
else if (iRows == -3 || iRows == -4)
{
lblMsg.Text = "门票比例不能超出允许的变动范围！";
return;
}
else
{
lblMsg.Text = "代理商资料修改失败！";
}
/*
*
* string agencyID = Utility.Common.GetStringOfUrl( "agencyid" );
*
* //----
* if( tbxDomain.Text.Trim().Length == 0 )
* {
* tbxDomain.Text = tbxUser.Text.Trim();
* }
*
* if( agency.ExistDomain( agencyID, tbxDomain.Text.Trim() ) )
* {
* lblMsg.Text = "二级域名已存在，请重新输入！";
* return;
* }
*
* //----
* if( tbxPostalCode.Text.Trim().Length == 0 )
* {
* tbxPostalCode.Text = "0";
* }
*
*
* int iRows = 0;
* if( tbxPassword.Text.Trim().Length > 0 )
* {
* iRows = new BLL.Agency().Update( agencyID, tbxPassword.Text.Trim(), tbxName.Text.Trim(), tbxPhone.Text.Trim(),
* tbxAddress.Text.Trim(), tbxPostalCode.Text.Trim(), tbxQQ.Text.Trim(), tbxEmail.Text.Trim(), tbxMobile.Text.Trim(), tbxAccountNo.Text.Trim(),
* tbxAccountName.Text.Trim(), tbxBankName.Text.Trim(), tbxBankAddress.Text.Trim(), tbxPayorNo.Text.Trim(), tbxDomain.Text.Trim(), txtRemark.Text.Trim(), txtTenpayNo.Text.Trim() );
* }
* else
* {
* iRows = new BLL.Agency().UpdateNotPwd( agencyID, tbxName.Text.Trim(), tbxPhone.Text.Trim(),
* tbxAddress.Text.Trim(), tbxPostalCode.Text.Trim(), tbxQQ.Text.Trim(), tbxEmail.Text.Trim(), tbxMobile.Text.Trim(), tbxAccountNo.Text.Trim(),
* tbxAccountName.Text.Trim(), tbxBankName.Text.Trim(), tbxBankAddress.Text.Trim(), tbxPayorNo.Text.Trim(), tbxDomain.Text.Trim(), txtRemark.Text.Trim(), txtTenpayNo.Text.Trim() );
* }
*
* BLL.AdminLog alog = new BLL.AdminLog();
* if( iRows > 0 )
* {
* alog.Add(UiCommon.AdminLoginInfo.UserName, "修改代理商[" + tbxUser.Text.Trim() + "]的资料");
* Response.Redirect( "AgencyView.aspx" );
*
* }
* else
* {
* alog.Add( UiCommon.AdminLoginInfo.UserName, "修改代理商资料失败" );
* lblMsg.Text = "修改失败！";
* }*/
}
