/// <summary>
/// rptRecharges_ItemDataBound
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void rptRecharges_ItemDataBound(object sender, RepeaterItemEventArgs e)
{
if (e.Item.ItemIndex < 0)
{
return;
}
Literal ltr = (Literal)e.Item.FindControl("ltrStatus");
PlaceHolder ph = (PlaceHolder)e.Item.FindControl("phCashierBox");
EyouSoft.Model.SMSStructure.PayMoneyInfo info = (EyouSoft.Model.SMSStructure.PayMoneyInfo)e.Item.DataItem;
string s = string.Empty;
if (info.IsChecked == 0)
{
s = "<a href='javascript:void(0);' onclick=\"openCashierBox('" + info.ID + "',this); return false;\">审核</a>";
ph.Visible = true;
}
else if (info.IsChecked == 1)
{
s = "<span style=\"color:green\">已通过</span>";
ph.Visible = false;
}
else
{
s = "<span style=\"color:red\">未通过</a>";
ph.Visible = false;
}
ltr.Text = s;
}
/// <summary>
/// 账户充值
/// </summary>
/// <param name="payMoneyInfo">充值支付信息业务实体</param>
/// <returns></returns>
public bool InsertPayMoney(EyouSoft.Model.SMSStructure.PayMoneyInfo payMoneyInfo)
{
if (payMoneyInfo.CompanyID < 1)
{
return(false);
}
this.SetAccountBaseInfo(payMoneyInfo.CompanyID);
return(Dal.InsertPayMoney(payMoneyInfo));
}
/// <summary>
/// 充值审核
/// </summary>
/// <param name="checkPayMoneyInfo">账户充值业务实体</param>
/// <returns></returns>
/// <remarks>
/// 实体需要设置如下信息：
/// PayMoneyId：充值支付编号
/// IsChecked：审核状态 0:未审核 1:审核通过 2:审核未通过
/// CheckTime：审核时间
/// CheckUserName：审核人用户名
/// CheckUserFullName：审核人姓名
/// </remarks>
public virtual bool CheckPayMoney(EyouSoft.Model.SMSStructure.PayMoneyInfo checkPayMoneyInfo)
{
DbCommand cmd = base.SMSStore.GetStoredProcCommand("proc_SMS_CheckPayMoney");
base.SMSStore.AddInParameter(cmd, "PayMoneyId", DbType.String, checkPayMoneyInfo.PayMoneyId);
base.SMSStore.AddInParameter(cmd, "CheckStatus", DbType.Int32, checkPayMoneyInfo.IsChecked);
base.SMSStore.AddInParameter(cmd, "CheckTime", DbType.DateTime, checkPayMoneyInfo.CheckTime);
base.SMSStore.AddInParameter(cmd, "CheckUserName", DbType.String, checkPayMoneyInfo.CheckUserName);
base.SMSStore.AddInParameter(cmd, "CheckUserFullName", DbType.String, checkPayMoneyInfo.CheckUserFullName);
base.SMSStore.AddOutParameter(cmd, "Result", DbType.Int32, 4);
base.SMSStore.AddInParameter(cmd, "UseMoney", DbType.Decimal, checkPayMoneyInfo.UseMoney);
DbHelper.RunProcedure(cmd, base.SMSStore);
return(Convert.ToInt32(base.SMSStore.GetParameterValue(cmd, "Result")) == 1 ? true : false);
}
/// <summary>
/// 审核
/// </summary>
/// <param name="PayId">充值明细ID</param>
/// <param name="checkState">状态 1：审核通过 2：审核不通过</param>
protected bool CheckPayCompany(string PayId, int checkState)
{
bool isResult = false;
EyouSoft.Model.SMSStructure.PayMoneyInfo Model = new EyouSoft.Model.SMSStructure.PayMoneyInfo();
Model.CheckTime = DateTime.Today;
Model.CheckUserFullName = MasterUserInfo.ContactName;
Model.CheckUserName = MasterUserInfo.UserName;
Model.IsChecked = checkState;
Model.PayMoneyId = PayId;
Model.UseMoney = Utils.GetDecimal(Request.QueryString["UseMoney"]);
Model.PayMoney = Utils.GetDecimal(Request.QueryString["Money"]);
isResult = EyouSoft.BLL.SMSStructure.Account.CreateInstance().CheckPayMoney(Model);
Model = null;
return(isResult);
}
/// <summary>
/// 审核
/// </summary>
private void Cashier()
{
string pid = EyouSoft.Common.Utils.InputText(Request.QueryString["pid"]);
string status = EyouSoft.Common.Utils.InputText(Request.QueryString["status"]);
decimal amount = EyouSoft.Common.Utils.GetDecimal(Request.QueryString["amount"], 0);
string webmasterRealname = EyouSoft.Common.Utils.InputText(Request.QueryString["wn"]);
if (string.IsNullOrEmpty(pid))
{
ResponseClearAndWrite("0");
}
if (string.IsNullOrEmpty(webmasterRealname))
{
ResponseClearAndWrite("-1");
}
if (amount < 0)
{
ResponseClearAndWrite("-2");
}
EyouSoft.BLL.SMSStructure.Account bll = new EyouSoft.BLL.SMSStructure.Account();
EyouSoft.Model.SMSStructure.PayMoneyInfo info = new EyouSoft.Model.SMSStructure.PayMoneyInfo();
EyouSoft.SSOComponent.Entity.MasterUserInfo loginUserInfo = Utils.GetWebmaster();
info.CheckOperatorName = webmasterRealname;
info.CheckTime = DateTime.Now;
info.CheckUserName = loginUserInfo.Username;
info.ID = pid;
info.IsChecked = status == "true" ? 1 : 2;
info.UseMoney = amount;
if (info.IsChecked != 1)
{
info.UseMoney = 0;
}
if (bll.CheckPayMoney(info))
{
ResponseClearAndWrite("1");
}
else
{
ResponseClearAndWrite("-3");
}
}
/// <summary>
/// 账户充值
/// </summary>
/// <param name="payMoneyInfo">充值支付信息业务实体</param>
/// <returns></returns>
public bool InsertPayMoney(EyouSoft.Model.SMSStructure.PayMoneyInfo payMoneyInfo)
{
payMoneyInfo.PayMoneyId = Guid.NewGuid().ToString();
/*
* if (payMoneyInfo.PayMoney > 0)
* {
* //单条短信的价格
* decimal OneSMSPrice = Convert.ToDecimal(System.Configuration.ConfigurationManager.AppSettings["SMS_COSTOFSINGLE"]);
* if (OneSMSPrice <= 0)
* return false;
* //设置短信充值条数
* payMoneyInfo.PaySMSNumber = Convert.ToInt32(payMoneyInfo.PayMoney / OneSMSPrice);
* }
*/
return(dal.InsertPayMoney(payMoneyInfo));
}
/// <summary>
/// 账户充值
/// </summary>
/// <param name="payMoneyInfo">充值支付信息业务实体</param>
/// <returns></returns>
public virtual bool InsertPayMoney(EyouSoft.Model.SMSStructure.PayMoneyInfo payMoneyInfo)
{
DbCommand cmd = base.SMSStore.GetSqlStringCommand(SQL_INSERT_PAYMONEY);
base.SMSStore.AddInParameter(cmd, "ID", DbType.String, payMoneyInfo.PayMoneyId);
base.SMSStore.AddInParameter(cmd, "COMPANYID", DbType.String, payMoneyInfo.CompanyId);
base.SMSStore.AddInParameter(cmd, "COMPANYNAME", DbType.String, payMoneyInfo.CompanyName);
base.SMSStore.AddInParameter(cmd, "USERID", DbType.String, payMoneyInfo.UserId);
base.SMSStore.AddInParameter(cmd, "USERFULLNAME", DbType.String, payMoneyInfo.UserFullName);
base.SMSStore.AddInParameter(cmd, "PAYMONEY", DbType.Decimal, payMoneyInfo.PayMoney);
base.SMSStore.AddInParameter(cmd, "PAYTIME", DbType.DateTime, payMoneyInfo.PayTime);
base.SMSStore.AddInParameter(cmd, "PaySMSNumber", DbType.Int32, payMoneyInfo.PaySMSNumber);
base.SMSStore.AddInParameter(cmd, "OperatorMobile", DbType.String, payMoneyInfo.UserMobile);
base.SMSStore.AddInParameter(cmd, "OperatorMQId", DbType.String, payMoneyInfo.UserMQId);
base.SMSStore.AddInParameter(cmd, "OperatorTel", DbType.String, payMoneyInfo.UserTel);
return(DbHelper.ExecuteSql(cmd, base.SMSStore) > 0 ? true : false);
}
/// <summary>
/// 账户充值
/// </summary>
/// <param name="payMoneyInfo">短信充值支付记录实体</param>
/// <returns></returns>
public bool InsertPayMoney(EyouSoft.Model.SMSStructure.PayMoneyInfo payMoneyInfo)
{
DbCommand cmd = this._db.GetSqlStringCommand(SQL_INSERT_PAYMONEY);
this._db.AddInParameter(cmd, "ID", DbType.AnsiStringFixedLength, Guid.NewGuid().ToString());
this._db.AddInParameter(cmd, "COMPANYID", DbType.String, payMoneyInfo.CompanyID);
this._db.AddInParameter(cmd, "COMPANYNAME", DbType.String, payMoneyInfo.CompanyName);
this._db.AddInParameter(cmd, "USERID", DbType.String, payMoneyInfo.OperatorID);
this._db.AddInParameter(cmd, "USERFULLNAME", DbType.String, payMoneyInfo.OperatorName);
this._db.AddInParameter(cmd, "PAYMONEY", DbType.Decimal, payMoneyInfo.PayMoney);
this._db.AddInParameter(cmd, "PAYTIME", DbType.DateTime, payMoneyInfo.PayTime);
this._db.AddInParameter(cmd, "PaySMSNumber", DbType.Int32, payMoneyInfo.PaySMSNumber);
this._db.AddInParameter(cmd, "OperatorMobile", DbType.String, payMoneyInfo.OperatorMobile);
//this._db.AddInParameter(cmd, "OperatorMQId", DbType.String, payMoneyInfo.OperatorMQId);
this._db.AddInParameter(cmd, "OperatorTel", DbType.String, payMoneyInfo.OperatorTel);
return(EyouSoft.Toolkit.DAL.DbHelper.ExecuteSql(cmd, this._db) > 0 ? true : false);
}
/// <summary>
/// 充值
/// </summary>
protected bool CompanyPayMoney()
{
bool isTrue = false;
EyouSoft.Model.SMSStructure.PayMoneyInfo Model = new EyouSoft.Model.SMSStructure.PayMoneyInfo();
Model.CompanyId = SiteUserInfo.CompanyID;
Model.CompanyName = SiteUserInfo.CompanyName;
Model.IsChecked = 0;
Model.OperatorTime = DateTime.Now;
Model.PayTime = Utils.GetDateTime(Request.QueryString["PayTime"], DateTime.Today);
Model.PayMoney = Utils.GetDecimal(Request.QueryString["PayMoney"]);
Model.UserFullName = SiteUserInfo.ContactInfo.ContactName;
Model.UserId = SiteUserInfo.ID;
Model.UserMobile = SiteUserInfo.ContactInfo.Mobile;
Model.UserMQId = SiteUserInfo.ContactInfo.MQ;
Model.UserTel = SiteUserInfo.ContactInfo.Tel;
isTrue = EyouSoft.BLL.SMSStructure.Account.CreateInstance().InsertPayMoney(Model);
Model = null;
return(isTrue);
}
protected void Page_Load(object sender, EventArgs e)
{
//判断权限
if (!CheckGrant(global::Common.Enum.TravelPermission.短信中心_短信中心_栏目))
{
Utils.ResponseNoPermit(global::Common.Enum.TravelPermission.短信中心_短信中心_栏目, true);
return;
}
EyouSoft.BLL.SMSStructure.Account accountBll = new EyouSoft.BLL.SMSStructure.Account();
string method = Utils.GetFormValue("method");
if (method == "recharge")
{
#region 充值
bool isTrue = false;
EyouSoft.Model.SMSStructure.PayMoneyInfo Model = new EyouSoft.Model.SMSStructure.PayMoneyInfo();
Model.CompanyID = SiteUserInfo.CompanyID;
Model.CompanyName = SiteUserInfo.CompanyName;
Model.IsChecked = 0;
Model.OperatorTime = DateTime.Now;
Model.PayTime = Utils.GetDateTime(Utils.InputText(txtRechargeDate.Value), DateTime.Now);
Model.PayMoney = Utils.GetDecimal(Utils.InputText(txtRechargeMoney.Value));
Model.OperatorName = SiteUserInfo.ContactInfo.ContactName;
Model.OperatorID = SiteUserInfo.ID;
Model.OperatorMobile = SiteUserInfo.ContactInfo.ContactMobile;
Model.OperatorTel = SiteUserInfo.ContactInfo.ContactTel;
isTrue = accountBll.InsertPayMoney(Model);
Utils.ResponseMeg(isTrue, isTrue?"充值成功，请等待审核":"充值失败");
return;
#endregion
}
//初始化信息
txtCompanyName.Value = SiteUserInfo.CompanyName; //客户名称
txtUserName.Value = SiteUserInfo.ContactInfo.ContactName; //充值人
txtRechargeDate.Value = DateTime.Now.ToString("yyyy-MM-dd HH:mm"); //充值时间
}
/// <summary>
/// 获取账户充值明细
/// </summary>
/// <param name="pageSize">每页记录数</param>
/// <param name="pageIndex">当前页索引</param>
/// <param name="recordCount">总记录数</param>
/// <param name="companyId">公司编号 为null时取所有公司</param>
/// <param name="companyName">公司名称 为null时不做为查询条件</param>
/// <param name="payStartTime">充值开始时间 为null时不做为查询条件</param>
/// <param name="payFinishTime">充值截止时间 为null时不做为查询条件</param>
/// <param name="operatorStartTime">操作开始时间 为null时不做为查询条件</param>
/// <param name="operatorFinishTime">操作截止时间 为null时不做为查询条件</param>
/// <param name="provinceId">省份编号 为null时不做为查询条件</param>
/// <param name="cityId">城市编号 为null时不做为查询条件</param>
/// <param name="checkStatus">审核状态 -1:所有状态 0:未审核 1:审核通过 2:审核未通过</param>
/// <param name="userAreas">用户分管的区域范围 为null时不做为查询条件</param>
/// <returns></returns>
public virtual IList <EyouSoft.Model.SMSStructure.PayMoneyInfo> GetPayMoneys(int pageSize, int pageIndex, ref int recordCount, string companyId, string companyName,
DateTime?payStartTime, DateTime?payFinishTime, DateTime?operatorStartTime, DateTime?operatorFinishTime,
int?provinceId, int?cityId, int checkStatus, string userAreas)
{
IList <EyouSoft.Model.SMSStructure.PayMoneyInfo> paymoneys = new List <EyouSoft.Model.SMSStructure.PayMoneyInfo>();
StringBuilder cmdQuery = new StringBuilder();
string tableName = "SMS_PayMoney";
string primaryKey = "Id";
string orderByString = "PayTime DESC,OperatorTime DESC";
StringBuilder fields = new StringBuilder();
fields.Append(" [ID],[CompanyID],[CompanyName],[OperatorID],[OperatorName],[PayMoney],[PayTime],[OperatorTime],[IsChecked],[CheckTime],[CheckUserName],[CheckOperatorName],[OperatorTel],[OperatorMobile],[OperatorMQId],[PaySMSNumber],[UseMoney]");
fields.Append(" ,(SELECT ProvinceId FROM tbl_CompanyInfo WHERE Id=SMS_PayMoney.CompanyID) AS ProvinceId ");
fields.Append(" ,(SELECT CityId FROM tbl_CompanyInfo WHERE Id=SMS_PayMoney.CompanyID) AS CityId ");
cmdQuery.Append(" 1=1 ");
if (!string.IsNullOrEmpty(companyId))
{
cmdQuery.AppendFormat(" AND CompanyID='{0}' ", companyId.ToString());
}
if (!string.IsNullOrEmpty(companyName))
{
cmdQuery.AppendFormat(" AND CompanyName LIKE '%{0}%' ", companyName);
}
if (payStartTime.HasValue)
{
cmdQuery.AppendFormat(" AND PayTime>='{0}' ", payStartTime.Value.ToString());
}
if (payFinishTime.HasValue)
{
cmdQuery.AppendFormat(" AND PayTime<'{0}' ", payFinishTime.Value.ToString());
}
if (operatorStartTime.HasValue)
{
cmdQuery.AppendFormat(" AND OperatorTime>='{0}' ", operatorStartTime.Value.ToString());
}
if (operatorFinishTime.HasValue)
{
cmdQuery.AppendFormat(" AND OperatorTime<'{0}' ", operatorFinishTime.Value.ToString());
}
/*if (provinceId.HasValue)
* {
* cmdQuery.AppendFormat(" AND ProvinceId={0} ", provinceId.Value);
* }
*
* if (cityId.HasValue)
* {
* cmdQuery.AppendFormat(" AND CityId={0} ", cityId.Value);
* }*/
if (checkStatus != -1)
{
cmdQuery.AppendFormat(" AND IsChecked={0} ", checkStatus);
}
/*if (!string.IsNullOrEmpty(userAreas))
* {
* cmdQuery.AppendFormat(" AND CityId IN({0}) ", userAreas);
* }*/
if (provinceId.HasValue || cityId.HasValue || !string.IsNullOrEmpty(userAreas))
{
cmdQuery.Append(" AND EXISTS(SELECT 1 FROM tbl_CompanyInfo WHERE Id=SMS_PayMoney.CompanyID ");
if (provinceId.HasValue)
{
cmdQuery.AppendFormat(" AND ProvinceId={0} ", provinceId.Value);
}
if (cityId.HasValue)
{
cmdQuery.AppendFormat(" AND CityId={0} ", cityId.Value);
}
if (!string.IsNullOrEmpty(userAreas))
{
cmdQuery.AppendFormat(" AND CityId IN({0}) ", userAreas);
}
cmdQuery.Append(" ) ");
}
using (IDataReader rdr = DbHelper.ExecuteReader(base.SMSStore, pageSize, pageIndex, ref recordCount, tableName, primaryKey, fields.ToString(), cmdQuery.ToString(), orderByString))
{
while (rdr.Read())
{
EyouSoft.Model.SMSStructure.PayMoneyInfo payMoneyInfo = new EyouSoft.Model.SMSStructure.PayMoneyInfo();
payMoneyInfo.PayMoneyId = rdr.GetString(rdr.GetOrdinal("ID"));
payMoneyInfo.CompanyId = rdr.GetString(rdr.GetOrdinal("CompanyID"));
payMoneyInfo.CompanyName = rdr["CompanyName"].ToString();
payMoneyInfo.UserId = rdr.GetString(rdr.GetOrdinal("OperatorID"));
payMoneyInfo.UserFullName = rdr["OperatorName"].ToString();
payMoneyInfo.PayMoney = rdr.GetDecimal(rdr.GetOrdinal("PayMoney"));
payMoneyInfo.PaySMSNumber = rdr.GetInt32(rdr.GetOrdinal("PaySMSNumber"));
payMoneyInfo.PayTime = rdr.GetDateTime(rdr.GetOrdinal("PayTime"));
payMoneyInfo.OperatorTime = rdr.GetDateTime(rdr.GetOrdinal("OperatorTime"));
payMoneyInfo.IsChecked = rdr.GetInt32(rdr.GetOrdinal("IsChecked"));
if (!rdr.IsDBNull(rdr.GetOrdinal("CheckTime")))
{
payMoneyInfo.CheckTime = rdr.GetDateTime(rdr.GetOrdinal("CheckTime"));
}
if (!rdr.IsDBNull(rdr.GetOrdinal("CheckUserName")))
{
payMoneyInfo.CheckUserName = rdr["CheckUserName"].ToString();
}
if (!rdr.IsDBNull(rdr.GetOrdinal("CheckOperatorName")))
{
payMoneyInfo.CheckUserFullName = rdr["CheckOperatorName"].ToString();
}
if (!rdr.IsDBNull(rdr.GetOrdinal("OperatorTel")))
{
payMoneyInfo.UserTel = rdr["OperatorTel"].ToString();
}
if (!rdr.IsDBNull(rdr.GetOrdinal("OperatorMobile")))
{
payMoneyInfo.UserMobile = rdr["OperatorMobile"].ToString();
}
if (!rdr.IsDBNull(rdr.GetOrdinal("OperatorMQId")))
{
payMoneyInfo.UserMQId = rdr.GetString(rdr.GetOrdinal("OperatorMQId"));
}
if (!rdr.IsDBNull(rdr.GetOrdinal("UseMoney")))
{
payMoneyInfo.UseMoney = rdr.GetDecimal(rdr.GetOrdinal("UseMoney"));
}
payMoneyInfo.ProvinceId = rdr.GetInt32(rdr.GetOrdinal("ProvinceId"));
payMoneyInfo.CityId = rdr.GetInt32(rdr.GetOrdinal("CityId"));
paymoneys.Add(payMoneyInfo);
}
}
return(paymoneys);
}
/// <summary>
/// 充值审核
/// </summary>
/// <param name="checkPayMoneyInfo">账户充值业务实体</param>
/// <returns></returns>
/// <remarks>
/// 实体需要设置如下信息：
/// PayMoneyId：充值支付编号
/// IsChecked：审核状态 0:未审核 1:审核通过 2:审核未通过
/// CheckTime：审核时间
/// CheckUserName：审核人用户名
/// CheckUserFullName：审核人姓名
/// </remarks>
public bool CheckPayMoney(EyouSoft.Model.SMSStructure.PayMoneyInfo checkPayMoneyInfo)
{
return(Dal.CheckPayMoney(checkPayMoneyInfo));
}
