/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(ZhongLi.Model.PresentApplication model)
{
int rowsAffected = 0;
SqlParameter[] parameters =
{
new SqlParameter("@ID", SqlDbType.Int, 4),
new SqlParameter("@UserID", SqlDbType.Int, 4),
new SqlParameter("@RealName", SqlDbType.NVarChar, 50),
new SqlParameter("@Money", SqlDbType.Decimal, 9),
new SqlParameter("@State", SqlDbType.Int, 4),
new SqlParameter("@AdminID", SqlDbType.Int, 4),
new SqlParameter("@AdminName", SqlDbType.NVarChar, 50),
new SqlParameter("@PassTime", SqlDbType.DateTime),
new SqlParameter("@UserType", SqlDbType.Int, 4),
new SqlParameter("@PayTime", SqlDbType.DateTime),
new SqlParameter("@CreateTime", SqlDbType.DateTime),
new SqlParameter("@PayAdminID", SqlDbType.Int, 4),
new SqlParameter("@PayAdminName", SqlDbType.NVarChar, 50),
new SqlParameter("@WxAccount", SqlDbType.NVarChar, 50),
new SqlParameter("@AliAccount", SqlDbType.NVarChar, 50),
new SqlParameter("@PreType", SqlDbType.Int, 4),
new SqlParameter("@WxAccountName", SqlDbType.NVarChar, 50),
new SqlParameter("@AliAccounttName", SqlDbType.NVarChar, 50),
new SqlParameter("@PreNum", SqlDbType.NVarChar, 50),
new SqlParameter("@BatchID", SqlDbType.Int, 4)
};
parameters[0].Value = model.ID;
parameters[1].Value = model.UserID;
parameters[2].Value = model.RealName;
parameters[3].Value = model.Money;
parameters[4].Value = model.State;
parameters[5].Value = model.AdminID;
parameters[6].Value = model.AdminName;
parameters[7].Value = model.PassTime;
parameters[8].Value = model.UserType;
parameters[9].Value = model.PayTime;
parameters[10].Value = model.CreateTime;
parameters[11].Value = model.PayAdminID;
parameters[12].Value = model.PayAdminName;
parameters[13].Value = model.WxAccount;
parameters[14].Value = model.AliAccount;
parameters[15].Value = model.PreType;
parameters[16].Value = model.WxAccountName;
parameters[17].Value = model.AliAccounttName;
parameters[18].Value = model.PreNum;
parameters[19].Value = model.BatchID;
DbHelperSQL.RunProcedure("PresentApplication_Update", parameters, out rowsAffected);
if (rowsAffected > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public ZhongLi.Model.PresentApplication GetModel(int ID)
{
SqlParameter[] parameters =
{
new SqlParameter("@ID", SqlDbType.Int, 4)
};
parameters[0].Value = ID;
ZhongLi.Model.PresentApplication model = new ZhongLi.Model.PresentApplication();
DataSet ds = DbHelperSQL.RunProcedure("PresentApplication_GetModel", parameters, "ds");
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
protected void Repeater1_ItemCommand(object source, RepeaterCommandEventArgs e)
{
if (e.CommandName.Equals("payFail"))
{
int ID = Convert.ToInt32(e.CommandArgument);
int adminid = Convert.ToInt32(Utils.GetCookie("UserID"));
string adminname = new ZhongLi.BLL.User_Managers().GetModel(adminid).RealName;
string realname = ((Literal)e.Item.FindControl("ltlrealname")).Text;
ZhongLi.Model.PresentApplication p = bll.GetModel(ID);
if (bll.PayFail(adminid, adminname, ID, p.UserType.Value, p.UserID.Value, p.Money.Value))
{
//推送通知
PushClass push = new PushClass();
push.title = "优青通知：";
push.content = "您的提现申请支付失败了，资金已退回到您的钱包，请检查您提现时填的资料是否正确";
push.type = "1";
push.platform = "0";
push.groupName = "";
if (p.UserType.Value == 0)//用户类型为人才
{
push.userIds = "p" + p.UserID;
}
else
{
push.userIds = "s" + p.UserID;
}
push.ts_01();
webHelper.addLog(adminname + "设置" + realname + "的提现申请支付失败");
Page.ClientScript.RegisterStartupScript(Page.GetType(), "set", "<script>window.onload=showmsg('审核提现申请','操作成功！','',1)</script>");
databind();
}
else
{
Page.ClientScript.RegisterStartupScript(Page.GetType(), "set", "<script>window.onload=showmsg('审核提现申请','操作失败！','',2)</script>");
}
}
}
protected void Repeater1_ItemCommand(object source, RepeaterCommandEventArgs e)
{
int ID = Convert.ToInt32(e.CommandArgument);
int adminid = Convert.ToInt32(Utils.GetCookie("UserID"));
string adminname = new ZhongLi.BLL.User_Managers().GetModel(adminid).RealName;
string realname = ((Literal)e.Item.FindControl("ltlrealname")).Text;
ZhongLi.Model.PresentApplication p = bll.GetModel(ID);
if (e.CommandName.Equals("auth"))
{
if (bll.authPass(adminid, adminname, ID, p.UserType.Value, p.UserID.Value))
{
//推送通知
string UserID = "";
if (p.UserType.Value == 0) //用户类型为人才
{
UserID = "p" + p.UserID;
}
else
{
UserID = "s" + p.UserID;
}
JPushApiExample.ALERT = "您的提现申请审核通过啦，优青将会在3个工作日之内将体现金额支付到您的账户";
JPushApiExample.MSG_CONTENT = "您的提现申请审核通过啦，优青将会在3个工作日之内将体现金额支付到您的账户";
PushPayload pushsms = JPushApiExample.PushObject_ios_audienceMore_messageWithExtras(UserID, "Present");
JPushApiExample.push(pushsms);
webHelper.addLog(adminname + "通过了：" + realname + "的提现申请");
Page.ClientScript.RegisterStartupScript(Page.GetType(), "set", "<script>window.onload=showmsg('审核提现申请','操作成功！','',1)</script>");
databind();
}
else
{
Page.ClientScript.RegisterStartupScript(Page.GetType(), "set", "<script>window.onload=showmsg('审核提现申请','操作失败！','',2)</script>");
}
}
if (e.CommandName.Equals("noauth"))
{
if (bll.noauthPass(adminid, adminname, ID, p.UserType.Value, p.UserID.Value))
{
//推送通知
//推送通知
string UserID = "";
if (p.UserType.Value == 0) //用户类型为人才
{
UserID = "p" + p.UserID;
}
else
{
UserID = "s" + p.UserID;
}
JPushApiExample.ALERT = "您的提现申请没有通过审核";
JPushApiExample.MSG_CONTENT = "您的提现申请没有通过审核";
PushPayload pushsms = JPushApiExample.PushObject_ios_audienceMore_messageWithExtras(UserID, "Present");
JPushApiExample.push(pushsms);
webHelper.addLog(adminname + "没通过：" + realname + "的提现申请");
Page.ClientScript.RegisterStartupScript(Page.GetType(), "set", "<script>window.onload=showmsg('审核提现申请','操作成功！','',1)</script>");
databind();
}
else
{
Page.ClientScript.RegisterStartupScript(Page.GetType(), "set", "<script>window.onload=showmsg('审核提现申请','操作失败！','',2)</script>");
}
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public ZhongLi.Model.PresentApplication DataRowToModel(DataRow row)
{
ZhongLi.Model.PresentApplication model = new ZhongLi.Model.PresentApplication();
if (row != null)
{
if (row["ID"] != null && row["ID"].ToString() != "")
{
model.ID = int.Parse(row["ID"].ToString());
}
if (row["UserID"] != null && row["UserID"].ToString() != "")
{
model.UserID = int.Parse(row["UserID"].ToString());
}
if (row["RealName"] != null)
{
model.RealName = row["RealName"].ToString();
}
if (row["Money"] != null && row["Money"].ToString() != "")
{
model.Money = decimal.Parse(row["Money"].ToString());
}
if (row["State"] != null && row["State"].ToString() != "")
{
model.State = int.Parse(row["State"].ToString());
}
if (row["AdminID"] != null && row["AdminID"].ToString() != "")
{
model.AdminID = int.Parse(row["AdminID"].ToString());
}
if (row["AdminName"] != null)
{
model.AdminName = row["AdminName"].ToString();
}
if (row["PassTime"] != null && row["PassTime"].ToString() != "")
{
model.PassTime = DateTime.Parse(row["PassTime"].ToString());
}
if (row["UserType"] != null && row["UserType"].ToString() != "")
{
model.UserType = int.Parse(row["UserType"].ToString());
}
if (row["PayTime"] != null && row["PayTime"].ToString() != "")
{
model.PayTime = DateTime.Parse(row["PayTime"].ToString());
}
if (row["CreateTime"] != null && row["CreateTime"].ToString() != "")
{
model.CreateTime = DateTime.Parse(row["CreateTime"].ToString());
}
if (row["PayAdminID"] != null && row["PayAdminID"].ToString() != "")
{
model.PayAdminID = int.Parse(row["PayAdminID"].ToString());
}
if (row["PayAdminName"] != null)
{
model.PayAdminName = row["PayAdminName"].ToString();
}
if (row["WxAccount"] != null)
{
model.WxAccount = row["WxAccount"].ToString();
}
if (row["AliAccount"] != null)
{
model.AliAccount = row["AliAccount"].ToString();
}
if (row["PreType"] != null && row["PreType"].ToString() != "")
{
model.PreType = int.Parse(row["PreType"].ToString());
}
if (row["WxAccountName"] != null)
{
model.WxAccountName = row["WxAccountName"].ToString();
}
if (row["AliAccounttName"] != null)
{
model.AliAccounttName = row["AliAccounttName"].ToString();
}
if (row["PreNum"] != null)
{
model.PreNum = row["PreNum"].ToString();
}
if (row["BatchID"] != null && row["BatchID"].ToString() != "")
{
model.BatchID = int.Parse(row["BatchID"].ToString());
}
}
return(model);
}