public static List <object> GetSelectUserItems(string strMessageId) { List <object> listResult = new List <object>(); DataTable dt = new DataTable(); DataTable dtDuty = new DataTable(); dt = new TSysUserLogic().SelectByTableUnderDept("", 0, 0); TOaMessageInfoVo objMessage = new TOaMessageInfoLogic().Details(strMessageId); DataTable dtItems = new DataTable(); dtItems = dt.Copy(); dtItems.Clear(); if (objMessage.ACCEPT_USERIDS.Length > 0) { for (int i = 0; i < objMessage.ACCEPT_USERIDS.Split(',').Length; i++) { DataRow[] dr = dt.Select("ID='" + objMessage.ACCEPT_USERIDS.Split(',')[i] + "'"); if (dr != null) { foreach (DataRow Temrow in dr) { dtItems.ImportRow(Temrow); } } } } listResult = LigerGridSelectDataToJson(dtItems, dtItems.Rows.Count); return(listResult); }
//获取数据 private void GetData(string strID) { TOaMessageInfoVo objMessage = new TOaMessageInfoLogic().Details(strID); objMessage.SEND_BY = new TSysUserLogic().Details(objMessage.SEND_BY).REAL_NAME; objMessage.REMARK1 = LogInfo.UserInfo.ID; string strJson = ToJson(objMessage); Response.Write(strJson); Response.End(); }
public static string deleteData(string strValue) { TOaMessageInfoVo objMessage = new TOaMessageInfoVo(); objMessage.ID = strValue; bool isSuccess = new TOaMessageInfoLogic().Delete(objMessage); if (isSuccess) { new PageBase().WriteLog("删除短发送消息", "", new UserLogInfo().UserInfo.USER_NAME + "删除发送短消息" + objMessage.ID); } return(isSuccess == true ? "1" : "0"); }
//获取信息 private string getMessage() { string strSortname = Request.Params["sortname"]; string strSortorder = Request.Params["sortorder"]; string strDept = ""; //当前页面 int intPageIndex = Convert.ToInt32(Request.Params["page"]); //每页记录数 int intPageSize = Convert.ToInt32(Request.Params["pagesize"]); if (strSortname == null || strSortname.Length < 0) { strSortname = TOaMessageInfoVo.ID_FIELD; } DataTable dtDept = new TSysPostLogic().SelectByTable_byUser(LogInfo.UserInfo.ID); for (int i = 0; i < dtDept.Rows.Count; i++) { string strDeptCode = dtDept.Rows[i]["POST_DEPT_ID"].ToString(); if (strDeptCode.Length > 0) { strDept += (strDept.Length > 0) ? "," + strDeptCode : strDeptCode; } } TOaMessageInfoVo objMessage = new TOaMessageInfoVo(); objMessage.SORT_FIELD = strSortname; objMessage.SORT_TYPE = strSortorder; DataTable dt = new TOaMessageInfoLogic().SelectByUserIdAndDept(LogInfo.UserInfo.ID, intPageIndex, intPageSize); int intTotalCount = new TOaMessageInfoLogic().GetSelectByUserIdAndDeptCount(LogInfo.UserInfo.ID, strDept); for (int i = 0; i < dt.Rows.Count; i++) { if (dt.Rows[i]["REMARK1"].ToString() == "0") { dt.Rows[i]["REMARK1"] = "未读"; } if (dt.Rows[i]["REMARK1"].ToString() == "1") { dt.Rows[i]["REMARK1"] = "已读"; } } string strJson = CreateToJson(dt, intTotalCount); return(strJson); }
public static List <object> GetSubUserItems(string strPost_Dept, string strMessageId) { List <object> listResult = new List <object>(); DataTable dt = new DataTable(); TSysUserVo objUser = new TSysUserVo(); objUser.IS_DEL = "0"; dt = new TSysUserLogic().SelectByTableUnderDept(strPost_Dept, 0, 0); TOaMessageInfoVo objMessage = new TOaMessageInfoLogic().Details(strMessageId); DataTable dtItems = new DataTable(); dtItems = dt.Copy(); dtItems.Clear(); if (objMessage.ACCEPT_USERIDS.Length > 0) { for (int i = 0; i < objMessage.ACCEPT_USERIDS.Split(',').Length; i++) { DataRow[] dr = dt.Select("ID='" + objMessage.ACCEPT_USERIDS.Split(',')[i] + "'"); if (dr != null) { foreach (DataRow Temrow in dr) { Temrow.Delete(); dt.AcceptChanges(); } } } } dtItems = dt.Copy(); listResult = LigerGridSelectDataToJson(dtItems, dtItems.Rows.Count); return(listResult); }