/// <summary>
/// 获取指定公司的账户信息
/// </summary>
/// <param name="companyId">公司编号</param>
/// <returns>账户信息</returns>
public virtual EyouSoft.Model.SMSStructure.AccountInfo GetAccountInfo(string companyId)
{
EyouSoft.Model.SMSStructure.AccountInfo model = null;
DbCommand cmd = base.SMSStore.GetSqlStringCommand(SQL_SELECT_GETACCOUNTINFO);
base.SMSStore.AddInParameter(cmd, "COMPANYID", DbType.AnsiStringFixedLength, companyId);
using (IDataReader rdr = DbHelper.ExecuteReader(cmd, base.SMSStore))
{
if (rdr.Read())
{
model = new EyouSoft.Model.SMSStructure.AccountInfo();
model.AccountId = rdr.IsDBNull(1) ? string.Empty : rdr.GetString(0);
model.CompanyId = rdr.IsDBNull(1) ? string.Empty : rdr.GetString(1);
model.AccountMoney = rdr.IsDBNull(2) ? 0 : rdr.GetDecimal(2);
}
}
return(model);
}
/// <summary>
/// 获取指定公司的账户信息
/// </summary>
/// <param name="companyId">公司编号</param>
/// <returns></returns>
public EyouSoft.Model.SMSStructure.AccountInfo GetAccountInfo(int companyId)
{
EyouSoft.Model.SMSStructure.AccountInfo model = null;
DbCommand cmd = this._db.GetSqlStringCommand(SQL_SELECT_GETACCOUNTINFO);
this._db.AddInParameter(cmd, "COMPANYID", DbType.AnsiStringFixedLength, companyId);
using (IDataReader rdr = EyouSoft.Toolkit.DAL.DbHelper.ExecuteReader(cmd, this._db))
{
if (rdr.Read())
{
model = new EyouSoft.Model.SMSStructure.AccountInfo();
model.ID = rdr.IsDBNull(1) ? string.Empty : rdr.GetString(0);
model.CompanyID = rdr.IsDBNull(1) ? 0 : rdr.GetInt32(1);
model.AccountMoney = rdr.IsDBNull(2) ? 0 : rdr.GetDecimal(2);
}
}
return(model);
}
/// <summary>
/// 绑定公司用户
/// </summary>
protected string BindContact(string CompanyId)
{
if (!string.IsNullOrEmpty(CompanyId))
{
EyouSoft.Model.CompanyStructure.QueryParamsUser modelUser = new EyouSoft.Model.CompanyStructure.QueryParamsUser {
IsShowAdmin = true
};
IList <CompanyUserBase> CompanyUserList = EyouSoft.BLL.CompanyStructure.CompanyUser.CreateInstance().GetList(CompanyId, modelUser);
EyouSoft.Model.SMSStructure.AccountInfo Accountmodel = EyouSoft.BLL.SMSStructure.Account.CreateInstance().GetAccountInfo(CompanyId);
if (CompanyUserList.Count > 0)
{
StringBuilder strB = new StringBuilder("[");
string Operator = string.Empty;
string CompanyMoney = "0.00";
if (Accountmodel != null)
{
CompanyMoney = Accountmodel.AccountMoney.ToString("f2");
}
foreach (var model in CompanyUserList)
{
if (model.IsAdmin)
{
Operator += model.UserName;
}
strB.Append("{\"UserName\":\"" + model.ContactInfo.ContactName + "|" + model.UserName + "\",\"UserId\":\"" + model.ID + "\"},");
}
strB.Remove(strB.Length - 1, 1);
strB.Append("]");
return(strB.ToString() + "$" + Operator + "$" + CompanyMoney);
}
else
{
return("error");
}
}
else
{
return("error");
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
this.AccountInfo_SmsHeaderMenu.TabIndex = "tab5";
EyouSoft.BLL.SMSStructure.Account.CreateInstance().SetAccountBaseInfo(SiteUserInfo.CompanyID);
//余额 剩余短信条数
EyouSoft.Model.SMSStructure.AccountInfo model = EyouSoft.BLL.SMSStructure.Account.CreateInstance().GetAccountInfo(SiteUserInfo.CompanyID);
if (model != null)
{
CompanyMoney = model.AccountMoney.ToString("f2");
if (model.AccountSMSNumber != null && model.AccountSMSNumber.Count > 0)
{
rpAccountList.DataSource = model.AccountSMSNumber;
rpAccountList.DataBind();
}
}
model = null;
}
}
