protected void btnSerImg_Click(object sender, EventArgs e)
{
if (Request.QueryString["SerUserID"] != null)
{
int SerUserID = Convert.ToInt32(Request.QueryString["SerUserID"]);
ZhongLi.Model.ServerUser user = bll.GetModel(SerUserID);
user.Flag = 2;
bll.Update(user);
//添加消息表
ZhongLi.Model.ServerUser_Message msg = new ZhongLi.Model.ServerUser_Message();
msg.MesCon = "您的身份认证通过啦";
msg.SendTime = DateTime.Now;
msg.SerUserID = SerUserID;
msg.MesType = 0;
new ZhongLi.BLL.ServerUser_Message().Add(msg);
//推送通知
JPushApiExample.ALERT = "您的身份认证通过啦";
JPushApiExample.MSG_CONTENT = "您的身份认证通过啦";
PushPayload pushsms = JPushApiExample.PushObject_ios_audienceMore_messageWithExtras("s" + SerUserID, "SerAuto");
JPushApiExample.push(pushsms);
webHelper.addLog("通过了职业介绍人“" + user.RealName + "”的职能身份认证");
Page.ClientScript.RegisterStartupScript(Page.GetType(), "set", "<script>window.onload=showmsgclose('职业介绍人职业身份认证','认证成功！','Auth.aspx?SerUserID=" + user.SerUserID + "',1)</script>");
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public ZhongLi.Model.ServerUser GetModel(int SerUserID)
{
SqlParameter[] parameters =
{
new SqlParameter("@SerUserID", SqlDbType.Int, 4)
};
parameters[0].Value = SerUserID;
ZhongLi.Model.ServerUser model = new ZhongLi.Model.ServerUser();
DataSet ds = DbHelperSQL.RunProcedure("ServerUser_GetModel", parameters, "ds");
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!Utils.CheckRole("5"))
{
Page.ClientScript.RegisterStartupScript(Page.GetType(), "set", "<script>window.onload=showmsgclose('权限信息','没有权限！','/Systestcomjun/index.aspx',2)</script>");
return;
}
if (!IsPostBack)
{
if (Request.QueryString["SerUserID"] != null)
{
int SerUserID = Convert.ToInt32(Request.QueryString["SerUserID"]);
ZhongLi.Model.ServerUser user = bll.GetModel(SerUserID);
img_Idcard.ImageUrl = user.IDCardImg;
//img_SerImg.ImageUrl = user.SerImg ;
switch (user.Flag)
{
case 0:
img_Idcard.ImageUrl = "";
btnSerImg.Enabled = false;
btnSerbh.Visible = false;
break;
case 1:
break;
case 2:
btnSerImg.Enabled = false;
btnSerImg.Text = "已通过";
btnSerbh.Visible = false;
break;
case 3:
btnSerImg.Enabled = false;
btnSerImg.Text = "已驳回";
btnSerbh.Visible = false;
break;
}
}
}
}
protected void btnsave_Click(object sender, EventArgs e)
{
ZhongLi.Model.ServerUser suser = new ZhongLi.Model.ServerUser();
suser.RealName = txtRealName.Text;
suser.Password = DESEncrypt.GetStringMD5(txtPwd.Text);
suser.Phone = txtPhne.Text;
suser.Sex = rbtSex.SelectedValue == "1" ? true : false;
suser.Trade = txtTrade.Text;
suser.Company = txtCompany.Text;
suser.Position = txtPosition.Text;
suser.WorkCity = txtWorkCity.Text;
suser.Email = txtEmail.Text;
suser.Flag = 0;
suser.RegTime = DateTime.Now;
suser.Balance = 0;
if (bll.Add(suser) > 0)
{
Page.ClientScript.RegisterStartupScript(Page.GetType(), "set", "<script>window.onload=showmsgclose('添加职业介绍人','保存成功！','',1)</script>");
}
else
{
Page.ClientScript.RegisterStartupScript(Page.GetType(), "set", "<script>window.onload=showmsgclose('添加职业介绍人','保存失败！','',2)</script>");
}
}
protected void btnsave_Click(object sender, EventArgs e)
{
if (Request.QueryString["SerUserID"] != null)
{
ZhongLi.Model.ServerUser suser = bll.GetModel(Convert.ToInt32(Request.QueryString["SerUserID"]));
suser.RealName = txtRealName.Text;
suser.Phone = txtPhne.Text;
suser.Sex = rbtSex.SelectedValue == "1" ? true : false;
suser.Trade = txtTrade.Text;
suser.Company = txtCompany.Text;
suser.Position = txtPosition.Text;
suser.WorkCity = txtWorkCity.Text;
suser.Email = txtEmail.Text;
if (bll.Update(suser))
{
webHelper.addLog("修改了职业介绍人“" + suser.RealName + "”");
Page.ClientScript.RegisterStartupScript(Page.GetType(), "set", "<script>window.onload=showmsgclose('编辑职业介绍人','保存成功！','',1)</script>");
}
else
{
Page.ClientScript.RegisterStartupScript(Page.GetType(), "set", "<script>window.onload=showmsgclose('编辑职业介绍人','保存失败！','',2)</script>");
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!Utils.CheckRole("5"))
{
Page.ClientScript.RegisterStartupScript(Page.GetType(), "set", "<script>window.onload=showmsgclose('权限信息','没有权限！','/Systestcomjun/index.aspx',2)</script>");
return;
}
if (!IsPostBack)
{
if (Request.QueryString["SerUserID"] != null)
{
int SerUserID = Convert.ToInt32(Request.QueryString["SerUserID"]);
ZhongLi.Model.ServerUser suser = bll.GetModel(SerUserID);
txtRealName.Text = suser.RealName;
txtPhne.Text = suser.Phone;
rbtSex.SelectedValue = suser.Sex == true ? "1" : "2";
txtTrade.Text = suser.Trade;
txtCompany.Text = suser.Company;
txtPosition.Text = suser.Position;
txtWorkCity.Text = suser.WorkCity;
txtEmail.Text = suser.Email;
}
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(ZhongLi.Model.ServerUser model)
{
int rowsAffected;
SqlParameter[] parameters =
{
new SqlParameter("@SerUserID", SqlDbType.Int, 4),
new SqlParameter("@RealName", SqlDbType.NVarChar, 50),
new SqlParameter("@Sex", SqlDbType.Bit, 1),
new SqlParameter("@PhotoImg", SqlDbType.NVarChar, 200),
new SqlParameter("@Trade", SqlDbType.NVarChar, 50),
new SqlParameter("@Company", SqlDbType.NVarChar, 50),
new SqlParameter("@Position", SqlDbType.NVarChar, 50),
new SqlParameter("@WorkCity", SqlDbType.NVarChar, 50),
new SqlParameter("@Address", SqlDbType.NVarChar, 100),
new SqlParameter("@Phone", SqlDbType.NVarChar, 50),
new SqlParameter("@Email", SqlDbType.NVarChar, 50),
new SqlParameter("@Describe", SqlDbType.NVarChar, 500),
new SqlParameter("@IDCardImg", SqlDbType.NVarChar, 200),
new SqlParameter("@IDCardTime", SqlDbType.DateTime),
new SqlParameter("@Flag", SqlDbType.Int, 4),
new SqlParameter("@SerImg", SqlDbType.NVarChar, 200),
new SqlParameter("@SerTime", SqlDbType.DateTime),
new SqlParameter("@Balance", SqlDbType.Decimal, 9),
new SqlParameter("@RegTime", SqlDbType.DateTime),
new SqlParameter("@Password", SqlDbType.NVarChar, 50),
new SqlParameter("@IDCardState", SqlDbType.Int, 4),
new SqlParameter("@SerImgState", SqlDbType.Int, 4),
new SqlParameter("@ImOpenID", SqlDbType.NVarChar, 200),
new SqlParameter("@WxOpenID", SqlDbType.NVarChar, 200),
new SqlParameter("@PerID", SqlDbType.Int, 4),
new SqlParameter("@QQOpenID", SqlDbType.NVarChar, 200),
new SqlParameter("@WbOpenID", SqlDbType.NVarChar, 200),
new SqlParameter("@AttestType", SqlDbType.Int, 4)
};
parameters[0].Direction = ParameterDirection.Output;
parameters[1].Value = model.RealName;
parameters[2].Value = model.Sex;
parameters[3].Value = model.PhotoImg;
parameters[4].Value = model.Trade;
parameters[5].Value = model.Company;
parameters[6].Value = model.Position;
parameters[7].Value = model.WorkCity;
parameters[8].Value = model.Address;
parameters[9].Value = model.Phone;
parameters[10].Value = model.Email;
parameters[11].Value = model.Describe;
parameters[12].Value = model.IDCardImg;
parameters[13].Value = model.IDCardTime;
parameters[14].Value = model.Flag;
parameters[15].Value = model.SerImg;
parameters[16].Value = model.SerTime;
parameters[17].Value = model.Balance;
parameters[18].Value = model.RegTime;
parameters[19].Value = model.Password;
parameters[20].Value = model.IDCardState;
parameters[21].Value = model.SerImgState;
parameters[22].Value = model.ImOpenID;
parameters[23].Value = model.WxOpenID;
parameters[24].Value = model.PerID;
parameters[25].Value = model.QQOpenID;
parameters[26].Value = model.WbOpenID;
parameters[27].Value = model.AttestType;
DbHelperSQL.RunProcedure("ServerUser_ADD", parameters, out rowsAffected);
return((int)parameters[0].Value);
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public ZhongLi.Model.ServerUser DataRowToModel(DataRow row)
{
ZhongLi.Model.ServerUser model = new ZhongLi.Model.ServerUser();
if (row != null)
{
if (row["SerUserID"] != null && row["SerUserID"].ToString() != "")
{
model.SerUserID = int.Parse(row["SerUserID"].ToString());
}
if (row["RealName"] != null)
{
model.RealName = row["RealName"].ToString();
}
if (row["Sex"] != null && row["Sex"].ToString() != "")
{
if ((row["Sex"].ToString() == "1") || (row["Sex"].ToString().ToLower() == "true"))
{
model.Sex = true;
}
else
{
model.Sex = false;
}
}
if (row["PhotoImg"] != null)
{
model.PhotoImg = row["PhotoImg"].ToString();
}
if (row["Trade"] != null)
{
model.Trade = row["Trade"].ToString();
}
if (row["Company"] != null)
{
model.Company = row["Company"].ToString();
}
if (row["Position"] != null)
{
model.Position = row["Position"].ToString();
}
if (row["WorkCity"] != null)
{
model.WorkCity = row["WorkCity"].ToString();
}
if (row["Address"] != null)
{
model.Address = row["Address"].ToString();
}
if (row["Phone"] != null)
{
model.Phone = row["Phone"].ToString();
}
if (row["Email"] != null)
{
model.Email = row["Email"].ToString();
}
if (row["Describe"] != null)
{
model.Describe = row["Describe"].ToString();
}
if (row["IDCardImg"] != null)
{
model.IDCardImg = row["IDCardImg"].ToString();
}
if (row["IDCardTime"] != null && row["IDCardTime"].ToString() != "")
{
model.IDCardTime = DateTime.Parse(row["IDCardTime"].ToString());
}
if (row["Flag"] != null && row["Flag"].ToString() != "")
{
model.Flag = int.Parse(row["Flag"].ToString());
}
if (row["SerImg"] != null)
{
model.SerImg = row["SerImg"].ToString();
}
if (row["SerTime"] != null && row["SerTime"].ToString() != "")
{
model.SerTime = DateTime.Parse(row["SerTime"].ToString());
}
if (row["Balance"] != null && row["Balance"].ToString() != "")
{
model.Balance = decimal.Parse(row["Balance"].ToString());
}
if (row["RegTime"] != null && row["RegTime"].ToString() != "")
{
model.RegTime = DateTime.Parse(row["RegTime"].ToString());
}
if (row["Password"] != null)
{
model.Password = row["Password"].ToString();
}
if (row["IDCardState"] != null && row["IDCardState"].ToString() != "")
{
model.IDCardState = int.Parse(row["IDCardState"].ToString());
}
if (row["SerImgState"] != null && row["SerImgState"].ToString() != "")
{
model.SerImgState = int.Parse(row["SerImgState"].ToString());
}
if (row["ImOpenID"] != null)
{
model.ImOpenID = row["ImOpenID"].ToString();
}
if (row["WxOpenID"] != null)
{
model.WxOpenID = row["WxOpenID"].ToString();
}
if (row["PerID"] != null && row["PerID"].ToString() != "")
{
model.PerID = int.Parse(row["PerID"].ToString());
}
if (row["QQOpenID"] != null)
{
model.QQOpenID = row["QQOpenID"].ToString();
}
if (row["WbOpenID"] != null)
{
model.WbOpenID = row["WbOpenID"].ToString();
}
if (row["AttestType"] != null && row["AttestType"].ToString() != "")
{
model.AttestType = int.Parse(row["AttestType"].ToString());
}
}
return(model);
}
