public static void AddOrDelDesktopNotifications(string prjId, bool isEReport) { PTPrjInfoBll bll = new PTPrjInfoBll(); PrjInfoModel modelByPrjGuid = new PrjInfoModel(); modelByPrjGuid = bll.GetModelByPrjGuid(prjId); string podepom = modelByPrjGuid.Podepom; string[] strArray = new string[0]; if ((podepom != null) && podepom.Contains <char>(',')) { strArray = podepom.Split(new char[] { ',' }); } PTDbsjBll bll2 = new PTDbsjBll(); bll2.DelPastDueData(prjId); if (isEReport) { foreach (string str2 in strArray) { if (str2 != "") { StringBuilder builder = new StringBuilder(); builder.Append("项目:" + modelByPrjGuid.PrjName); builder.Append("的间接成本已经上报,请审核!"); PTDbsjModel model = new PTDbsjModel { C_OpenFlag = "0", DTM_DBSJ = DateTime.Now, I_XGID = prjId, V_Content = builder.ToString(), V_DBLJ = "BudgetManage/Cost/IndirectBudgetQuery.aspx?id=" + prjId, V_LXBM = "021", V_TPLJ = "new_Mail.gif", V_YHDM = str2 }; try { bll2.Add(model); } catch { } } } } }
public static void AddOrDelDesktopNotifications(string id, bool isEReport) { string zZJGName = GetZZJGName(id); StringBuilder builder = new StringBuilder(); builder.Append("SELECT v_yhdm FROM PT_yhmc"); builder.AppendLine(); builder.AppendFormat("WHERE i_bmdm='{0}' AND State='1' AND c_sfyx='y'", id); SqlDataReader reader = SqlHelper.ExecuteReader(CommandType.Text, builder.ToString(), new SqlParameter[0]); PTDbsjBll bll = new PTDbsjBll(); bll.DelPastDueData(id); while (reader.Read()) { if (isEReport) { string str2 = reader["v_yhdm"].ToString(); if (str2 != "") { StringBuilder builder2 = new StringBuilder(); builder2.Append("组织机构:" + zZJGName); builder2.Append("的间接成本预算已经上报,请审核!"); PTDbsjModel model = new PTDbsjModel { C_OpenFlag = "0", DTM_DBSJ = DateTime.Now, I_XGID = id, V_Content = builder2.ToString(), V_DBLJ = "BudgetManage/Cost/IndirectBudgetQuery.aspx?id=" + id, V_LXBM = "021", V_TPLJ = "new_Mail.gif", V_YHDM = str2 }; bll.Add(model); } } } }
public static void AddOrDelDesktopNotifications(string id, bool isEReport) { string zzjgName = OrganizationBudget.GetZZJGName(id); System.Text.StringBuilder sqlYHMC = new System.Text.StringBuilder(); sqlYHMC.Append("SELECT v_yhdm FROM PT_yhmc"); sqlYHMC.AppendLine(); sqlYHMC.AppendFormat("WHERE i_bmdm='{0}' AND State='1' AND c_sfyx='y'", id); SqlDataReader sdrYHBM = SqlHelper.ExecuteReader(CommandType.Text, sqlYHMC.ToString(), new SqlParameter[0]); PTDbsjBll pTDbsjBll = new PTDbsjBll(); pTDbsjBll.DelPastDueData(id); while (sdrYHBM.Read()) { if (isEReport) { string people = sdrYHBM["v_yhdm"].ToString(); if (people != "") { System.Text.StringBuilder content = new System.Text.StringBuilder(); content.Append("组织机构:" + zzjgName); content.Append("的间接成本预算已经上报,请审核!"); pTDbsjBll.Add(new PTDbsjModel { C_OpenFlag = "0", DTM_DBSJ = System.DateTime.Now, I_XGID = id, V_Content = content.ToString(), V_DBLJ = "BudgetManage/Cost/IndirectBudgetQuery.aspx?id=" + id, V_LXBM = "021", V_TPLJ = "new_Mail.gif", V_YHDM = people }); } } } }