/// <summary>
/// 获取已认证并登记进微信企业号中的人员数。
/// </summary>
/// <returns></returns>
//public int GetIsQYUser_Sum()
//{
// return dbContext.Repairman.Where(o => o.IsQYUser == true).Count();
//}
#endregion
public Tiyi.JD.SQLServerDAL.Repairman NewRepairman(Tiyi.JD.SQLServerDAL.Repairman user)
{
if (user != null)
{
if (!ExistUser(user.JobNumber))
{
user.WxgId = Guid.NewGuid();
dbContext.Repairman.InsertOnSubmit(user);
dbContext.SubmitChanges();
}
}
return(user);
}
public void UpdateRepairman(Tiyi.JD.SQLServerDAL.Repairman userinfo)
{
dbContext.SubmitChanges();
}
protected void formView_ItemCommand(object sender, FormViewCommandEventArgs e)
{
Guid wxgId = Guid.Empty;
Guid.TryParse(hfWxgId.Value, out wxgId);
if (e.CommandName == "UpdateRepairman")
{
Tiyi.JD.SQLServerDAL.Repairman record = bll_RepairmanManage.GetRepairmanById(wxgId);
// 工号
TextBox tbJobNumber = formView.FindControl("tbJobNumber") as TextBox;
record.JobNumber = tbJobNumber.Text;
// 姓名
TextBox tbRealName = formView.FindControl("tbRealName") as TextBox;
record.RealName = tbRealName.Text;
// 手机号码
TextBox tbMobilePhone = formView.FindControl("tbMobilePhone") as TextBox;
record.MobilePhone = tbMobilePhone.Text;
bll_RepairmanManage.UpdateRepairman(record);
if (Updated != null)
{
Updated(this, new EventArgs());
}
}
if (e.CommandName == "InsertRepairman")
{
Tiyi.JD.SQLServerDAL.Repairman record = new Tiyi.JD.SQLServerDAL.Repairman();
// 工号
TextBox tbJobNumber = formView.FindControl("tbJobNumber") as TextBox;
record.JobNumber = tbJobNumber.Text;
// 姓名
TextBox tbRealName = formView.FindControl("tbRealName") as TextBox;
record.RealName = tbRealName.Text;
// 手机号码
TextBox tbMobilePhone = formView.FindControl("tbMobilePhone") as TextBox;
record.MobilePhone = tbMobilePhone.Text;
Tiyi.JD.SQLServerDAL.Repairman user = bll_RepairmanManage.NewRepairman(record);
if (RepairmanCreated != null)
{
hfWxgId.Value = user.WxgId.ToString();
RepairmanInsertedEventArgs args = new RepairmanInsertedEventArgs(user);
RepairmanCreated(this, args);
}
}
if (e.CommandName == "DeleteRepairman")
{
bll_RepairmanManage.DeleteRepairman(wxgId);
if (Deleted != null)
{
Deleted(this, new EventArgs());
}
}
if (e.CommandName == "CancelUpdate" || e.CommandName == "CancelInsert")
{
if (Canceled != null)
{
Canceled(this, new EventArgs());
}
}
}
protected void PaigongBillView_ItemCommand(object sender, FormViewCommandEventArgs e)
{
Guid bxId = Guid.Empty;
Guid.TryParse(hfBxId.Value, out bxId);
if (e.CommandName == "InsertBill")
{
Tiyi.JD.SQLServerDAL.BaoxiuBill bxBill = bll_baoxiu.GetBaoxiuBill(bxId);
if (bxBill == null)
{
return;
}
Tiyi.JD.SQLServerDAL.PaigongBill pgBill = new Tiyi.JD.SQLServerDAL.PaigongBill();
pgBill.BxId = bxBill.BxId;
pgBill.AppId = bxBill.AppId;
pgBill.ProductSN = bxBill.ProductSN;
pgBill.BigClass = bxBill.BigClass;
pgBill.AppType = bxBill.AppType;
pgBill.DepName = bxBill.DepName;
TextBox tbUserName = formView.FindControl("tbUserName") as TextBox;
pgBill.UserName = tbUserName.Text;
TextBox tbUserMobilePhone = formView.FindControl("tbUserMobilePhone") as TextBox;
pgBill.UserMobilePhone = tbUserMobilePhone.Text;
TextBox tbUserMobileShort = formView.FindControl("tbUserMobileShort") as TextBox;
pgBill.UserMobileShort = tbUserMobileShort.Text;
TextBox tbAddress = formView.FindControl("tbAddress") as TextBox;
pgBill.Address = tbAddress.Text;
TextBox tbFaultPhenomenon = formView.FindControl("tbFaultPhenomenon") as TextBox;
pgBill.FaultPhenomenon = tbFaultPhenomenon.Text;
TextBox tbRemark = formView.FindControl("tbRemark") as TextBox;
pgBill.Remark = tbRemark.Text;
DropDownList ddlWxg = formView.FindControl("ddlWxg") as DropDownList;
Guid wxgId = Guid.Empty;
Guid.TryParse(ddlWxg.SelectedValue, out wxgId);
Tiyi.JD.SQLServerDAL.Repairman wxg = bll_wxg.GetRepairmanById(wxgId);
if (wxg != null)
{
pgBill.WxgId = wxgId;
pgBill.WxgRealName = wxg.RealName;
pgBill.WxgMobilePhone = wxg.MobilePhone;
pgBill.WxgMobileShort = wxg.MobileShort;
}
Tiyi.JD.SQLServerDAL.PaigongBill newBill = bll_Paigong.CreatePaigongBill(pgBill);
if (newBill != null && BillCreated != null)
{
hfPgId.Value = newBill.PgId.ToString();
BillInsertedEventArgs args = new BillInsertedEventArgs(newBill);
BillCreated(this, args);
}
}
if (e.CommandName == "UpdateBill")
{
Guid pgId = Guid.Empty;
Guid.TryParse(hfPgId.Value, out pgId);
Tiyi.JD.SQLServerDAL.PaigongBill pgBill = bll_Paigong.GetPaigongBill(pgId);
TextBox tbUserName = formView.FindControl("tbUserName") as TextBox;
pgBill.UserName = tbUserName.Text;
TextBox tbUserMobilePhone = formView.FindControl("tbUserMobilePhone") as TextBox;
pgBill.UserMobilePhone = tbUserMobilePhone.Text;
TextBox tbUserMobileShort = formView.FindControl("tbUserMobileShort") as TextBox;
pgBill.UserMobileShort = tbUserMobileShort.Text;
TextBox tbAddress = formView.FindControl("tbAddress") as TextBox;
pgBill.Address = tbAddress.Text;
TextBox tbFaultPhenomenon = formView.FindControl("tbFaultPhenomenon") as TextBox;
pgBill.FaultPhenomenon = tbFaultPhenomenon.Text;
TextBox tbRemark = formView.FindControl("tbRemark") as TextBox;
pgBill.Remark = tbRemark.Text;
DropDownList ddlWxg = formView.FindControl("ddlWxg") as DropDownList;
Guid wxgId = Guid.Empty;
Guid.TryParse(ddlWxg.SelectedValue, out wxgId);
Tiyi.JD.SQLServerDAL.Repairman wxg = bll_wxg.GetRepairmanById(wxgId);
if (wxg != null)
{
pgBill.WxgId = wxgId;
pgBill.WxgRealName = wxg.RealName;
pgBill.WxgMobilePhone = wxg.MobilePhone;
pgBill.WxgMobileShort = wxg.MobileShort;
}
bll_Paigong.UpdatePaigongBill(pgBill);
if (Updated != null)
{
Updated(this, new EventArgs());
}
}
if (e.CommandName == "InsertCancel" || e.CommandName == "UpdateCancel")
{
if (Updated != null)
{
Updated(this, new EventArgs());
}
}
if (e.CommandName == "EditBill")
{
formView.ChangeMode(FormViewMode.Edit);
}
if (e.CommandName == "WxRemind")
{
Guid pgId = Guid.Empty;
Guid.TryParse(hfPgId.Value, out pgId);
Tiyi.JD.SQLServerDAL.PaigongBill pgBill = bll_Paigong.GetPaigongBill(pgId);
Tiyi.Weixin.Work.Article article = new Tiyi.Weixin.Work.Article();
article.Title = "收到维修派工单";
System.Text.StringBuilder sb = new System.Text.StringBuilder();
sb.AppendLine("设备类型：" + pgBill.BigClass + pgBill.AppType);
sb.AppendLine("详细地址：" + pgBill.Address);
sb.AppendLine("联系方式：" + pgBill.UserName + " " + pgBill.UserMobilePhone + " (短号：" + pgBill.UserMobileShort + ")");
sb.AppendLine("派工时间：" + DateTime.Now.ToString() + "\n");
sb.AppendLine("故障现象：" + pgBill.FaultPhenomenon);
sb.AppendLine("备注信息：" + pgBill.Remark);
article.Description = sb.ToString();
article.Url = "";
System.Web.Script.Serialization.JavaScriptSerializer js = new System.Web.Script.Serialization.JavaScriptSerializer();
string articleJson = js.Serialize(article);
ws_wxSender.SendArticleToUser("101527", articleJson, "34");
Literal ltlSendWxResult = formView.FindControl("ltlSendWxResult") as Literal;
ltlSendWxResult.Text = "微信提醒发送成功";
}
}
public RepairmanInsertedEventArgs(Tiyi.JD.SQLServerDAL.Repairman user)
{
this._user = user;
}
