protected override void SendAddtionalNotification()
        {
            Hashtable args = new Hashtable();

            args = Base.GetParameter(this.ToString(), nc.ToString());
            string mailcc;
            string managerId;
            int    day1, day2, day3, day4, day5;

            if (args == null || args.Count != 5)
            {
                day1 = 1; day2 = 2; day3 = 3; day4 = 4; day5 = 5;
            }
            else
            {
                day1 = int.Parse(args["day1"].ToString());
                day2 = day1 + int.Parse(args["day2"].ToString());
                day3 = day2 + int.Parse(args["day3"].ToString());
                day4 = day3 + int.Parse(args["day4"].ToString());
                day5 = day4 + int.Parse(args["day5"].ToString());
            }
            string[] title = new string[] { "产品", "区域", "客户代码", "客户简称", "业务", "姓名", "未逾期", "逾期款", "本月到期", "逾期" + day1 + "月",
                                            "逾期" + day2 + "月", "逾期" + day3 + "月", "逾期" + day4 + "月", "逾期" + day5 + "月", "超过" + day5 + "月", "账款合计", "本月应收", "逾期应收", "本月总应收" };
            int[]    width = new int[] { 40, 40, 70, 80, 60, 60, 80, 80, 80, 80, 80, 80, 80, 80, 80, 90, 80, 80, 80 };
            string[] p     = new string[] { };

            foreach (DataRow row in nc.GetDataTable("tblresult").Rows)
            {
                if (p.Contains(row["userno"].ToString()))
                {
                    continue;
                }
                Array.Resize(ref p, p.Length + 1);
                p.SetValue(row["userno"].ToString(), p.Length - 1);

                nc.GetDataTable("tblresult").DefaultView.RowFilter = " userno='" + row["userno"].ToString() + "'";

                NotificationContent msg = new NotificationContent();
                //msg.AddTo("*****@*****.**");
                //抄送给直属主管
                //msg.AddTo(row["userno"].ToString() + "@" + Base.GetMailAccountDomain());
                //mailcc = GetManagerIdByEmployeeIdFromOA(row["userno"].ToString());
                //if (mailcc.ToString() != "")
                //{
                //    mailcc = mailcc +  "@" + Base.GetMailAccountDomain();
                //    msg.AddCc(mailcc);
                //}
                msg.AddTo(GetMailAddressByEmployeeIdFromOA(row["userno"].ToString()));
                managerId = GetManagerIdByEmployeeIdFromOA(row["userno"].ToString());
                if (managerId != null && managerId.ToString() != "" && !managerId.ToString().Equals("C0002") && !managerId.ToString().Equals("C0616"))
                {
                    msg.AddCc(GetMailAddressByEmployeeIdFromOA(managerId));
                }
                msg.subject = this.subject;
                msg.content = GetContent(nc.GetDataTable("tblresult").DefaultView.ToTable(), title, width);
                msg.AddNotify(new MailNotify());
                msg.Update();
                msg.Dispose();
            }
        }
Example #2
0
        protected override void SendAddtionalNotification()
        {
            string table1;

            string[]            p   = new string[] { };
            string[]            d   = new string[] { };
            NotificationContent msg = new NotificationContent();

            foreach (DataRow row in nc.GetDataTable("tbresult").Rows)
            {
                if (!p.Contains(row["userno"].ToString()))
                {
                    Array.Resize(ref p, p.Length + 1);
                    p.SetValue(row["userno"].ToString(), p.Length - 1);
                    //string userno = row["userno"].ToString();
                    msg.AddTo(GetMailAddressByEmployeeIdFromOA(row["userno"].ToString()));
                }
            }
            table1 = GetHTMLTable(nc.GetDataTable("tbresult").DefaultView.ToTable(), null, null);

            if (nc.GetDataTable("tbresult").DefaultView.ToTable().Rows.Count > 0)
            {
                table1 = "以下已点收GB 物料 ,请技术人员配合检验 <br/>" + table1;
            }
            msg.AddCc("*****@*****.**");
            msg.AddCc("*****@*****.**");
            msg.AddCc("*****@*****.**");
            msg.AddCc("*****@*****.**");
            msg.AddBcc("*****@*****.**");
            msg.subject = this.subject;
            msg.content = GetContentHead() + table1 + GetContentFooter();
            msg.AddNotify(new MailNotify());
            msg.Update();
            msg.Dispose();
        }
Example #3
0
        protected override void SendAddtionalNotification()
        {
            string deptid;
            string managerId;
            string table1;

            string[] p = new string[] { };

            foreach (DataRow row in nc.GetDataTable("tbprivatecar").Rows)
            {
                deptid = row["hdn_dept"].ToString().Substring(0, 2) + "000";
                if (p.Contains(deptid))
                {
                    continue;
                }
                //if (row["id"].ToString().Substring(0, 1).Equals("H") || row["id"].ToString().Substring(0, 1).Equals("Q") || row["id"].ToString().Substring(0, 1).Equals("V")) continue;
                Array.Resize(ref p, p.Length + 1);
                p.SetValue(deptid, p.Length - 1);
                nc.GetDataTable("tbprivatecar").DefaultView.RowFilter = "hdn_dept like'" + row["hdn_dept"].ToString().Substring(0, 2) + "%'";
                table1 = GetHTMLTable(nc.GetDataTable("tbprivatecar").DefaultView.ToTable(), null, null);

                if (nc.GetDataTable("tbprivatecar").DefaultView.ToTable().Rows.Count > 0)
                {
                    table1 = "以下各部门私车公用人员每月私车公用的汇总表<br/>" + table1;
                }



                NotificationContent msg = new NotificationContent();
                //发送给部门主管(大部门)
                managerId = GetManagerIdByDeptidFromOA(deptid);
                if (managerId == null || managerId == "")
                {
                    table1 = "未找到单据 , 部门:" + deptid;
                    msg.AddTo(GetMailAddressByEmployeeIdFromOA("C1491"));
                    continue;
                }
                else if (managerId.ToString() != "")
                {
                    msg.AddTo(GetMailAddressByEmployeeIdFromOA(managerId));
                    //msg.AddTo(GetMailAddressByEmployeeIdFromOA("C1491"));
                }

                msg.subject = this.subject;
                msg.content = GetContentHead() + table1 + GetContentFooter();
                msg.AddNotify(new MailNotify());
                msg.Update();
                msg.Dispose();
            }
        }
Example #4
0
        protected override void SendAddtionalNotification()
        {
            string table1;

            string[] p = new string[] { };

            foreach (DataRow row in nc.GetDataTable("tbresult").Rows)
            {
                if (p.Contains(row["userno"].ToString()))
                {
                    continue;
                }
                //if (row["id"].ToString().Substring(0, 1).Equals("H") || row["id"].ToString().Substring(0, 1).Equals("Q") || row["id"].ToString().Substring(0, 1).Equals("V")) continue;
                Array.Resize(ref p, p.Length + 1);
                p.SetValue(row["userno"].ToString(), p.Length - 1);
                nc.GetDataTable("tbresult").DefaultView.RowFilter = " userno ='" + row["userno"].ToString() + "'";
                table1 = GetHTMLTable(nc.GetDataTable("tbresult").DefaultView.ToTable(), null, null);

                if (nc.GetDataTable("tbresult").DefaultView.ToTable().Rows.Count > 0)
                {
                    table1 = "以下采购单未交货明细汇总表<br/>" + table1;
                }



                NotificationContent msg = new NotificationContent();
                //string userno = row["userno"].ToString();
                msg.AddTo(GetMailAddressByEmployeeIdFromOA(row["userno"].ToString()));
                //msg.AddCc(GetMailAddressByEmployeeIdFromOA(row["buyer"].ToString()));
                //string str1 = "</br>" + userno;
                //msg.AddCc(GetMailAddressByEmployeeIdFromOA("C1491"));
                msg.subject = this.subject;
                msg.content = GetContentHead() + table1 + GetContentFooter();
                msg.AddNotify(new MailNotify());
                msg.Update();
                msg.Dispose();
            }
        }
Example #5
0
        protected override void SendAddtionalNotification()
        {
            string managerId;
            string table1, table2;

            string[]  p = new string[] { };
            DataTable tbl;

            foreach (DataRow row in nc.GetDataTable("tblprocess").Rows)
            {
                if (row["id"].ToString().Substring(0, 1).Equals("H") || row["id"].ToString().Substring(0, 1).Equals("Q") || row["id"].ToString().Substring(0, 1).Equals("V") || row["id"].ToString().Substring(0, 1).Equals("Y") || row["id"].ToString().Substring(0, 1).Equals("R"))
                {
                    continue;
                }
                if (p.Contains(row["id"].ToString()))
                {
                    continue;
                }
                Array.Resize(ref p, p.Length + 1);
                p.SetValue(row["id"].ToString(), p.Length - 1);
                nc.GetDataTable("tblprocess").DefaultView.RowFilter = " id='" + row["id"].ToString() + "'";
                tbl = nc.GetDataTable("tblprocess").DefaultView.ToTable();
                tbl.Columns.Remove("deptno");
                tbl.Columns.Remove("dept");
                table1 = GetHTMLTable(tbl, null, null);

                nc.GetDataTable("tblprocess").DefaultView.RowFilter = " id='" + row["id"].ToString() + "' AND delaydays > 5 ";
                tbl = nc.GetDataTable("tblprocess").DefaultView.ToTable();
                tbl.Columns.Remove("deptno");
                tbl.Columns.Remove("dept");
                if (tbl.Rows.Count > 0)
                {
                    table2 = "以下单据已超过5天,请向柯副董说明原因!<br/>" + GetHTMLTable(tbl, null, null);
                }
                else
                {
                    table2 = "没有超过5天及以上的未签核单据";
                }


                NotificationContent msg = new NotificationContent();
                //msg.AddTo("*****@*****.**");
                msg.AddTo(GetMailAddressByEmployeeIdFromOA(row["id"].ToString()));
                if (nc.GetDataTable("tblprocess").DefaultView.ToTable().Rows.Count > 0)
                {
                    //抄送直属主管
                    managerId = GetManagerIdByEmployeeIdFromOA(row["id"].ToString());
                    if (managerId != null && managerId.ToString() != "" && !managerId.ToString().Equals("C0002") && !managerId.ToString().Equals("C0616"))
                    {
                        msg.AddCc(GetMailAddressByEmployeeIdFromOA(managerId));
                    }
                    if (!row["id"].ToString().Substring(0, 1).Equals("0") && !row["id"].ToString().Equals("C0002"))
                    {
                        msg.AddCc("*****@*****.**");
                    }
                }
                msg.subject = row["deptno"].ToString() + row["dept"].ToString() + "_" + this.subject;
                msg.content = GetContentHead() + table1 + "<br/><br/><br/>" + table2 + GetContentFooter();
                msg.AddNotify(new MailNotify());
                msg.Update();
                msg.Dispose();
            }
        }