//如果填写了用户姓名和电话则创建一个工单 private void CreateWorkBill(int intCCID, string strProductID, string strLoginName, string strCallInUserName, string strCallInTel, string strDiscription) { HYTD.BLL.Call_CustomerBLL ccbll = new HYTD.BLL.Call_CustomerBLL(); Models.Call_Customer ccModel = new Models.Call_Customer(); ccModel = ccbll.GetCall_CustomerEntity(intCCID); if (ccModel != null) { HYTD.BLL.Call_WorkBillBLL wbll = new HYTD.BLL.Call_WorkBillBLL(); Models.Call_WorkBill wModel = new Models.Call_WorkBill(); wModel.CWB_Status = 28; wModel.CWB_Type = 35; wModel.CWB_SoftType = 0; wModel.CWB_ServiceType = 10; wModel.CWB_CallType = 0; wModel.CWB_CCID = intCCID; wModel.CWB_CallInUserName = strCallInUserName; wModel.CWB_CallInTel = strCallInTel; wModel.CWB_CallInEmail = ""; wModel.CWB_OperationTime = DateTime.Now; int intOwner = 0; int.TryParse(ccModel.CC_Owner, out intOwner); wModel.CWB_ForUser = intOwner; wModel.CWB_OperationUser = intOwner; wModel.CWB_CreateTime = wModel.CWB_OperationTime.Value; wModel.CWB_Creater = 16; wModel.CWB_Description = strDiscription; wModel.CWB_Remark = "用户主动上传"; wModel.CWB_CallInLoginName = strLoginName; wModel.CWB_ProductID = strProductID; wModel.CWB_Code = wbll.WorkBillCreateCode(); try { wbll.AddCall_WorkBill(wModel); } catch (Exception ex) { } } }
private void DataBind() { Call_WorkBillTO sto = new Call_WorkBillTO(); #region 条件 if (!string.IsNullOrEmpty(Request["code"])) { sto.CWB_Code = Request["code"].ToString().Trim();//存 客户名称 } if (!string.IsNullOrEmpty(Request["cname"])) { sto.CWB_Remark = Request["cname"].ToString().Trim();//存 客户名称 } if (!string.IsNullOrEmpty(Request["uname"])) { sto.CWB_Solution = Request["uname"].ToString().Trim();//存 用户名称 } else { sto.CWB_Solution = strLoginUserName; } if (!string.IsNullOrEmpty(Request["stime"])) { DateTime dtStime = Convert.ToDateTime("1980-01-01"); DateTime.TryParse(Request["stime"].ToString().Trim(), out dtStime); sto.CWB_CreateTime = dtStime;//保存操作开始时间 } if (!string.IsNullOrEmpty(Request["etime"])) { DateTime dtEtime = Convert.ToDateTime("2250-01-01"); DateTime.TryParse(Request["etime"].ToString().Trim(), out dtEtime); sto.CWB_OperationTime = dtEtime;//保存操作结束时间 } if (!string.IsNullOrEmpty(Request["Owner"])) //存 客户所属工程师 { sto.CWB_Description = Request["Owner"].ToString().Trim(); } if (!string.IsNullOrEmpty(Request["sltType"])) { sto.CWB_Type = Convert.ToInt16(Request["sltType"].ToString().Trim()); intSelected = sto.CWB_Type; } if (!string.IsNullOrEmpty(Request["status"])) { int intStatus = 0; int.TryParse(Request["status"].ToString().Trim(), out intStatus); sto.CWB_Status = intStatus; intSelected = sto.CWB_Type; } #endregion if (!string.IsNullOrEmpty(Request.QueryString["pageIndex"])) { int.TryParse(Request.QueryString["pageIndex"], out pageIndex); } HYTD.BLL.Call_WorkBillBLL bll = new HYTD.BLL.Call_WorkBillBLL(); DataTable dt = bll.GetCall_WorkBillList(sto, pageIndex, pageSize, "", out rowCount); //分页 string getUrl = ""; if (Request.Url.Query.Length > 0 && Request.Url.Query.IndexOf("pageIndex") > -1 && Request.Url.Query.IndexOf("&") > -1) { getUrl = Request.Url.Query.Substring(Request.Url.Query.IndexOf("&")); } else if (Request.Url.Query.Length > 0) { getUrl = Request.Url.Query.Substring(1); } string url = "WorkBillList.aspx?pageIndex={0}&" + getUrl.Trim('&'); strtt = DividePage.Pager(pageSize, rowCount, pageIndex, url); if (dt.Rows.Count > 0) { StringBuilder sbContent = new StringBuilder(); string strNew = string.Empty; string strEdit = string.Empty; foreach (DataRow dr in dt.Rows) { strNew = string.Format("<a href=\"javascript:;\" name=\"NewWorkBill\" onclick=\"NewWorkBill({0})\" >新建</a> ", dr["CC_ID"]); strEdit = string.Format("<a href=\"javascript:;\" name=\"EditWorkBill\" onclick=\"EditWorkBill({0})\">修改</a>", dr["CWB_ID"].ToString()); if (dr["CWB_Status"].ToString() != ((int)PublicEnum.CallWorkBillStatus.Visited).ToString()) { strEdit += string.Format(" <a href=\"javascript:;\" name=\"EditWorkBill\" onclick=\"HuifangWorkBill({0})\">回访</a>", dr["CWB_ID"].ToString()); } sbContent.AppendFormat("<tbody>"); if (dr["CWB_Status"].ToString() == "服务中") { sbContent.AppendFormat("<tr style=\"color:red;\">"); } else { sbContent.AppendFormat("<tr>"); } sbContent.AppendFormat("<td class=\"num\" title=\"{0}\"><a href=\"javascript:;\" onclick=\"ShowWorkBill({1})\">{0}</a></td>", dr["CWB_Code"].ToString(), dr["CWB_ID"].ToString()); sbContent.AppendFormat("<td class=\"num\" title=\"{0}\">{0} </td>", dr["C_Name"].ToString()); sbContent.AppendFormat("<td class=\"by\" style=\"width:120px;\" title=\"{0}\">{0} </td>", dr["CC_Name"]); sbContent.AppendFormat("<td class=\"num\" title=\"{0}\">{0} </td>", dr["CWB_CallInUserName"]); sbContent.AppendFormat("<td class=\"num\" title=\"{0}\">{0} </td>", dr["CWB_CallInTel"]); sbContent.AppendFormat("<td class=\"num\" title=\"{0}\">{0} </td>", dr["CreateUserName"]); sbContent.AppendFormat("<td class=\"num\" style=\"width:100px;\" title=\"{0}\">{0} </td>", getDataFormate(dr["CWB_CreateTime"].ToString())); sbContent.AppendFormat("<td class=\"num\" title=\"{0}\">{0} </td>", dr["ServiceUserName"]); sbContent.AppendFormat("<td class=\"num\" style=\"width:100px;\" title=\"{0}\">{0} </td>", getDataFormate(dr["CWB_OperationTime"].ToString())); sbContent.AppendFormat("<td class=\"num\" title=\"{0}\">{0} ({1})</td>", dr["CWB_Status"].ToString(), dr["MYDStatus"].ToString()); //sbContent.AppendFormat("<td class=\"num\" title=\"{0}\">{0} </td>", "服务记录"); sbContent.AppendFormat("<td class=\"num\">{0} </td>", strNew + strEdit); sbContent.AppendFormat("</tr>"); sbContent.AppendFormat("</tbody>"); } script = sbContent.ToString(); } else { script = "没有搜索到相关内容!"; } //获取当前页 //if (rowCount % pageSize == 0) //{ // pageNum = rowCount / pageSize; //} //else //{ // pageNum = (rowCount / pageSize) + 1; //} }
protected void Button3_Click(object sender, EventArgs e) { StringBuilder sb = new StringBuilder();// strWhere = "1=1"; sb.Append("1=1"); string browser = Request.Browser.Browser; if (!string.IsNullOrEmpty(Request["code"])) { sb.AppendFormat(" and CWB_Code like '%{0}%'", Request["code"].ToString().Trim());//;;//存 客户名称 } if (!string.IsNullOrEmpty(Request["cname"])) { sb.AppendFormat(" and b.CC_Name like '%{0}%'", Request["cname"].ToString().Trim());//存 客户名称 } if (!string.IsNullOrEmpty(Request["uname"])) { sb.AppendFormat(" and d.UserName like '%{0}%'", Request["uname"].ToString().Trim());//存 用户名称 } if (!string.IsNullOrEmpty(Request["stime"])) { DateTime dtStime = Convert.ToDateTime("1980-01-01"); DateTime.TryParse(Request["stime"].ToString().Trim(), out dtStime); sb.AppendFormat(" and CWB_CreateTime > '{0}'", dtStime.AddDays(-1));//保存操作开始时间 } if (!string.IsNullOrEmpty(Request["etime"])) { DateTime dtEtime = Convert.ToDateTime("2250-01-01"); DateTime.TryParse(Request["etime"].ToString().Trim(), out dtEtime); sb.AppendFormat(" and CWB_CreateTime < '{0}'", dtEtime.AddDays(1)); //保存操作结束时间 } if (!string.IsNullOrEmpty(Request["Owner"])) //存 客户所属工程师 { sb.AppendFormat(" and CWB_Description = '{0}'", Request["Owner"].ToString().Trim()); } if (!string.IsNullOrEmpty(Request["sltType"]) && Request["sltType"].ToString().Trim() != "0") { sb.AppendFormat(" and CWB_Type = '{0}'", Convert.ToInt16(Request["sltType"].ToString().Trim())); } if (!string.IsNullOrEmpty(Request["status"])) { int intStatus = 0; int.TryParse(Request["status"].ToString().Trim(), out intStatus); int intStatus1 = 27; int.TryParse(ConfigurationManager.AppSettings["workbillStatusAll"].ToString(), out intStatus1); if (intStatus1 == intStatus) { } else { sb.AppendFormat(" and CWB_Status = '{0}'", intStatus); } } DataTable dt = new DataTable(); HYTD.BLL.Call_WorkBillBLL bll = new HYTD.BLL.Call_WorkBillBLL(); dt = bll.ImportExcelCustomerWorkBill(sb.ToString()).Tables[0]; NPOI.SS.UserModel.IWorkbook book1 = new ImportExcel().ImportCustomerWorkBill(dt, "客户服务记录"); string strFile = string.Empty; string filename = string.Empty; string strPath = HttpContext.Current.Server.MapPath("/" + System.Configuration.ConfigurationManager.AppSettings["CustomerFiles"].ToString().Replace("\\", "/") + "/") + "\\" + DateTime.Now.Year.ToString() + DateTime.Now.Month.ToString().PadLeft(2, '0') + "\\"; if (dt.Rows.Count > 0) { strFile = dt.Rows[0]["客户名称"].ToString(); filename = strPath + dt.Rows[0]["客户名称"].ToString() + ".xls"; if (!System.IO.Directory.Exists(System.IO.Path.GetDirectoryName(filename))) { System.IO.Directory.CreateDirectory(System.IO.Path.GetDirectoryName(filename)); } try { System.IO.FileStream file1 = new System.IO.FileStream(filename, System.IO.FileMode.Create); book1.Write(file1); file1.Dispose(); } catch (Exception ex) { throw ex; } } Response.Clear(); Response.BufferOutput = false; Response.ContentEncoding = System.Text.Encoding.UTF8; if (browser.ToLower() != "firefox") { Response.AddHeader("Content-Disposition", "attachment;filename=" + HttpUtility.UrlEncode(strFile) + ".xls"); } else { Response.AddHeader("Content-Disposition", "attachment;filename=" + strFile + ".xls"); } Response.ContentType = "application/ms-excel"; book1.Write(Response.OutputStream); book1.Dispose(); }
private void BindData() { HYTD.BLL.Call_WorkBillBLL WBll = new HYTD.BLL.Call_WorkBillBLL(); HYTD.BLL.Call_CustomerBLL ccBll = new HYTD.BLL.Call_CustomerBLL(); HYTD.BLL.Call_CustomerBLL CBll = new HYTD.BLL.Call_CustomerBLL(); //Call_Customer ccModel = new Call_Customer(); if (CID > 0) { cModel = ccBll.GetCall_CustomerEntity(CID); } if (cModel == null) { cModel = new Call_Customer(); } if (WID > 0) { #region //获取工单信息 wModel = WBll.GetCall_WorkBillEntity(WID); if (wModel == null) { wModel = new Call_WorkBill(); } CID = wModel.CWB_CCID; intWorkBill = wModel.CWB_Type; if (wModel.CWB_ServiceType != null) { intServiceType = wModel.CWB_ServiceType.Value; } if (wModel.CWB_SoftType != null) { intSoftWare = wModel.CWB_SoftType.Value; } if (wModel.CWB_CallType != null) { intConsultType = wModel.CWB_CallType.Value; } intStatus = wModel.CWB_Status; UserInfoBLL userBll = new UserInfoBLL(); strUserName = userBll.GetUserInfoEntityByUserCode(wModel.CWB_Creater); strCreateTime = getDateToString(wModel.CWB_CreateTime); if (wModel.CWB_OperationTime != null) { strOptionTime = getDateToString(wModel.CWB_OperationTime.Value); } else { strOptionTime = getDateToString(DateTime.Now); } intCreater = wModel.CWB_Creater; if (wModel.CWB_ForUser != null && wModel.CWB_ForUser.Value > 0) { intForUser = wModel.CWB_ForUser.Value; } strBillCode = wModel.CWB_Code; #endregion #region 满意度调查 HYTD.BLL.Call_SatisfactionBLL csBll = new HYTD.BLL.Call_SatisfactionBLL(); HYTD.BLL.Call_Satisfaction_ItemBLL csiBll = new HYTD.BLL.Call_Satisfaction_ItemBLL(); sModel = csBll.GetCall_SatisfactionEntityBYCWBID(wModel.CWB_ID); if (sModel != null) { siModel = csiBll.GetCall_Satisfaction_ItemEntityBYCSID(sModel.CS_ID); RadioButtonList1.SelectedValue = siModel.CSI_Result.Value.ToString(); } else { sModel = new Call_Satisfaction(); } #endregion } //获取客户信息 cModel = CBll.GetCall_CustomerEntity(CID); if (cModel == null) { cModel = new Call_Customer(); } if (CID > 0) { intCounts = WBll.GetCall_WorkBillCounts(CID); } }
public void toList(string strMessage, string strErrorCode, string UserName, string UserTel) { try { int intCustomerID = 0;//strList[0] //strUserName.Split(new[] { "cdc" }, StringSplitOptions.None); //string[] strList = System.Text.RegularExpressions.Regex.Split(strUserName, @"$#$", System.Text.RegularExpressions.RegexOptions.IgnoreCase); string[] strList = strMessage.Split(new[] { "$$" }, StringSplitOptions.None); string strLoginName = string.Empty; string strProductID = "000000"; SqlParameter[] parameters = { new SqlParameter("@CustomerID", SqlDbType.Int), new SqlParameter("@ProductID", SqlDbType.VarChar, 50), new SqlParameter("@ErrorMessage", SqlDbType.VarChar, 8000), new SqlParameter("@LoginName", SqlDbType.VarChar, 50), new SqlParameter("@isSuccessfull", SqlDbType.Int), new SqlParameter("@ErrorCode", SqlDbType.VarChar, 50), new SqlParameter("@IP", SqlDbType.VarChar, 50), new SqlParameter("@UserName", SqlDbType.VarChar, 50), new SqlParameter("@UserTel", SqlDbType.VarChar, 50) }; if (strList.Length > 3) { string strCustomerID = string.Empty; try { strCustomerID = DESEncrypt.Decrypt_DES(strList[0]); } catch (Exception ex) { } int.TryParse(strCustomerID, out intCustomerID); if (intCustomerID < 1) { try { strCustomerID = DESEncrypt.Decrypt_DES_Old(strList[0]); } catch (Exception ex) { } int.TryParse(strCustomerID, out intCustomerID); } int intSuccess = 0; int.TryParse(strList[3], out intSuccess); parameters[0].Value = intCustomerID; parameters[1].Value = strList[1]; parameters[2].Value = strMessage.Replace("'", "”").Replace("-", "——"); parameters[3].Value = strList[2]; parameters[4].Value = intSuccess; parameters[5].Value = strErrorCode; parameters[6].Value = getIP(strList[4]); parameters[7].Value = UserName; parameters[8].Value = UserTel; strLoginName = strList[2].Trim(); strProductID = strList[1].Trim(); } else { parameters[0].Value = -1; parameters[1].Value = "0000"; parameters[2].Value = "Error"; parameters[3].Value = strMessage; parameters[4].Value = 0; parameters[5].Value = "无"; parameters[7].Value = UserName; parameters[8].Value = UserTel; } DataSet ds = SqlHelperService.RunProcedure("UP_ActiveProductInfo_ADD", parameters, "ds"); if (!string.IsNullOrEmpty(UserName) && !string.IsNullOrEmpty(UserTel)) { HYTD.BLL.Call_WorkBillBLL wbll = new HYTD.BLL.Call_WorkBillBLL(); List <Models.Call_WorkBill> wModelList = wbll.GetCall_WorkBillList(intCustomerID, strProductID, strLoginName); if (wModelList != null && wModelList.Count < 1) { string strMessageNew = strMessage; if (strMessage.IndexOf("验证成功") > -1) { strMessageNew = strMessage.Substring(strMessage.IndexOf("验证成功") + 4); } CreateWorkBill(intCustomerID, strProductID, strLoginName, UserName, UserTel, strMessageNew); } } } catch (Exception ex) { WebLog.WriteLog(string.Format("添加数据库报错:{0}", ex.Message + ex.HelpLink + ex.InnerException + ex.Source + ex.StackTrace + ex.TargetSite), "Error"); } }
private void BindData() { HYTD.BLL.Call_WorkBillBLL WBll = new HYTD.BLL.Call_WorkBillBLL(); HYTD.BLL.Call_CustomerBLL ccBll = new HYTD.BLL.Call_CustomerBLL(); HYTD.BLL.Call_CustomerBLL CBll = new HYTD.BLL.Call_CustomerBLL(); //Call_Customer ccModel = new Call_Customer(); if (CID > 0) { cModel = ccBll.GetCall_CustomerEntity(CID); } if (cModel == null) { cModel = new Call_Customer(); } if (WID > 0) { //获取工单信息 wModel = WBll.GetCall_WorkBillEntity(WID); if (wModel == null) { wModel = new Call_WorkBill(); } CID = wModel.CWB_CCID; intWorkBill = wModel.CWB_Type; if (wModel.CWB_ServiceType != null) { intServiceType = wModel.CWB_ServiceType.Value; } if (wModel.CWB_SoftType != null) { intSoftWare = wModel.CWB_SoftType.Value; } if (wModel.CWB_CallType != null) { intConsultType = wModel.CWB_CallType.Value; } intStatus = wModel.CWB_Status; UserInfoBLL userBll = new UserInfoBLL(); strUserName = userBll.GetUserInfoEntityByUserCode(wModel.CWB_Creater); strCreateTime = getDateToString(wModel.CWB_CreateTime); if (wModel.CWB_OperationTime != null) { strOptionTime = getDateToString(wModel.CWB_OperationTime.Value); } else { strOptionTime = getDateToString(DateTime.Now); } intCreater = wModel.CWB_Creater; if (wModel.CWB_ForUser != null && wModel.CWB_ForUser.Value > 0) { intForUser = wModel.CWB_ForUser.Value; } strBillCode = wModel.CWB_Code; } else { wModel.CWB_CallInEmail = cModel.CC_Email; wModel.CWB_CallInTel = cModel.CC_Tel; wModel.CWB_CallInUserName = cModel.CC_UserName; strUserName = CurrentUserInfo.UserName; strOptionTime = getDateToString(DateTime.Now); strCreateTime = strOptionTime; intCreater = Convert.ToInt32(CurrentUserInfo.UserCode); if (cModel != null) { intForUser = Convert.ToInt32(cModel.CC_Owner); } } //获取客户信息 cModel = CBll.GetCall_CustomerEntity(CID); if (cModel == null) { cModel = new Call_Customer(); } if (CID > 0) { intCounts = WBll.GetCall_WorkBillCounts(CID); } }
private void BindData() { HYTD.BLL.Call_VisitBillBLL VBll = new HYTD.BLL.Call_VisitBillBLL(); HYTD.BLL.Call_CustomerBLL CBll = new HYTD.BLL.Call_CustomerBLL(); HYTD.BLL.Call_WorkBillBLL WBll = new HYTD.BLL.Call_WorkBillBLL(); Call_WorkBill wbModel = new Call_WorkBill(); if (VID > 0) { //获取工单信息 vModel = VBll.GetCall_VisitBillEntity(VID); WID = vModel.CVB_CWB_ID; } else if (WID > 0) { wbModel = WBll.GetCall_WorkBillEntity(WID); vModel.CVB_CallInEmail = wbModel.CWB_CallInEmail; vModel.CVB_CallInTel = wbModel.CWB_CallInTel; vModel.CVB_CallInUserName = wbModel.CWB_CallInUserName; vModel.CVB_CallType = wbModel.CWB_CallType; vModel.CVB_CCID = wbModel.CWB_CCID; vModel.CVB_Creater = wbModel.CWB_Creater; vModel.CVB_CreateTime = wbModel.CWB_CreateTime; vModel.CVB_Description = wbModel.CWB_Description; vModel.CVB_ForUser = wbModel.CWB_ForUser; vModel.CVB_OperationTime = wbModel.CWB_OperationTime; vModel.CVB_OperationUser = wbModel.CWB_OperationUser; vModel.CVB_Remark = wbModel.CWB_Remark; vModel.CVB_ServiceType = wbModel.CWB_ServiceType; vModel.CVB_SoftType = wbModel.CWB_SoftType; vModel.CVB_Solution = wbModel.CWB_Solution; vModel.CVB_Status = wbModel.CWB_Status; vModel.CVB_Type = wbModel.CWB_Type; } if (vModel == null) { vModel = new Call_VisitBill(); } CID = vModel.CVB_CCID; intWorkBill = vModel.CVB_Type; if (vModel.CVB_ServiceType != null) { intServiceType = vModel.CVB_ServiceType.Value; } if (vModel.CVB_SoftType != null) { intSoftWare = vModel.CVB_SoftType.Value; } if (vModel.CVB_CallType != null) { intConsultType = vModel.CVB_CallType.Value; } if (vModel.CVB_Status != null) { intStatus = vModel.CVB_Status.Value; } UserInfoBLL userBll = new UserInfoBLL(); strUserName = userBll.GetUserInfoEntityByUserCode(vModel.CVB_Creater); strCreateTime = getDateToString(vModel.CVB_CreateTime); if (vModel.CVB_OperationTime != null) { strOptionTime = getDateToString(vModel.CVB_OperationTime.Value); } else { strOptionTime = getDateToString(DateTime.Now); } intCreater = vModel.CVB_Creater; if (vModel.CVB_ForUser != null && vModel.CVB_ForUser.Value > 0) { intForUser = vModel.CVB_ForUser.Value; } if (vModel.CVB_VisitTime != null) { strVisitTime = getDateToString(vModel.CVB_VisitTime.Value); } else { strVisitTime = getDateToString(DateTime.Now); } //else //{ // strUserName = CurrentUserInfo.UserName; // strOptionTime = getDateToString(DateTime.Now); // strCreateTime = strOptionTime; // intCreater = Convert.ToInt32(CurrentUserInfo.UserCode); // intForUser = intCreater; //} //获取客户信息 cModel = CBll.GetCall_CustomerEntity(CID); if (cModel == null) { cModel = new Call_Customer(); } strUserName = CurrentUserInfo.UserName; }
private void DataBind() { Call_WorkBillTO sto = new Call_WorkBillTO(); #region 条件 StringBuilder sb = new StringBuilder(); sb.AppendFormat(" CWB_Status in(29,30) "); if (!string.IsNullOrEmpty(Request["code"])) { sb.AppendFormat(" and CWB_Code like '%{0}%' ", StringHelper.SQLFilter(Request["code"].ToString().Trim())); } if (!string.IsNullOrEmpty(Request["cname"])) { sb.AppendFormat(" and CC_Name like '%{0}%' ", StringHelper.SQLFilter(Request["cname"].ToString().Trim())); } if (!string.IsNullOrEmpty(Request["uname"])) { sb.AppendFormat(" and d.UserName like '%{0}%' ", StringHelper.SQLFilter(Request["uname"].ToString().Trim())); } else { sto.CWB_Solution = strLoginUserName; } sb.AppendFormat(" and CWB_OperationTime < '{0}' ", DateTime.Now.ToString("yyyy-MM-dd")); if (!string.IsNullOrEmpty(Request["stime"])) { DateTime dtStime = Convert.ToDateTime("1980-01-01"); DateTime.TryParse(Request["stime"].ToString().Trim(), out dtStime); sb.AppendFormat(" and CWB_CreateTime >= '{0}' ", dtStime.ToString("yyyy-MM-dd")); } if (!string.IsNullOrEmpty(Request["etime"])) { DateTime dtEtime = Convert.ToDateTime("2250-01-01"); DateTime.TryParse(Request["etime"].ToString().Trim(), out dtEtime); sb.AppendFormat(" and CWB_CreateTime < '{0}' ", dtEtime.AddDays(1).ToString("yyyy-MM-dd")); } if (!string.IsNullOrEmpty(Request["status"])) { int intstatus = 0; int.TryParse(Request["status"].ToString().Trim(), out intstatus); if (intstatus > 0) { sb.AppendFormat(" and CWB_MYDStatus = {0} ", intstatus); } } #endregion if (!string.IsNullOrEmpty(Request.QueryString["pageIndex"])) { int.TryParse(Request.QueryString["pageIndex"], out pageIndex); } HYTD.BLL.Call_WorkBillBLL bll = new HYTD.BLL.Call_WorkBillBLL(); DataTable dt = bll.GetCall_WorkBillList(sb.ToString(), pageIndex, pageSize, "", out rowCount); //分页 string getUrl = ""; if (Request.Url.Query.Length > 0 && Request.Url.Query.IndexOf("pageIndex") > -1 && Request.Url.Query.IndexOf("&") > -1) { getUrl = Request.Url.Query.Substring(Request.Url.Query.IndexOf("&")); } else if (Request.Url.Query.Length > 0) { getUrl = Request.Url.Query.Substring(1); } string url = "SatisfactionList.aspx?pageIndex={0}&" + getUrl.Trim('&'); strtt = DividePage.Pager(pageSize, rowCount, pageIndex, url); if (dt.Rows.Count > 0) { StringBuilder sbContent = new StringBuilder(); string strNew = string.Empty; string strEdit = string.Empty; foreach (DataRow dr in dt.Rows) { strNew = string.Format("<a href=\"javascript:;\" name=\"NewWorkBill\" onclick=\"NewWorkBill({0})\" >新建</a> ", dr["CC_ID"]); if (dr["CWB_Status"].ToString() != ((int)PublicEnum.CallWorkBillStatus.Visited).ToString()) { strEdit = string.Format(" <a href=\"javascript:;\" name=\"EditWorkBill\" onclick=\"HuifangWorkBill({0})\">满意度</a>", dr["CWB_ID"].ToString()); } sbContent.AppendFormat("<tbody>"); if (dr["MYDStatus"].ToString() == "待调查") { sbContent.AppendFormat("<tr style=\"color:red;\">"); } else { sbContent.AppendFormat("<tr>"); } //sbContent.AppendFormat("<tr>"); sbContent.AppendFormat("<td class=\"num\" title=\"{0}\"><a href=\"javascript:;\" onclick=\"ShowWorkBill({1})\">{0}</a></td>", dr["CWB_Code"].ToString(), dr["CWB_ID"].ToString()); sbContent.AppendFormat("<td class=\"num\" title=\"{0}\">{0} </td>", dr["C_Name"].ToString()); sbContent.AppendFormat("<td class=\"by\" style=\"width:120px;\" title=\"{0}\">{0} </td>", dr["CC_Name"]); sbContent.AppendFormat("<td class=\"num\" title=\"{0}\">{0} </td>", dr["CWB_CallInUserName"]); sbContent.AppendFormat("<td class=\"num\" title=\"{0}\">{0} </td>", dr["CWB_CallInTel"]); sbContent.AppendFormat("<td class=\"num\" title=\"{0}\">{0} </td>", dr["CreateUserName"]); sbContent.AppendFormat("<td class=\"num\" style=\"width:100px;\" title=\"{0}\">{0} </td>", getDataFormate(dr["CWB_CreateTime"].ToString())); sbContent.AppendFormat("<td class=\"num\" title=\"{0}\">{0} </td>", dr["ServiceUserName"]); sbContent.AppendFormat("<td class=\"num\" style=\"width:100px;\" title=\"{0}\">{0} </td>", getDataFormate(dr["CWB_OperationTime"].ToString())); sbContent.AppendFormat("<td class=\"num\" title=\"{0}\">{0} </td>", dr["MYDStatus"].ToString()); //sbContent.AppendFormat("<td class=\"num\" title=\"{0}\">{0} </td>", "服务记录"); sbContent.AppendFormat("<td class=\"num\">{0} </td>", strNew + strEdit); sbContent.AppendFormat("</tr>"); sbContent.AppendFormat("</tbody>"); } script = sbContent.ToString(); } else { script = "没有搜索到相关内容!"; } //获取当前页 //if (rowCount % pageSize == 0) //{ // pageNum = rowCount / pageSize; //} //else //{ // pageNum = (rowCount / pageSize) + 1; //} }
private void SendMailInfoSetTestQF(bool bolIsTest, string mailTo, string mailCC, string mailBCC, string strDate) { string strTitle = string.Empty; string strBody = string.Empty; string strFilesPath = string.Empty; //string mailCCTO = mailCC; HYTD.BLL.Call_CustomerBLL bll = new HYTD.BLL.Call_CustomerBLL(); Models.Call_Customer mCustomer = new Models.Call_Customer(); List <Models.Call_Customer> mCustomerList = new List <Models.Call_Customer>(); mCustomerList = bll.GetCall_CustomerList().Where(c => c.CC_IsSend == 1).ToList(); //int i = 0; foreach (var v in mCustomerList) { strBody = string.Empty; //i++; //if (i > 2) // break; if (v.CC_Status > 0 && v.CC_Email != null && v.CC_Email.Trim().Length > 0) { mailTo = v.CC_Email; //获取附件 如果没有附件则不添加 HYTD.BLL.Call_WorkBillBLL bllworkbill = new HYTD.BLL.Call_WorkBillBLL(); { strFilesPath = ""; strTitle = string.Format("关于近期收到我公司客服邮件的说明"); } string str = @"尊敬的客户: <p style='text-indent:2em; '>为了更好的服务客户,完善服务流程,提高服务效率和满意度,近期对我公司客服系统进行了升级,升级期间造成邮件误发的情况,在此深表歉意。客服系统升级后,客服人员记录工单的效率将大大提高,客服热线占线的情况将得到一定程度缓解。</p> <p style='text-indent:2em; '>非常感谢您一直以来对环宇通达的支持与厚爱, 值此中秋佳节来临之际,环宇通达公司全体员工,向您致以最诚挚的问候! 祝您节日愉快,阖家欢乐,幸福安康! </p> "; string strqian = @"<br /><br /><br /> <p class='x_MsoNormal'> <span style='font-family: " 微软雅黑" ," sans-serif"'>多谢支持</span><span lang='EN-US'></span></p> <p class='x_MsoNormal'> <span lang='EN-US'> </span></p> <p class='x_MsoNormal'> <b><span lang='EN-US' style='font-size: 10.0pt; font-family: 微软雅黑,sans-serif" color: #1F497D'>Best regards</span></b></p> <table class='x_MsoNormalTable' border='0' cellspacing='0' cellpadding='0' style='border-collapse: collapse'> <tbody> <tr> <td width='93' valign='top' style='width: 69.9pt; border: none; border-right: dotted windowtext 1.0pt; padding: 0cm 5.4pt 0cm 5.4pt'> <p class='x_MsoNormal' style='line-height: 115%;margin:5px'> <span lang='EN-US' style='font-size: 12.0pt; line-height: 115%; font-family: 宋体; color: #1F497D'> <img id='x_图片_x0020_1' src='http://www.hyitech.com/logo.jpg' alt='说明: hytd' height='92' width='89' border='0'></span></p> </td> <td width='497' valign='top' style='width: 372.9pt; padding: 0cm 5.4pt 0cm 5.4pt'> <p class='x_MsoNormal' style='line-height: 115%;margin:5px'> <span style='font-size: 10.0pt; line-height: 115%; font-family: 华文行楷; color: #1F497D'> 售后支持服务</span><span lang='EN-US' style='font-size: 10.0pt; line-height: 115%; color: #1F497D'><br> </span><span lang='EN-US' style='font-size: 8.5pt; line-height: 115%; color: #1F497D'> | Fax:400-0798-616 | </span> </p> <p class='x_MsoNormal' style='line-height: 115%;margin:5px'> <span lang='EN-US' style='font-size: 8.5pt; line-height: 115%; color: #1F497D'>E-mail: </span><u><span lang='EN-US' style='font-size: 8.5pt; line-height: 115%; color: #0563C1'> <a href='#'>[email protected]</a></span></u><span lang='EN-US' style='font-size: 8.5pt; line-height: 115%; color: #1F497D'></span></p> <p class='x_MsoNormal' style='line-height: 115%;margin:5px'> <span lang='EN-US' style='font-size: 8.5pt; line-height: 115%; color: #1F497D'>Web: </span><span lang='EN-US'><a href='#' target='_blank'><span style='font-size: 8.5pt; line-height: 115%'>http://www.hyitech.com</span></a></span><span lang='EN-US' style='font-size: 8.5pt; line-height: 115%; color: #1F497D'> <br> </span><span style='font-size: 8.5pt; line-height: 115%; font-family: 宋体; color: #1F497D'> 北京环宇通达科技有限公司</span><span lang='DE' style='font-size: 8.5pt; line-height: 115%; color: #1F497D'></span></p> <p class='x_MsoNormal' style='line-height: 115%;margin:5px'><span style='font-size: 8.5pt; line-height: 115%; font-family: 宋体; color: #1F497D'>微软金牌合作伙伴 </span><span lang='EN-US' style='font-size: 8.5pt; line-height: 115%; color: #1F497D'> | </span><span style='font-size: 8.5pt; line-height: 115%; font-family: 宋体; color: #1F497D'> 教育行业解决方案专家 </span><span lang='EN-US' style='font-size: 8.5pt; line-height: 115%; color: #1F497D'></span> </p> </td> </tr> </tbody> </table>"; strBody = str + strqian; //if (ds.Tables[0].Rows.Count > 0) //{ if (bolIsTest) { strTitle = "" + strTitle; } sendMail(mailTo, v.CC_EmailUserName, mailCC, mailBCC, strTitle, strBody, strFilesPath); //} } } }
private void SendMailInfoSetTest(bool bolIsTest, string mailTo, string mailCC, string mailBCC, string strDate) { string strTitle = string.Empty; string strBody = string.Empty; string strFilesPath = string.Empty; string mailCCTO = mailCC; HYTD.BLL.Call_CustomerBLL bll = new HYTD.BLL.Call_CustomerBLL(); Models.Call_Customer mCustomer = new Models.Call_Customer(); List <Models.Call_Customer> mCustomerList = new List <Models.Call_Customer>(); mCustomerList = bll.GetCall_CustomerList().Where(c => c.CC_IsSend == 1).ToList(); int i = 0; foreach (var v in mCustomerList) { i++; if (i > 2) { break; } if (v.CC_Status > 0 && v.CC_Email != null && v.CC_Email.Trim().Length > 0) { if (!bolIsTest) { mailTo = mailCC = ""; mailTo = v.CC_Email; if (mailCCTO.Length > 0) { mailCC = v.CC_CCEmail + "," + mailCCTO; } //密送给所属工程师 if (v.CC_Owner == "29") { mailBCC += ",[email protected]"; } else if (v.CC_Owner == "37") { mailBCC += ",[email protected]"; } else if (v.CC_Owner == "54") { mailBCC += ",[email protected]"; } else { mailBCC += ",[email protected]"; } } else { if (v.CC_Owner == "29") { mailTo = "*****@*****.**"; } else if (v.CC_Owner == "37") { mailTo = "*****@*****.**"; } else if (v.CC_Owner == "54") { mailTo = "*****@*****.**"; } else { mailTo = "*****@*****.**"; } } //获取附件 如果没有附件则不添加 DataSet ds = new DataSet(); HYTD.BLL.Call_WorkBillBLL bllworkbill = new HYTD.BLL.Call_WorkBillBLL(); //string strWhere = string.Format("CWB_CCID={0} and (convert(varchar(7),CWB_CreateTime,120)='{1}' or convert(varchar(7),CWB_CreateTime,120)='2015-04')", v.CC_ID, strDate.Substring(0, 4)); string strWhere = string.Format("CWB_CCID={0} and convert(varchar(7),CWB_CreateTime,120)='{1}'", v.CC_ID, strDate.Substring(0, 7)); ds = bllworkbill.ImportExcelCustomerWorkBill(strWhere); if (ds.Tables[0].Rows.Count > 0) { strFilesPath = getFile(ds.Tables[0]); string strTypeInfo = string.Empty; strTypeInfo = getTypeInfo(ds.Tables[1]); strTitle = string.Format("{0}微软正版化平台{1}份服务报告", v.CC_Name, Convert.ToDateTime(strDate).ToString("yyyy年MM")); #region // strBody = string.Format(@"{0},您好:<br /><br /> // <p style='text-indent:2em; '>环宇通达公司微软正版化售后服务部,首先感谢您一直以来对我们的支持和鼓励。回望2014年,环宇通达是不断创新的一年。对于正版化平台:我们综合了历年来所有的服务项目与众多用户提出的宝贵意见,积极改善了正版化平台的诸多功能。对于售后服务:我们提供每月服务报告邮件通知、服务专线专人接听并解决用户问题、定期巡检及时排除客户平台故障、其它邮件和远程协助服务。</p> // <p style='text-indent:2em; '>在2015年,为了使正版化平台运行更加稳定,也为给广大用户带来更加的丰富和多彩的正版化软件体验,我们将会恪尽职守,通过我们的不懈努力,为打造一个高效而稳定的平台系统,我们在此承诺:</p> // <p style='text-indent:2em; '>一、接到问题咨询问题,10分钟相应,1个小时之内出解决方案,争取在最短时间解决问题。完善的问题追踪制度,从我们接到问题直到问题完全解决,全程跟踪问题解决状态。</p> // <p style='text-indent:2em; '>二、以专业的精神和积极的态度,以丰富的经验和娴熟的技术确保正版化平台不断的完善和改进。</p> // <p style='text-indent:2em; '>三、继续将我们提供的服务以月报的方式反馈给管理人员。</p> // <p style='text-indent:2em; '>四、诚约老师对我们的工作进行监督,有任何意见、建议可以随时向我们沟通,意见反馈及投诉电话:010-62382945-8007。</p> // <p></p> // <p style='text-indent:2em;font-weight:bold; '>以下为{1}全年为您提供过的服务记录报告:</p> // <p style='text-indent:2em; '>共接到贵单位用户服务请求{2}个,其中{3};详细服务记录请见附件。</p> // <p></p> // <p style='text-indent:2em; '>2014已结束,令人期待的2015即将开始。环宇通达人不但要更好的服务客户,还要做到更多的创新与努力。敬请期待我们在2015中的表现!本邮件无需回复。</p> // <p style='text-indent:2em; '>感谢您一年中对我们工作的支持,环宇通达全体员工祝您,在2015年中工作顺利</p>", v.CC_EmailUserName, Convert.ToDateTime(strDate).ToString("yyyy年"), ds.Tables[0].Rows.Count, strTypeInfo); // } // else // { // strFilesPath = ""; // strTitle = string.Format("{0}微软正版化平台{1}份服务报告", v.CC_Name, Convert.ToDateTime(strDate).ToString("yyyy年")); // strBody = string.Format(@"{0},您好:<br /><br /> // <p style='text-indent:2em; '>环宇通达公司微软正版化售后服务部,首先感谢您一直以来对我们的支持和鼓励。回望2014年,环宇通达是不断创新的一年。对于正版化平台:我们综合了历年来所有的服务项目与众多用户提出的宝贵意见,积极改善了正版化平台的诸多功能。对于售后服务:我们提供每月服务报告邮件通知、服务专线专人接听并解决用户问题、定期巡检及时排除客户平台故障、其它邮件和远程协助服务。</p> // <p style='text-indent:2em; '>在2015年,为了使正版化平台运行更加稳定,也为给广大用户带来更加的丰富和多彩的正版化软件体验,我们将会恪尽职守,通过我们的不懈努力,为打造一个高效而稳定的平台系统,我们在此承诺:</p> // <p style='text-indent:2em; '>一、接到问题咨询问题,10分钟相应,1个小时之内出解决方案,争取在最短时间解决问题。完善的问题追踪制度,从我们接到问题直到问题完全解决,全程跟踪问题解决状态。</p> // <p style='text-indent:2em; '>二、以专业的精神和积极的态度,以丰富的经验和娴熟的技术确保正版化平台不断的完善和改进。</p> // <p style='text-indent:2em; '>三、继续将我们提供的服务以月报的方式反馈给管理人员。</p> // <p style='text-indent:2em; '>四、诚约老师对我们的工作进行监督,有任何意见、建议可以随时向我们沟通,意见反馈及投诉电话:010-62382945-8007。</p> // <p></p> // <p style='text-indent:2em; '>2014已结束,令人期待的2015即将开始。环宇通达人不但要更好的服务客户,还要做到更多的创新与努力。敬请期待我们在2015中的表现!本邮件无需回复。</p> // <p style='text-indent:2em; '>感谢您一年中对我们工作的支持,环宇通达全体员工祝您,在2015年中工作顺利</p>", v.CC_EmailUserName, Convert.ToDateTime(strDate).ToString("yyyy年")); // } #endregion strBody = string.Format(@"{0},您好:<br /><br /> <p style='text-indent:2em; '>环宇通达售后服务部,{1}份服务报告:</p> <p style='text-indent:2em; '>共接到贵单位用户服务请求{2}个,其中{3};详细服务记录请见附件。</p> <p style='text-indent:2em; '>为了更好的为提供技术支持和帮助,我公司为微软正版化客户开通了服务专线:400-079-8616。所有与微软正版化软件平台相关的问题(如:正版化平台的使用和操作问题、激活问题等)均可来电请求协助解决,我公司将为您提供专业、高效的服务。 <p style='text-indent:2em; '>在线常见问题库(可解决Windows 7激活报0xC004F035错误):http://www.hyitech.com/Error/CaActivehelp.html </p> 您会定期收到我公司提供的服务记录报告,有任何疑问请拨打服务专线咨询,本邮件无需回复。 </p> <p style='text-indent:2em; '>投诉电话:010-62364559转8007 </p>", v.CC_EmailUserName, Convert.ToDateTime(strDate).ToString("yyyy年MM月"), ds.Tables[0].Rows.Count, strTypeInfo); } else { strFilesPath = ""; strTitle = string.Format("{0}微软正版化平台{1}份服务报告", v.CC_Name, Convert.ToDateTime(strDate).ToString("yyyy年MM月")); strBody = string.Format(@"{0},您好:<br /><br /> <p style='text-indent:2em; '>环宇通达售后服务部,截至到{1}底没有接到贵单位的问题反馈。</p> <p style='text-indent:2em; '>为了更好的为提供技术支持和帮助,我公司为微软正版化客户开通了服务专线:400-079-8616。所有与微软正版化软件平台相关的问题(如:正版化平台的使用和操作问题、激活问题等)均可来电请求协助解决,我公司将为您提供专业、高效的服务。</p> <p style='text-indent:2em; '>在线常见问题库(可解决Windows 7激活报0xC004F035错误):http://www.hyitech.com/Error/CaActivehelp.html </p> 您会定期收到我公司提供的服务记录报告,有任何疑问请拨打服务专线咨询,本邮件无需回复。 </p> <p style='text-indent:2em; '>投诉电话:010-62364559转8007</p> ", v.CC_EmailUserName, Convert.ToDateTime(strDate).ToString("yyyy年MM月")); } string str = @"<br /><br /><br /> <p class='x_MsoNormal'> <span style='font-family: " 微软雅黑" ," sans-serif"'>多谢支持</span><span lang='EN-US'></span></p> <p class='x_MsoNormal'> <span lang='EN-US'> </span></p> <p class='x_MsoNormal'> <b><span lang='EN-US' style='font-size: 10.0pt; font-family: 微软雅黑,sans-serif" color: #1F497D'>Best regards</span></b></p> <table class='x_MsoNormalTable' border='0' cellspacing='0' cellpadding='0' style='border-collapse: collapse'> <tbody> <tr> <td width='93' valign='top' style='width: 69.9pt; border: none; border-right: dotted windowtext 1.0pt; padding: 0cm 5.4pt 0cm 5.4pt'> <p class='x_MsoNormal' style='line-height: 115%;margin:5px'> <span lang='EN-US' style='font-size: 12.0pt; line-height: 115%; font-family: 宋体; color: #1F497D'> <img id='x_图片_x0020_1' src='http://www.hyitech.com/logo.jpg' alt='说明: hytd' height='92' width='89' border='0'></span></p> </td> <td width='497' valign='top' style='width: 372.9pt; padding: 0cm 5.4pt 0cm 5.4pt'> <p class='x_MsoNormal' style='line-height: 115%;margin:5px'> <span style='font-size: 10.0pt; line-height: 115%; font-family: 华文行楷; color: #1F497D'> 售后支持服务</span><span lang='EN-US' style='font-size: 10.0pt; line-height: 115%; color: #1F497D'><br> </span><span lang='EN-US' style='font-size: 8.5pt; line-height: 115%; color: #1F497D'> | Fax:400-0798-616 | </span> </p> <p class='x_MsoNormal' style='line-height: 115%;margin:5px'> <span lang='EN-US' style='font-size: 8.5pt; line-height: 115%; color: #1F497D'>E-mail: </span><u><span lang='EN-US' style='font-size: 8.5pt; line-height: 115%; color: #0563C1'> <a href='#'>[email protected]</a></span></u><span lang='EN-US' style='font-size: 8.5pt; line-height: 115%; color: #1F497D'></span></p> <p class='x_MsoNormal' style='line-height: 115%;margin:5px'> <span lang='EN-US' style='font-size: 8.5pt; line-height: 115%; color: #1F497D'>Web: </span><span lang='EN-US'><a href='#' target='_blank'><span style='font-size: 8.5pt; line-height: 115%'>http://www.hyitech.com</span></a></span><span lang='EN-US' style='font-size: 8.5pt; line-height: 115%; color: #1F497D'> <br> </span><span style='font-size: 8.5pt; line-height: 115%; font-family: 宋体; color: #1F497D'> 北京环宇通达科技有限公司</span><span lang='DE' style='font-size: 8.5pt; line-height: 115%; color: #1F497D'></span></p> <p class='x_MsoNormal' style='line-height: 115%;margin:5px'><span style='font-size: 8.5pt; line-height: 115%; font-family: 宋体; color: #1F497D'>微软金牌合作伙伴 </span><span lang='EN-US' style='font-size: 8.5pt; line-height: 115%; color: #1F497D'> | </span><span style='font-size: 8.5pt; line-height: 115%; font-family: 宋体; color: #1F497D'> 教育行业解决方案专家 </span><span lang='EN-US' style='font-size: 8.5pt; line-height: 115%; color: #1F497D'></span> </p> </td> </tr> </tbody> </table>"; strBody += str; //if (ds.Tables[0].Rows.Count > 0) //{ if (bolIsTest) { strTitle = "测试邮件:" + strTitle; } sendMail(mailTo, v.CC_EmailUserName, mailCC, mailBCC, strTitle, strBody, strFilesPath); //} } } }
private void SendMailInfoSet(bool bolIsTest, string mailTo, string mailCC, string mailBCC, string strDate) { string strTitle = string.Empty; string strBody = string.Empty; string strFilesPath = string.Empty; string mailCCTO = mailCC; HYTD.BLL.Call_CustomerBLL bll = new HYTD.BLL.Call_CustomerBLL(); Models.Call_Customer mCustomer = new Models.Call_Customer(); List <Models.Call_Customer> mCustomerList = new List <Models.Call_Customer>(); mCustomerList = bll.GetCall_CustomerList().Where(c => c.CC_IsSend == 1).ToList(); int i = 0; foreach (var v in mCustomerList) { //i++; //if (i > 2) // break; if (v.CC_Status > 0 && v.CC_Email != null && v.CC_Email.Trim().Length > 0) { if (!bolIsTest) { mailTo = mailCC = ""; mailTo = v.CC_Email; if (mailCCTO.Length > 0) { mailCC = v.CC_CCEmail + "," + mailCCTO; } //密送给所属工程师 if (v.CC_Owner == "29") { mailBCC += ",[email protected]"; } else if (v.CC_Owner == "37") { mailBCC += ",[email protected]"; } else if (v.CC_Owner == "54") { mailBCC += ",[email protected]"; } else { mailBCC += ",[email protected]"; } } else { if (v.CC_Owner == "29") { mailTo = "*****@*****.**"; } else if (v.CC_Owner == "37") { mailTo = "*****@*****.**"; } else if (v.CC_Owner == "43") { mailTo = "*****@*****.**"; } else { mailTo = "*****@*****.**"; } } //获取附件 如果没有附件则不添加 DataSet ds = new DataSet(); HYTD.BLL.Call_WorkBillBLL bllworkbill = new HYTD.BLL.Call_WorkBillBLL(); string strWhere = string.Format("CWB_CCID={0} and convert(varchar(7),CWB_CreateTime,120)='{1}'", v.CC_ID, strDate.Substring(0, 7)); ds = bllworkbill.ImportExcelCustomerWorkBill(strWhere); if (ds.Tables[0].Rows.Count > 0) { strFilesPath = getFile(ds.Tables[0]); string strTypeInfo = string.Empty; strTypeInfo = getTypeInfo(ds.Tables[1]); strTitle = string.Format("{0}微软正版化平台{1}份服务报告", v.CC_Name, Convert.ToDateTime(strDate).ToString("yyyy年MM月")); strBody = string.Format(@"{0},您好:<br /><br /> <p style='text-indent:2em; '>环宇通达售后服务部,{1}份服务报告:</p> <p style='text-indent:2em; '>共接到贵单位用户服务请求{2}个,其中{3};详细服务记录请见附件。</p> <p style='text-indent:2em; '>为了更好的为提供技术支持和帮助,我公司为微软正版化客户开通了服务专线:400-079-8616。所有与微软正版化软件平台相关的问题(如:正版化平台的使用和操作问题、激活问题等)均可来电请求协助解决,我公司将为您提供专业、高效的服务。 <p style='text-indent:2em; '>在线常见问题库(可解决Windows 7激活报0xC004F035错误):http://www.hyitech.com/Error/CaActivehelp.html </p> 您会定期收到我公司提供的服务记录报告,有任何疑问请拨打服务专线咨询,本邮件无需回复。 </p> <p style='text-indent:2em; '>投诉电话:010-62364559转8007 </p>", v.CC_EmailUserName, Convert.ToDateTime(strDate).ToString("yyyy年MM月"), ds.Tables[0].Rows.Count, strTypeInfo); } else { strFilesPath = ""; strTitle = string.Format("{0}微软正版化平台{1}份服务报告", v.CC_Name, Convert.ToDateTime(strDate).ToString("yyyy年MM月")); strBody = string.Format(@"{0},您好:<br /><br /> <p style='text-indent:2em; '>环宇通达售后服务部,截至到{1}底没有接到贵单位的问题反馈。</p> <p style='text-indent:2em; '>为了更好的为提供技术支持和帮助,我公司为微软正版化客户开通了服务专线:400-079-8616。所有与微软正版化软件平台相关的问题(如:正版化平台的使用和操作问题、激活问题等)均可来电请求协助解决,我公司将为您提供专业、高效的服务。</p> <p style='text-indent:2em; '>在线常见问题库(可解决Windows 7激活报0xC004F035错误):http://www.hyitech.com/Error/CaActivehelp.html </p> 您会定期收到我公司提供的服务记录报告,有任何疑问请拨打服务专线咨询,本邮件无需回复。 </p> <p style='text-indent:2em; '>投诉电话:010-62364559转8007</p> ", v.CC_EmailUserName, Convert.ToDateTime(strDate).ToString("yyyy年MM月")); } string str = @"<br /><br /><br /> <p class='x_MsoNormal'> <span style='font-family: " 微软雅黑" ," sans-serif"'>多谢支持</span><span lang='EN-US'></span></p> <p class='x_MsoNormal'> <span lang='EN-US'> </span></p> <p class='x_MsoNormal'> <b><span lang='EN-US' style='font-size: 10.0pt; font-family: 微软雅黑,sans-serif" color: #1F497D'>Best regards</span></b></p> <table class='x_MsoNormalTable' border='0' cellspacing='0' cellpadding='0' style='border-collapse: collapse'> <tbody> <tr> <td width='93' valign='top' style='width: 69.9pt; border: none; border-right: dotted windowtext 1.0pt; padding: 0cm 5.4pt 0cm 5.4pt'> <p class='x_MsoNormal' style='line-height: 115%;margin:5px'> <span lang='EN-US' style='font-size: 12.0pt; line-height: 115%; font-family: 宋体; color: #1F497D'> <img id='x_图片_x0020_1' src='http://www.hyitech.com/logo.jpg' alt='说明: hytd' height='92' width='89' border='0'></span></p> </td> <td width='497' valign='top' style='width: 372.9pt; padding: 0cm 5.4pt 0cm 5.4pt'> <p class='x_MsoNormal' style='line-height: 115%;margin:5px'> <span style='font-size: 10.0pt; line-height: 115%; font-family: 华文行楷; color: #1F497D'> 售后支持服务</span><span lang='EN-US' style='font-size: 10.0pt; line-height: 115%; color: #1F497D'><br> </span><span lang='EN-US' style='font-size: 8.5pt; line-height: 115%; color: #1F497D'> | Fax:400-0798-616 | </span> </p> <p class='x_MsoNormal' style='line-height: 115%;margin:5px'> <span lang='EN-US' style='font-size: 8.5pt; line-height: 115%; color: #1F497D'>E-mail: </span><u><span lang='EN-US' style='font-size: 8.5pt; line-height: 115%; color: #0563C1'> <a href='#'>[email protected]</a></span></u><span lang='EN-US' style='font-size: 8.5pt; line-height: 115%; color: #1F497D'></span></p> <p class='x_MsoNormal' style='line-height: 115%;margin:5px'> <span lang='EN-US' style='font-size: 8.5pt; line-height: 115%; color: #1F497D'>Web: </span><span lang='EN-US'><a href='#' target='_blank'><span style='font-size: 8.5pt; line-height: 115%'>http://www.hyitech.com</span></a></span><span lang='EN-US' style='font-size: 8.5pt; line-height: 115%; color: #1F497D'> <br> </span><span style='font-size: 8.5pt; line-height: 115%; font-family: 宋体; color: #1F497D'> 北京环宇通达科技有限公司</span><span lang='DE' style='font-size: 8.5pt; line-height: 115%; color: #1F497D'></span></p> <p class='x_MsoNormal' style='line-height: 115%;margin:5px'><span style='font-size: 8.5pt; line-height: 115%; font-family: 宋体; color: #1F497D'>微软金牌合作伙伴 </span><span lang='EN-US' style='font-size: 8.5pt; line-height: 115%; color: #1F497D'> | </span><span style='font-size: 8.5pt; line-height: 115%; font-family: 宋体; color: #1F497D'> 教育行业解决方案专家 </span><span lang='EN-US' style='font-size: 8.5pt; line-height: 115%; color: #1F497D'></span> </p> </td> </tr> </tbody> </table>"; strBody += str; //if (ds.Tables[0].Rows.Count > 0) //{ if (bolIsTest) { strTitle = "测试邮件:" + strTitle; } sendMail(mailTo, v.CC_EmailUserName, mailCC, mailBCC, strTitle, strBody, strFilesPath); //} } } }