/// <summary>
/// 增加一条数据
/// </summary>
public int Add(ManagerBillInfo model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into wx_manager_bill(");
strSql.Append("managerId,moneyType,billMoney,billUsed,operPersonId,operDate,remark)");
strSql.Append(" values (");
strSql.Append("@managerId,@moneyType,@billMoney,@billUsed,@operPersonId,@operDate,@remark)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters = {
new SqlParameter("@managerId", SqlDbType.Int,4),
new SqlParameter("@moneyType", SqlDbType.VarChar,30),
new SqlParameter("@billMoney", SqlDbType.Int,4),
new SqlParameter("@billUsed", SqlDbType.VarChar,500),
new SqlParameter("@operPersonId", SqlDbType.Int,4),
new SqlParameter("@operDate", SqlDbType.DateTime),
new SqlParameter("@remark", SqlDbType.VarChar,1500)};
parameters[0].Value = model.ManagerId;
parameters[1].Value = model.MoneyType;
parameters[2].Value = model.BillMoney;
parameters[3].Value = model.BillUsed;
parameters[4].Value = model.OperPersonId;
parameters[5].Value = model.OperDate;
parameters[6].Value = model.Remark;
object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return 0;
}
else
{
return Convert.ToInt32(obj);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public ManagerBillInfo DataRowToModel(DataRow row)
{
var model = new ManagerBillInfo();
if (row != null)
{
if (row["id"] != null && row["id"].ToString() != "")
{
model.Id = int.Parse(row["id"].ToString());
}
if (row["managerId"] != null && row["managerId"].ToString() != "")
{
model.ManagerId = int.Parse(row["managerId"].ToString());
}
if (row["moneyType"] != null)
{
model.MoneyType = row["moneyType"].ToString();
}
if (row["billMoney"] != null && row["billMoney"].ToString() != "")
{
model.BillMoney = int.Parse(row["billMoney"].ToString());
}
if (row["billUsed"] != null)
{
model.BillUsed = row["billUsed"].ToString();
}
if (row["operPersonId"] != null && row["operPersonId"].ToString() != "")
{
model.OperPersonId = int.Parse(row["operPersonId"].ToString());
}
if (row["operDate"] != null && row["operDate"].ToString() != "")
{
model.OperDate = DateTime.Parse(row["operDate"].ToString());
}
if (row["remark"] != null)
{
model.Remark = row["remark"].ToString();
}
}
return model;
}
private bool DoEdit(int _id)
{
int oldMaxNum = MyCommFun.Str2Int(hidOldMaxNum.Value);
int newMaxNum = MyCommFun.Str2Int(ddlMaxNum.SelectedItem.Value);
int addNewNum = newMaxNum - oldMaxNum; //新增的帐号
var adminEntity = GetAdminInfo(); //取得管理员信息
var agent = new AgentInfo();
bool isAgent = false;
if (adminEntity.AgentLevel < 0)
{
return false;
}
if (adminEntity.AgentLevel > 0)
{
agent = aBll.GetAgentModel(adminEntity.Id);
isAgent = true;
if (agent.RemainMony < agent.AgentPrice * addNewNum)
{
JscriptMsg("余额不足，请联系管理员充值！", "", "Error");
return false;
}
}
//地区
string prov = ddlProvince.SelectedItem.Value;
string city = ddlCity.SelectedItem.Value;
string dist = txtArea.Text.Trim();
bool result = false;
var bll = new ManagerInfoService();
var model = bll.GetModel(_id);
model.RoleId = int.Parse(ddlRoleId.SelectedValue);
model.RoleType = new ManagerRoleService().GetModel(model.RoleId).RoleType;
if (cbIsLock.Checked == true)
{
model.IsLock = 0;
}
else
{
model.IsLock = 1;
}
//判断密码是否更改
if (txtPassword.Text.Trim() != "")
{
//获取用户已生成的salt作为密钥加密
model.Password = DESEncrypt.Encrypt(txtPassword.Text.Trim(), model.Salt);
}
model.RealName = txtRealName.Text.Trim();
model.Telephone = txtTelephone.Text.Trim();
model.Email = txtEmail.Text.Trim();
model.WxNum = int.Parse(ddlMaxNum.SelectedItem.Value);
model.QQ = txtqq.Text;
model.Email = txtEmail.Text;
model.Province = prov;
model.City = city;
model.County = dist;
model.SortId = MyCommFun.Str2Int(txtSortid.Text);
model.Remark = txtRemark.Text;
bool updateRet = bll.Update(model);
if (updateRet && isAgent && addNewNum > 0)
{
int xfjine = addNewNum * agent.AgentPrice.Value;//消费金额
agent.RemainMony -= xfjine;
agent.WcodeNum += newMaxNum;
bool updateRet2 = aBll.Update(agent);
if (updateRet2)
{
var bBll = new WXManagerBillService(new ManagerBillRepository());
var bill = new ManagerBillInfo
{
BillMoney = xfjine,
ManagerId = agent.ManagerId,
OperPersonId = agent.ManagerId,
OperDate = DateTime.Now,
BillUsed = "原用户" + model.UserName + "新增了" + addNewNum + "个微帐号",
MoneyType = "扣减"
};
int addBillId = bBll.Add(bill);
}
else
{
bll.Delete(_id);
updateRet=false;
}
}
if (updateRet)
{
AddAdminLog(MXEnums.ActionEnum.Edit.ToString(), "修改用户:" + model.UserName); //记录日志
result = true;
}
return result;
}
private bool DoAdd()
{
var adminEntity = GetAdminInfo(); //取得管理员信息
var agent = new AgentInfo();
bool isAgent = false;
if (adminEntity.AgentLevel < 0)
{
return false;
}
if (adminEntity.AgentLevel > 0)
{
agent = aBll.GetAgentModel(adminEntity.Id);
isAgent = true;
if (agent.RemainMony < agent.AgentPrice)
{
JscriptMsg("余额不足，请联系管理员充值！", "", "Error");
return false;
}
}
else
{
}
//int oldMaxNum = MyCommFun.Str2Int(hidOldMaxNum.Value);
int newMaxNum = MyCommFun.Str2Int(ddlMaxNum.SelectedItem.Value);
//地区
string prov = ddlProvince.SelectedItem.Value;
string city = ddlCity.SelectedItem.Value;
string dist = txtArea.Text.Trim();
var model = new ManagerInfo();
var bll = new ManagerInfoService();
model.RoleId = int.Parse(ddlRoleId.SelectedValue);
model.RoleType = new ManagerRoleService().GetModel(model.RoleId).RoleType;
if (cbIsLock.Checked == true)
{
model.IsLock = 0;
}
else
{
model.IsLock = 1;
}
//检测用户名是否重复
if (bll.Exists(txtUserName.Text.Trim()))
{
return false;
}
model.UserName = txtUserName.Text.Trim();
//获得6位的salt加密字符串
model.Salt = Utils.GetCheckCode(6);
//以随机生成的6位字符串做为密钥加密
model.Password = DESEncrypt.Encrypt(txtPassword.Text.Trim(), model.Salt);
model.RealName = txtRealName.Text.Trim();
model.Telephone = txtTelephone.Text.Trim();
model.Email = txtEmail.Text.Trim();
model.AddTime = DateTime.Now;
model.WxNum = newMaxNum;
model.AgentId = GetAdminInfo().Id;
model.QQ = txtqq.Text;
model.Email = txtEmail.Text;
model.RegIp = MXRequest.GetIP();
model.Province = prov;
model.City = city;
model.County = dist;
model.SortId=MyCommFun.Obj2Int(txtSortid.Text);
model.AgentLevel = -1;
model.Remark = txtRemark.Text;
model.AgentId = adminEntity.Id;
int addId = bll.Add(model);
if (addId>0 && isAgent)
{
int xfjine = newMaxNum * agent.AgentPrice.Value;//消费金额
//是代理商 :缴费，扣除金额，增加消费记录
agent.RemainMony -= xfjine;
agent.UserNum += 1;
agent.WcodeNum += newMaxNum;
bool updateRet= aBll.Update(agent);
if (updateRet)
{
var bBll = new WXManagerBillService(new ManagerBillRepository());
var bill = new ManagerBillInfo
{
BillMoney = xfjine,
ManagerId = agent.ManagerId,
OperPersonId = agent.ManagerId,
OperDate = DateTime.Now,
BillUsed = "开通1个用户" + model.UserName + "的" + newMaxNum + "个微帐号",
MoneyType = "扣减"
};
int addBillId= bBll.Add(bill);
}
else
{
bll.Delete(addId);
addId = 0;
}
}
if (addId> 0)
{
AddAdminLog(MXEnums.ActionEnum.Add.ToString(), "添加用户:" + model.UserName); //记录日志
return true;
}
return false;
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(ManagerBillInfo model)
{
return this._repository.Add(model);
}
private bool DoEdit()
{
int _id = MyCommFun.Str2Int(lblId.Text);
string strErr = "";
if (this.txtwxName.Text.Trim().Length == 0)
{
strErr += "公众帐号名称不能为空！";
}
if (this.txtwxId.Text.Trim().Length == 0)
{
strErr += "公众号原始id不能为空！";
}
if (this.txtweixinCode.Text.Trim().Length == 0)
{
strErr += "微信号不能为空！";
}
if (this.txtwxToken.Text.Trim().Length == 0)
{
strErr += "TOKEN值不能为空！";
}
if (strErr != "")
{
JscriptMsg(strErr, "back", "Error");
return false;
}
string wxName = this.txtwxName.Text;
string wxId = this.txtwxId.Text;
string weixinCode = this.txtweixinCode.Text;
string headerpic = this.txtImgUrl.Text;
string apiurl = this.txtapiurl.Text;
string wxToken = this.txtwxToken.Text;
string AppId = this.txtAppId.Text;
string AppSecret = this.txtAppSecret.Text;
var model = bll.GetAppInfo(_id);
model.WxName = wxName;
model.WxId = wxId;
model.WxCode = weixinCode;
model.Headerpic = headerpic;
model.Apiurl = apiurl;
model.WxToken = wxToken;
model.AppId = AppId;
model.AppSecret = AppSecret;
//TODO:状态赋值不对
//model.wStatus = MyCommFun.Str2Int( rblwStatus.SelectedItem.Value);
int addYear = MyCommFun.Str2Int(ddlMaxNum.SelectedItem.Value);
if (addYear > 0)
{
if (model.EndDate.HasValue && model.EndDate.Value >= DateTime.Now)
{
//直接加
model.EndDate = model.EndDate.Value.AddYears(addYear);
}
else
{
//已过期的，直接在当天开始加年份
model.EndDate = DateTime.Now.AddYears(addYear);
}
bool isAgent = false;
if (adminEntity.AgentLevel < 0)
{
return false;
}
if (adminEntity.AgentLevel > 0)
{
agent = aBll.GetAgentModel(adminEntity.Id);
isAgent = true;
if (agent.RemainMony < agent.AgentPrice)
{
JscriptMsg("余额不足，请联系管理员充值！", "", "Error");
return false;
}
else
{
int xfjine = addYear * agent.AgentPrice.Value;//消费金额
//是代理商 :缴费，扣除金额，增加消费记录
agent.RemainMony -= xfjine;
bool updateRet = aBll.Update(agent);
if (updateRet)
{
var bBll = new WXManagerBillService(new ManagerBillRepository());
var bill = new ManagerBillInfo
{
BillMoney = xfjine,
ManagerId = agent.ManagerId,
OperPersonId = agent.ManagerId,
OperDate = DateTime.Now,
BillUsed = "微帐号" + model.WxName + "增加时间" + addYear + "年",
MoneyType = "扣减"
};
bBll.Add(bill);
}
else
{
JscriptMsg("数据执行错误，请重新操作！", "", "Error");
return false;
}
}
}
}
bool ret = bll.Update(model);
if (ret)
{
AddAdminLog(MXEnums.ActionEnum.Edit.ToString(), "【管理】修改微信号，主键为:" + model.Id + ",微信号为：" + model.WxCode); //记录日志
return true;
}
return false;
}