//页面初始化 private void InitPage() { BindDataDictToControl("FW_MJ", this.MJ); this.FW_DATE.Text = DateTime.Now.ToString("yyyy/MM/dd"); this.USER_NAME.Text = LogInfo.UserInfo.REAL_NAME; this.USER_ID.Value = LogInfo.UserInfo.ID; //this.APP_INFO.Disabled = true; this.ISSUE_INFO.Disabled = true; if (this.hidView.Value == "true") { TOaFwInfoVo objFW = new TOaFwInfoLogic().Details(this.hidTaskId.Value); BindObjectToControls(objFW, this.form1); base.DisableAllControls(this.form1); this.MJ.Text = objFW.MJ; this.START_DATE.Text = DateTime.Parse(objFW.START_DATE).ToShortDateString(); this.END_DATE.Text = DateTime.Parse(objFW.END_DATE).ToShortDateString(); this.FW_DATE.Text = DateTime.Parse(objFW.FW_DATE).ToString("yyyy/MM/dd"); //this.APP_ID.Text = (objFW.APP_ID.Length > 0) ? new TSysUserLogic().Details(objFW.APP_ID).REAL_NAME : ""; //this.APP_DATE.Text = (objFW.APP_DATE.Length > 0) ? DateTime.Parse(objFW.APP_DATE).ToShortDateString() : ""; this.ISSUE_ID.Text = (objFW.ISSUE_ID.Length > 0) ? new TSysUserLogic().Details(objFW.ISSUE_ID).REAL_NAME : ""; this.ISSUE_DATE.Text = (objFW.ISSUE_DATE.Length > 0) ? DateTime.Parse(objFW.ISSUE_DATE).ToShortDateString() : ""; this.divContratSubmit.Visible = false; this.divBack.Visible = true; this.btnFileUp.Visible = false; List <TOaSwReadVo> list = new TOaSwReadLogic().SelectByReadUser(objFW.ID); string str = ""; for (int i = 0; i < list.Count; i++) { string swid = list[i].SW_PLAN_ID; string swname = new TSysUserLogic().Details(swid).REAL_NAME; if (i == 0) { str = swname; } else if (i > 0) { str = str + "," + swname; } } this.Text1.Value = str; this.TReadUserList.Attributes.Add("style", "display:block"); } else if (this.hidTaskId.Value.Length > 0) { TOaFwInfoVo objFW = new TOaFwInfoLogic().Details(this.hidTaskId.Value); BindObjectToControls(objFW, this.form1); this.FW_DATE.Text = DateTime.Parse(objFW.FW_DATE).ToString("yyyy/MM/dd"); this.START_DATE.Text = DateTime.Parse(objFW.START_DATE).ToShortDateString(); this.END_DATE.Text = DateTime.Parse(objFW.END_DATE).ToShortDateString(); this.FW_DATE.Text = DateTime.Parse(objFW.FW_DATE).ToString("yyyy/MM/dd"); } }
public static List <object> GetSelectUserItems(string strUserID) { List <object> listResult = new List <object>(); DataTable dt = new DataTable(); DataTable dtDuty = new DataTable(); dt = new TSysUserLogic().SelectByTableUnderDept("", 0, 0); DataTable dtItems = new DataTable(); dtItems = dt.Copy(); dtItems.Clear(); if (strUserID.Length > 0) { for (int i = 0; i < strUserID.Split(',').Length; i++) { DataRow[] dr = dt.Select("ID='" + strUserID.Split(',')[i] + "'"); if (dr != null) { foreach (DataRow Temrow in dr) { dtItems.ImportRow(Temrow); } } } } listResult = LigerGridSelectDataToJson(dtItems, dtItems.Rows.Count); return(listResult); }
private void HandlerDataBind() { TSysUserVo objUser = new TSysUserVo(); objUser.IS_USE = "1"; objUser.IS_DEL = "0"; objUser.IS_HIDE = "0"; DataTable dt = new DataTable(); dt = new TSysUserLogic().SelectByTable(objUser); HandlerList.DataSource = dt; HandlerList.DataTextField = "REAL_NAME"; HandlerList.DataValueField = "ID"; HandlerList.DataBind(); //有直接上级就默认选择直接上级 if (HandlerList.Items.Count > 0) { string strLocalUserID = base.LogInfo.UserInfo.ID; DataTable dtDeptAdmin = new TSysUserPostLogic().SelectDeptAdmin_byTable(strLocalUserID); if (dtDeptAdmin.Rows.Count > 0) { string strDeptAdminId = dtDeptAdmin.Rows[0]["user_id"].ToString(); for (int i = 0; i < HandlerList.Items.Count; i++) { if (HandlerList.Items[i].Value == strDeptAdminId) { HandlerList.SelectedIndex = i; } } } } }
public string SaveUserInfo() { bool isSuccess = true; string strSamplingMan = ""; TMisMonitorSubtaskVo objSubtask = new TMisMonitorSubtaskVo(); if (this.strTaskId.Value.Trim() == "") { objSubtask.ID = this.strSubTaskId.Value; objSubtask.SAMPLING_ID = Request["txtDefaultUserId"]; for (int i = 0; i < objSubtask.SAMPLING_ID.Split(',').Length; i++) { TSysUserVo objUser = new TSysUserLogic().Details(objSubtask.SAMPLING_ID.Split(',')[i]); strSamplingMan += (strSamplingMan.Length > 0) ? "," + objUser.REAL_NAME : objUser.REAL_NAME; } objSubtask.SAMPLING_MAN = strSamplingMan; isSuccess = new TMisMonitorSubtaskLogic().Edit(objSubtask); } else { //在采样分配环节批量修改协同人 add by weilin objSubtask.SAMPLING_ID = Request["txtDefaultUserId"]; for (int i = 0; i < objSubtask.SAMPLING_ID.Split(',').Length; i++) { TSysUserVo objUser = new TSysUserLogic().Details(objSubtask.SAMPLING_ID.Split(',')[i]); strSamplingMan += (strSamplingMan.Length > 0) ? "," + objUser.REAL_NAME : objUser.REAL_NAME; } objSubtask.SAMPLING_MAN = strSamplingMan; TMisMonitorSubtaskVo objWhere = new TMisMonitorSubtaskVo(); objWhere.TASK_ID = this.strTaskId.Value.Trim(); objWhere.TASK_STATUS = "01"; isSuccess = new TMisMonitorSubtaskLogic().Edit(objSubtask, objWhere); } return isSuccess == true ? "1" : "0"; }
/// <summary> /// 加载用户列表 /// </summary> /// <param name="iIndex"></param> /// <param name="iCount"></param> /// <returns></returns> public string GetUserList(int iIndex, int iCount) { string reslut = ""; dt = new DataTable(); // dt = new TSysDutyLogic().SelectByUnionTable(iIndex,iCount); TSysUserVo objVo = new TSysUserVo(); objVo.IS_DEL = "0"; objVo.IS_USE = "1"; objVo.IS_HIDE = "0"; if (Request.QueryString["strSrhDept_ID"] != null) { objVo.REMARK4 = Request.QueryString["strSrhDept_ID"]; } if (Request.QueryString["srhUserName"] != null) { objVo.REAL_NAME = Request.QueryString["srhUserName"]; } dt = new TSysUserLogic().SelectByTable_ByDept(objVo, iIndex, iCount); int intCount = new TSysUserLogic().GetSelectResultCount_ByDept(objVo); reslut = LigerGridDataToJson(dt, intCount); return(reslut); }
/// <summary> /// 初始化用户信息数据 /// </summary> /// <param name="strUserID">用户ID</param> protected void InitUserData(string strUserID) { TSysUserVo objUserVo = new TSysUserLogic().Details(strUserID); strBrithday = objUserVo.BIRTHDAY; BindObjectToControlsMode(objUserVo); }
private string GetCheckUser(string strMonitorID) { string strUserIDs = ""; DataTable dt = new DataTable(); //TSysUserPostVo UserPostVo = new TSysUserPostVo(); //UserPostVo.POST_ID = "000000030"; //dt = new TSysUserPostLogic().SelectByTable(UserPostVo); //for (int i = 0; i < dt.Rows.Count; i++) //{ // strUserIDs += dt.Rows[i]["USER_ID"].ToString() + ","; //} DataTable strSampleCheckSender = GetDefaultOrFirstDutyUser("duty_other_sample", strMonitorID); for (int i = 0; i < strSampleCheckSender.Rows.Count; i++) { strUserIDs += strSampleCheckSender.Rows[i]["USERID"].ToString() + ","; } TSysUserVo SysUserVo = new TSysUserVo(); SysUserVo.ID = strUserIDs.TrimEnd(','); SysUserVo.IS_DEL = "0"; SysUserVo.IS_USE = "1"; dt = new TSysUserLogic().SelectByTableEx(SysUserVo, 0, 0); return(DataTableToJson(dt)); }
public static List <object> GetSubUserItems(string strPost_Dept, string strUserID) { 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); DataTable dtItems = new DataTable(); dtItems = dt.Copy(); dtItems.Clear(); if (strUserID.Length > 0) { for (int i = 0; i < strUserID.Split(',').Length; i++) { DataRow[] dr = dt.Select("ID='" + strUserID.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); }
/// <summary> /// 获取用户名称 /// </summary> /// <param name="strId"></param> /// <returns></returns> private string GetUserName(string strId) { TSysUserVo objItems = new TSysUserLogic().Details(new TSysUserVo { ID = strId, IS_DEL = "0" }); return(objItems.REAL_NAME); }
/// <summary> /// 发手机短信 /// </summary> /// <param name="strMESSAGE_CONTENT">短消息内容</param> /// <param name="strSendUserID">发送人id</param> /// <param name="strAccUsers">接收人ID串,用逗号“,”分隔</param> /// <param name="isAtOnce">是否立即发送</param> /// <param name="strSEND_DATE">定期发送的时间,yyyy-MM-dd HH:mm:ss</param> /// <returns></returns> public void SendMobilMessage(string strMESSAGE_CONTENT, string strSendUserID, string strAccUsers, bool isAtOnce, string strSEND_DATE) { SMS.Db.connectionstring = strConnection; DataTable dtUser = new TSysUserLogic().SelectByTable(new TSysUserVo { IS_DEL = "0", IS_HIDE = "0", IS_USE = "1" }); DataRow[] drSenderS = dtUser.Select("id='" + strSendUserID + "'"); string strSendUser = ""; if (drSenderS.Length > 0) { strSendUser = drSenderS[0]["REAL_NAME"].ToString(); } if (strAccUsers.Length == 0) { return; } string[] arrAccUsers = strAccUsers.Split(','); if (arrAccUsers.Length > 0) { for (int i = 0; i < arrAccUsers.Length; i++) { if (arrAccUsers[i].Length > 0) { SMS.SmsVo sv = new SMS.SmsVo(); DataRow[] drAcceptS = dtUser.Select("id='" + arrAccUsers[i] + "'"); string strAcceptUser = ""; string strPhoneNumber = ""; if (drAcceptS.Length > 0) { strAcceptUser = drAcceptS[0]["REAL_NAME"].ToString(); strPhoneNumber = drAcceptS[0]["PHONE_MOBILE"].ToString(); } if (!isAtOnce)//定时发送 { sv.sendtime = strSEND_DATE; } sv.content = strMESSAGE_CONTENT; sv.receiver = strPhoneNumber; if (strPhoneNumber.Length > 0) { if (new SMS.SmsManager().IsDbConnect()) { new SMS.SmsManager().SendSmsMessage(sv); } } } } } }
public static string getProxyOfUser(string strUserID) { TSysUserProxyVo objProxyWhere = new TSysUserProxyVo(); objProxyWhere.USER_ID = strUserID; TSysUserProxyVo objProxy = new TSysUserProxyLogic().Details(objProxyWhere); TSysUserVo objUser = new TSysUserLogic().Details(objProxy.PROXY_USER_ID); return(objProxy.PROXY_USER_ID + "|" + objUser.REAL_NAME); }
/// <summary> /// 设置用户密码 /// </summary> protected void SetPassword() { string strUserID = LogInfo.UserInfo.ID; if (Request["strUserID"] != null) { strUserID = Request["strUserID"].ToString(); } if (USER_PWD_ORG.Text == "" && LogInfo.UserInfo.ID != "000000001") { Alert("请输入原密码"); lbMsg.Text = "请输入原密码"; return; } //修改 潘德军,2013-8-5,修改原逻辑错误 if (LogInfo.UserInfo.ID != "000000001") { TSysUserVo objUserVo_Temp = new TSysUserVo(); objUserVo_Temp.USER_NAME = USER_NAME.Text; objUserVo_Temp.USER_PWD = ToMD5(USER_PWD_ORG.Text); TSysUserLogic objUserLogic_Temp = new TSysUserLogic(); DataTable dtUserTemp = objUserLogic_Temp.SelectByTable(objUserVo_Temp); if (dtUserTemp.Rows.Count <= 0 && LogInfo.UserInfo.ID != "000000001") { Alert("请输入正确的原密码"); lbMsg.Text = "请输入正确的原密码"; return; } } if (USER_PWD.Text != USER_PWD_CONFIRM.Text) { Alert("两次输入的新密码不一致,请重新输入"); lbMsg.Text = "两次输入的新密码不一致,请重新输入"; return; } //修改密码 TSysUserVo objUserVo = new TSysUserVo(); //objUserVo = (TSysUserVo)BindControlsToObjectMode(objUserVo); TSysUserLogic logicUser = new TSysUserLogic(objUserVo); objUserVo.USER_PWD = ToMD5(USER_PWD.Text);//密码要加密 objUserVo.ID = strUserID; if (logicUser.Edit(objUserVo)) { Alert("修改成功"); lbMsg.Text = "修改成功"; base.WriteLog(i3.ValueObject.ObjectBase.LogType.EditPassWord, objUserVo.ID, LogInfo.UserInfo.USER_NAME + "修改用户: " + objUserVo.USER_NAME + " 的密码成功!"); } else { Alert("修改失败"); lbMsg.Text = "修改失败"; } }
//获取点位信息 private string getUserList() { string strSortname = Request.Params["sortname"]; string strSortorder = Request.Params["sortorder"]; //当前页面 int intPageIndex = Convert.ToInt32(Request.Params["page"]); //每页记录数 int intPageSize = Convert.ToInt32(Request.Params["pagesize"]); if (strSortname == null || strSortname.Length < 0) { strSortname = TSysUserVo.ORDER_ID_FIELD; } string strDeptID = ""; string Real_Name = ""; if (Request["strSrhDept_ID"] != null) { strDeptID = Request.Params["strSrhDept_ID"]; } if (Request["Real_Name"] != null) { Real_Name = Request.Params["Real_Name"]; } TSysUserVo objVo = new TSysUserVo(); objVo.IS_DEL = "0"; //objVo.IS_USE = "1"; objVo.IS_HIDE = "0"; objVo.REMARK4 = strDeptID; objVo.SORT_FIELD = strSortname; objVo.SORT_TYPE = strSortorder; objVo.REAL_NAME = Real_Name; int intTotalCount = new TSysUserLogic().GetSelectResultCount_ByDept(objVo); DataTable dt = new TSysUserLogic().SelectByTable_ByDept(objVo, intPageIndex, intPageSize); foreach (DataRow dr in dt.Rows) { if (dr["IS_USE"].ToString() == "0") { dr["IS_USE"] = "是"; } else { dr["IS_USE"] = ""; } } dt.AcceptChanges(); string strJson = CreateToJson(dt, intTotalCount); return(strJson); }
//页面初始化 private void InitPage() { TOaFwInfoVo objFW = new TOaFwInfoLogic().Details(this.hidTaskId.Value); this.YWNO.Text = objFW.YWNO; this.FWNO.Text = objFW.FWNO; this.FW_TITLE.Text = objFW.FW_TITLE; this.ZB_DEPT.Text = objFW.ZB_DEPT; this.DRAFT_ID.Text = new TSysUserLogic().Details(objFW.DRAFT_ID).REAL_NAME; this.MJ.Text = getDictName(objFW.MJ, "FW_MJ"); this.FW_DATE.Text = DateTime.Parse(objFW.FW_DATE).ToShortDateString(); this.START_DATE.Text = DateTime.Parse(objFW.START_DATE).ToShortDateString(); this.END_DATE.Text = DateTime.Parse(objFW.END_DATE).ToShortDateString(); if (this.hidTask_Tatus.Value == "1") { this.TReadUserList.Attributes.Add("style", "display:none"); } else if (this.hidTask_Tatus.Value == "2") { this.ISSUE_INFO.Value = objFW.ISSUE_INFO; this.ISSUE_ID.Text = new TSysUserLogic().Details(objFW.ISSUE_ID).REAL_NAME; this.ISSUE_DATE.Text = DateTime.Parse(objFW.ISSUE_DATE).ToShortDateString(); List <TOaSwReadVo> list = new TOaSwReadLogic().SelectByReadUser(objFW.ID); string strName = ""; string strId = ""; for (int i = 0; i < list.Count; i++) { string swid = list[i].SW_PLAN_ID; string swname = new TSysUserLogic().Details(swid).REAL_NAME; if (i == 0) { strName = swname; strId = swid; } else if (i > 0) { strName = strName + "," + swname; strId = strId + "," + swid; } } this.ReadUserNames.Value = strName; this.Hid_ReadUserIDs.Value = strId; this.ISSUE_INFO.Disabled = true; } else if (this.hidTask_Tatus.Value == "9") { this.TReadUserList.Attributes.Add("style", "display:none"); } }
/// <summary> /// 根据选中部门,获取用户数据 /// </summary> /// <param name="strDeptID">部门id</param> /// <returns>用户id串</returns> private string Get_Users(string strDeptID) { string strResult = ""; DataTable dt = new TSysUserLogic().SelectByTableUnderDept(strDeptID, 0, 0); for (int i = 0; i < dt.Rows.Count; i++) { DataRow dr = dt.Rows[i]; strResult += (strResult.Length > 0 ? "|" : "") + dr[TSysUserVo.ID_FIELD].ToString() + "," + dr[TSysUserVo.REAL_NAME_FIELD].ToString(); } return(strResult); }
public void InitUserList() { lsbAll.Items.Clear(); DataTable dt = new TSysUserLogic().SelectByTable(new TSysUserVo() { IS_DEL = "0" }); lsbAll.DataSource = dt.DefaultView; lsbAll.DataTextField = TSysUserVo.REAL_NAME_FIELD; lsbAll.DataValueField = TSysUserVo.ID_FIELD; lsbAll.DataBind(); }
public static string deleteData(string strValue) { TSysUserVo objVo = new TSysUserVo(); objVo.ID = strValue; objVo.IS_DEL = "1"; bool isSuccess = new TSysUserLogic().Edit(objVo); if (isSuccess) { new PageBase().WriteLog("删除用户", "", new UserLogInfo().UserInfo.USER_NAME + "删除用户" + strValue); } return(isSuccess == true ? "1" : "0"); }
private void HandlerDataBind() { TSysUserVo objUser = new TSysUserVo(); objUser.IS_USE = "1"; objUser.IS_DEL = "0"; objUser.IS_HIDE = "0"; DataTable dt = new DataTable(); dt = new TSysUserLogic().SelectByTable(objUser); HandlerList.DataSource = dt; HandlerList.DataTextField = "REAL_NAME"; HandlerList.DataValueField = "ID"; HandlerList.DataBind(); }
//获取报告办理人数据 private string GetReportUsers() { TWfSettingTaskVo task = new TWfSettingTaskLogic().Details(new TWfSettingTaskVo() { WF_TASK_ID = "D2355FBCD1B545A", WF_ID = "RPT" }); DataTable dt = new DataTable(); TSysUserVo SysUserVo = new TSysUserVo(); SysUserVo.ID = task.OPER_VALUE.TrimEnd('|').Replace("|", ","); SysUserVo.IS_DEL = "0"; SysUserVo.IS_USE = "1"; dt = new TSysUserLogic().SelectByTableEx(SysUserVo, 0, 0); return(DataTableToJson(dt)); }
//获取数据 private void GetData(string strID) { TSysUserVo objVo = new TSysUserLogic().Details(strID); objVo.USER_PWD = ""; string strPostNames = ""; string strPostIDs = ""; GetPostStr(strID, ref strPostNames, ref strPostIDs); objVo.REMARK1 = strPostNames; objVo.REMARK2 = strPostIDs; string strJson = ToJson(objVo); Response.Write(strJson); Response.End(); }
//获取用户 private void GetUsers() { string strSortname = Request.Params["sortname"]; string strSortorder = Request.Params["sortorder"]; int intPageIdx = Convert.ToInt32(Request.Params["page"]); int intPagesize = Convert.ToInt32(Request.Params["pagesize"]); string strSrhDept = (Request.Params["strSrhDept"] != null) ? Request.Params["strSrhDept"] : ""; TSysUserLogic logicUser = new TSysUserLogic(); int intTotalCount = logicUser.GetSelectByTableUnderDept(strSrhDept);;//总计的数据条数 DataTable dt = logicUser.SelectByTableUnderDept(strSrhDept, intPageIdx, intPagesize); string strJson = CreateToJson(dt, intTotalCount); Response.Write(strJson); Response.End(); }
//获取用户 private void GetUsers() { string strSortname = "ORDER_ID"; string strSortorder = Request.Params["sortorder"]; TSysUserVo objVo = new TSysUserVo(); objVo.IS_DEL = "0"; objVo.IS_USE = "1"; objVo.IS_HIDE = "0"; objVo.SORT_FIELD = strSortname; objVo.SORT_TYPE = strSortorder; DataTable dt = new TSysUserLogic().SelectByTable_ByDept(objVo, 0, 0); int intTotalCount = new TSysUserLogic().GetSelectResultCount_ByDept(objVo); string strJson = CreateToJson(dt, intTotalCount); Response.Write(strJson); Response.End(); }
private string GetCheckUser(string strSubTaskID) { TMisMonitorSubtaskVo objSubtaskVo = new TMisMonitorSubtaskLogic().Details(strSubTaskID); string strUserIDs = ""; DataTable dt = new DataTable(); DataTable strSampleCheckSender = GetDefaultOrFirstDutyUser("sample_result_check", objSubtaskVo.MONITOR_ID); for (int i = 0; i < strSampleCheckSender.Rows.Count; i++) { strUserIDs += strSampleCheckSender.Rows[i]["USERID"].ToString() + ","; } TSysUserVo SysUserVo = new TSysUserVo(); SysUserVo.ID = strUserIDs.TrimEnd(','); SysUserVo.IS_DEL = "0"; SysUserVo.IS_USE = "1"; dt = new TSysUserLogic().SelectByTableEx(SysUserVo, 0, 0); return(DataTableToJson(dt)); }
public static List <object> GetSubUserItems(string strPost_Dept, string strItemID, string strDutyType) { DataTable dt = new TSysUserLogic().SelectByTableUnderDept(strPost_Dept, 0, 0); TSysDutyVo objItems = new TSysDutyVo(); objItems.MONITOR_ITEM_ID = strItemID; objItems.DICT_CODE = strDutyType; DataTable dtDuty = new TSysDutyLogic().SelectByUnionTableForWhere(objItems, 0, 0); DataTable dtItems = new DataTable(); dtItems = dt.Copy(); dtItems.Clear(); if (dtDuty.Rows.Count > 0) { for (int i = 0; i < dtDuty.Rows.Count; i++) { if (!String.IsNullOrEmpty(dtDuty.Rows[i]["ID"].ToString())) { DataRow[] dr = dt.Select("ID='" + dtDuty.Rows[i]["ID"].ToString() + "'"); if (dr != null) { foreach (DataRow Temrow in dr) { Temrow.Delete(); dt.AcceptChanges(); } } } } } dtItems = dt.Copy(); List <object> listResult = LigerGridSelectDataToJson(dtItems, dtItems.Rows.Count); return(listResult); }
private DataTable doWithSubtaskData(DataTable dt) { DataTable dtRe = new DataTable(); string strMonitorIDs = ""; if (dt.Rows.Count > 0) { for (int j = 0; j < dt.Columns.Count; j++) { dtRe.Columns.Add(dt.Columns[j].ColumnName); } } for (int i = 0; i < dt.Rows.Count; i++) { if (!strMonitorIDs.Contains(dt.Rows[i]["MONITOR_ID"].ToString())) { strMonitorIDs += "," + dt.Rows[i]["MONITOR_ID"].ToString(); DataRow dr = dtRe.NewRow(); for (int j = 0; j < dt.Columns.Count; j++) { dr[dt.Columns[j].ColumnName] = dt.Rows[i][dt.Columns[j].ColumnName].ToString(); } dtRe.Rows.Add(dr); } } for (int i = 0; i < dtRe.Rows.Count; i++) { if (dtRe.Rows[i]["SAMPLING_MANAGER_ID"].ToString().Length > 0) { string strUsername = new TSysUserLogic().Details(dtRe.Rows[i]["SAMPLING_MANAGER_ID"].ToString()).REAL_NAME; if (!dtRe.Rows[i]["SAMPLING_MAN"].ToString().Contains(strUsername)) { dtRe.Rows[i]["SAMPLING_MAN"] = strUsername + (dtRe.Rows[i]["SAMPLING_MAN"].ToString().Length > 0 ? "," : "") + dtRe.Rows[i]["SAMPLING_MAN"].ToString(); } } } dtRe.AcceptChanges(); return(dtRe); }
/// <summary> /// 保存用户信息 /// </summary> protected void SaveUserInfo() { TSysUserVo objUserVo = new TSysUserVo(); objUserVo = (TSysUserVo)BindControlsToObjectMode(objUserVo); objUserVo.ID = LogInfo.UserInfo.ID; TSysUserLogic logicUser = new TSysUserLogic(objUserVo); if (logicUser.Edit(objUserVo)) { //使用LigerUIDialog之前,确保页面上LigerDialog.js/ligerui-all.css/all.css已被引用 // LigerDialogConfirm("确定要进行删除吗?","alert(result);"); LigerDialogAlert("修改成功!", DialogMold.success.ToString()); base.WriteLog(i3.ValueObject.ObjectBase.LogType.EditUser, objUserVo.ID, LogInfo.UserInfo.USER_NAME + "修改用户: " + objUserVo.USER_NAME + " 的资料成功!"); } else { LigerDialogAlert("修改失败!", DialogMold.warn.ToString()); } }
/// <summary> /// 获取人员姓名 /// </summary> /// <param name="strUserID">用户ID</param> /// <returns></returns> private string GetSampleManager(string strUserID) { TSysUserVo objUser = new TSysUserLogic().Details(strUserID); return(objUser.REAL_NAME); }
//保存数据 private static string SaveData(string strID, string strMessageTitle, string strSendBy, string strSendDate, string strAcceptType, string strAcceptRealNames, string strAcceptUserIDs, string strAcceptDeptNames, string strAcceptDeptIDs, string strMessageContent, string strUserID) { string strSendByName = strSendBy; TSysUserVo objUserFrom = new TSysUserVo(); objUserFrom.ID = strSendBy; DataTable dtUserSender = new TSysUserLogic().SelectByTable_ByDept(objUserFrom, 0, 0); if (dtUserSender.Rows.Count > 0) { strSendByName = dtUserSender.Rows[0]["REAL_NAME"].ToString(); } bool isSuccess = true; strAcceptRealNames = strAcceptRealNames.Trim(); strAcceptUserIDs = strAcceptUserIDs.Trim(); strAcceptDeptNames = strAcceptDeptNames.Trim(); strAcceptDeptIDs = strAcceptDeptIDs.Trim(); #region 消息查看--编辑消息阅读状态 if (strID.Length > 0) { TOaMessageInfoReceiveVo objReceive = new TOaMessageInfoReceiveVo(); objReceive.IS_READ = "0"; objReceive.MESSAGE_ID = strID; objReceive.RECEIVER = strUserID; objReceive = new TOaMessageInfoReceiveLogic().Details(objReceive); if (objReceive.ID.Length > 0) { objReceive.IS_READ = "1"; if (new TOaMessageInfoReceiveLogic().Edit(objReceive)) { new PageBase().WriteLog("编辑消息阅读状态", "", new UserLogInfo().UserInfo.USER_NAME + "编辑消息阅读状态" + objReceive.ID); } return("1"); } } #endregion DataTable dtDept = new TSysDictLogic().SelectByTable(new TSysDictVo() { DICT_TYPE = "dept" }); strAcceptDeptNames = strAcceptDeptNames.Replace(";", ","); string[] arrAccDeptName = strAcceptDeptNames.Split(','); for (int i = 0; i < arrAccDeptName.Length; i++) { if (arrAccDeptName[i].Length > 0) { DataRow[] drDept = dtDept.Select("DICT_TEXT='" + arrAccDeptName[i] + "'"); if (drDept.Length > 0) { strAcceptDeptIDs += (strAcceptDeptIDs.Length > 0 ? "," : "") + drDept[0]["DICT_CODE"]; } } } #region 清空对应的几个接收信息表,冗余操作,但可以防止错误 if (strID.Length > 0) { //消息接收人表 TOaMessageInfoManVo objMessageMan = new TOaMessageInfoManVo(); objMessageMan.MESSAGE_ID = strID; if (new TOaMessageInfoManLogic().Delete(objMessageMan)) { new PageBase().WriteLog("删除消息接收人", "", new UserLogInfo().UserInfo.USER_NAME + "删除消息接收人" + objMessageMan.ID); } //消息阅读状态表 TOaMessageInfoReceiveVo objMessageReceive = new TOaMessageInfoReceiveVo(); objMessageReceive.MESSAGE_ID = strID; if (new TOaMessageInfoReceiveLogic().Delete(objMessageReceive)) { new PageBase().WriteLog("删除消息阅读状态", "", new UserLogInfo().UserInfo.USER_NAME + "删除消息阅读状态" + objMessageReceive.ID); } //消息接收部门表 TOaMessageInfoDeptVo objMessageDept = new TOaMessageInfoDeptVo(); objMessageDept.MESSAGE_ID = strID; if (new TOaMessageInfoDeptLogic().Delete(objMessageDept)) { new PageBase().WriteLog("删除消息接收部门", "", new UserLogInfo().UserInfo.USER_NAME + "删除消息接收部门" + objMessageDept.ID); } } #endregion string strSQL = ""; #region 新增消息 if (strID.Length > 0) { strSQL = "update T_OA_MESSAGE_INFO set MESSAGE_TITLE='{0}',SEND_BY='{1}',SEND_DATE='{2}',ACCEPT_TYPE='{3}',"; strSQL += "ACCEPT_REALNAMES='{4}',ACCEPT_USERIDS='{5}',ACCEPT_DEPTNAMES='{6}',ACCEPT_DEPTIDS='{7}',"; strSQL += "MESSAGE_CONTENT='{8}'"; strSQL += " where ID='{9}'"; strSQL = string.Format(strSQL, strMessageTitle, strSendBy, strSendDate, (strAcceptType == "全站") ? "1" : "2", strAcceptRealNames.TrimEnd(','), strAcceptUserIDs.TrimEnd(','), strAcceptDeptNames, strAcceptDeptIDs, strMessageContent, strID); } else { strID = GetSerialNumber("t_oa_messageinfo_id"); strSQL = "insert into T_OA_MESSAGE_INFO (ID,MESSAGE_TITLE,SEND_BY,SEND_DATE,ACCEPT_TYPE,ACCEPT_REALNAMES,ACCEPT_USERIDS,ACCEPT_DEPTNAMES,ACCEPT_DEPTIDS,MESSAGE_CONTENT)"; strSQL += " values('{0}','{1}','{2}','{3}','{4}','{5}','{6}','{7}','{8}','{9}')"; strSQL = string.Format(strSQL, strID, strMessageTitle, strSendBy, strSendDate, (strAcceptType == "全站") ? "1" : "2", strAcceptRealNames.TrimEnd(','), strAcceptUserIDs.TrimEnd(','), strAcceptDeptNames, strAcceptDeptIDs, strMessageContent); } #endregion string strAccUserIDs = ""; if (strAcceptType == "全站")//全站 { TSysUserVo objUser = new TSysUserVo(); objUser.IS_DEL = "0"; objUser.IS_HIDE = "0"; objUser.IS_USE = "1"; DataTable dtUser = new TSysUserLogic().SelectByTable(objUser); for (int j = 0; j < dtUser.Rows.Count; j++) { // by yinchengyi 2014-10-23 T_OA_MESSAGE_INFO_MAN 没用 //strSQL += "\r\n"; //strSQL += "insert into T_OA_MESSAGE_INFO_MAN (ID,MESSAGE_ID,RECEIVER_ID)"; //strSQL += " values('{0}','{1}','{2}')"; //strSQL = string.Format(strSQL, GetSerialNumber("t_oa_messageinfoman_id"), strID, dtUser.Rows[j]["ID"].ToString()); string strErrMsg = cInstanceMsgHandle.SendMsg(strSendByName, dtUser.Rows[j]["REAL_NAME"].ToString(), dtUser.Rows[j]["PHONE_MOBILE"].ToString().Trim(), strMessageContent); strSQL += "\r\n"; strSQL += "insert into T_OA_MESSAGE_INFO_RECEIVE (ID,MESSAGE_ID,RECEIVER,IS_READ,REMARK3)"; strSQL += " values('{0}','{1}','{2}','{3}','{4}')"; strSQL = string.Format(strSQL, GetSerialNumber("t_oa_messageinfodel_id"), strID, dtUser.Rows[j]["ID"].ToString(), "0", strErrMsg); strAccUserIDs += (strAccUserIDs.Length > 0 ? "," : "") + dtUser.Rows[j]["ID"].ToString(); } } else//按部门,按个人分配消息 { // by yinchengyi 2014-10-23 T_OA_MESSAGE_INFO_MAN 没用 //for (int i = 0; i < strAcceptUserIDs.Split(',').Length; i++) //{ // if (strAcceptUserIDs.Split(',')[i].Length > 0) // { // strSQL += "\r\n"; // strSQL += "insert into T_OA_MESSAGE_INFO_MAN (ID,MESSAGE_ID,RECEIVER_ID)"; // strSQL += " values('{0}','{1}','{2}')"; // strSQL = string.Format(strSQL, GetSerialNumber("t_oa_messageinfoman_id"), strID, strAcceptUserIDs.Split(',')[i]); // } //} // by yinchengyi 2014-10-23 T_OA_MESSAGE_INFO_DEPT 没用 //for (int i = 0; i < strAcceptDeptIDs.Split(',').Length; i++) //{ // if (strAcceptDeptIDs.Split(',')[i].Length > 0) // { // strSQL += "\r\n"; // strSQL += "insert into T_OA_MESSAGE_INFO_DEPT (ID,MESSAGE_ID,DEPT_ID)"; // strSQL += " values('{0}','{1}','{2}')"; // strSQL = string.Format(strSQL, GetSerialNumber("t_oa_messageinfodept_id"), strID, strAcceptDeptIDs.Split(',')[i]); // } //} //部门人员添加 if (strAcceptDeptIDs.Length > 0) { TSysUserVo objUser = new TSysUserVo(); objUser.IS_DEL = "0"; objUser.REMARK4 = strAcceptDeptIDs.Replace(",", "','"); DataTable dtUserByDept = new TSysUserLogic().SelectByTable_ByDept(objUser, 0, 0); for (int j = 0; j < dtUserByDept.Rows.Count; j++) { if (!strAcceptUserIDs.Contains(dtUserByDept.Rows[j]["ID"].ToString())) { strAcceptUserIDs += (strAcceptUserIDs.Length > 0 ? "," : "") + dtUserByDept.Rows[j]["ID"].ToString(); } } } for (int i = 0; i < strAcceptUserIDs.Split(',').Length; i++) { if (strAcceptUserIDs.Split(',')[i].Length > 0) { TSysUserVo objUser = new TSysUserVo(); objUser.ID = strAcceptUserIDs.Split(',')[i]; DataTable dtUserByDept = new TSysUserLogic().SelectByTable_ByDept(objUser, 0, 0); string strErrMsg = "unknown user"; if (dtUserByDept.Rows.Count > 0) { strErrMsg = cInstanceMsgHandle.SendMsg(strSendByName, dtUserByDept.Rows[0]["REAL_NAME"].ToString(), dtUserByDept.Rows[0]["PHONE_MOBILE"].ToString().Trim(), strMessageContent); } strSQL += "\r\n"; strSQL += "insert into T_OA_MESSAGE_INFO_RECEIVE (ID,MESSAGE_ID,RECEIVER,IS_READ,REMARK3)"; strSQL += " values('{0}','{1}','{2}','{3}','{4}')"; strSQL = string.Format(strSQL, GetSerialNumber("t_oa_messageinfodel_id"), strID, strAcceptUserIDs.Split(',')[i], "0", strErrMsg); } } strAccUserIDs += (strAccUserIDs.Length > 0 ? "," : "") + strAcceptUserIDs; } //if (strAccUserIDs.Length > 0) //{ // string strErrMsg = ""; // //new SendMobileMsg().AutoSenMobilMsg(strMessageContent, strSendBy, strAccUserIDs, true, "", ref strErrMsg); //} #region 消息体 isSuccess = SqlHelper.ExecuteNonQuery(CommandType.Text, strSQL) > 0 ? true : false; if (isSuccess) { if (strID.Length > 0) { new PageBase().WriteLog("编辑短消息信息", "", new UserLogInfo().UserInfo.USER_NAME + "编辑短消息信息" + strID); } else { new PageBase().WriteLog("添加短消息信息", "", new UserLogInfo().UserInfo.USER_NAME + "添加短消息信息" + strID); } } #endregion if (isSuccess) { return("1"); } else { return("0"); } }
public static List <object> GetUserList(string strDept) { DataTable dt = new TSysUserLogic().SelectByTableUnderDept(strDept, 0, 0); return(LigerGridSelectDataToJson(dt, dt.Rows.Count)); }
public static string SaveData(string strID, string strUSER_NAME, string strREAL_NAME, string strORDER_ID, string strBIRTHDAY, string strSEX, string strPHONE_OFFICE, string strPHONE_MOBILE, string strPHONE_HOME, string strEMAIL, string strADDRESS, string strPOSTCODE, string strIS_USE, string strIOS_MAC, string strIF_IOS, string strANDROID_MAC, string strIF_ANDROID, string strREMARK1, string strUSER_PWD) { bool isSuccess = true; TSysUserVo objVo = new TSysUserVo(); objVo.ID = strID.Length > 0 ? strID : GetSerialNumber("user_info_id"); objVo.IS_DEL = "0"; objVo.IS_HIDE = "0"; objVo.USER_NAME = strUSER_NAME; objVo.REAL_NAME = strREAL_NAME; objVo.ORDER_ID = strORDER_ID; objVo.BIRTHDAY = strBIRTHDAY; objVo.SEX = strSEX; objVo.PHONE_OFFICE = strPHONE_OFFICE; objVo.PHONE_MOBILE = strPHONE_MOBILE; objVo.PHONE_HOME = strPHONE_HOME; objVo.EMAIL = strEMAIL; objVo.ADDRESS = strADDRESS; objVo.POSTCODE = strPOSTCODE; objVo.IS_USE = strIS_USE.Length > 0 ? strIS_USE : "1"; objVo.USER_PWD = strUSER_PWD; objVo.IOS_MAC = strIOS_MAC; objVo.IF_IOS = strIF_IOS.Length > 0 ? strIF_IOS : "0"; objVo.ANDROID_MAC = strANDROID_MAC; objVo.IF_ANDROID = strIF_ANDROID.Length > 0 ? strIF_ANDROID : "0"; i3.View.PageBase objP = new i3.View.PageBase(); if (string.IsNullOrEmpty(objVo.USER_PWD)) { objVo.USER_PWD = objP.ToMD5("1"); } else { objVo.USER_PWD = objP.ToMD5(objVo.USER_PWD); } objVo.CREATE_ID = objP.LogInfo.UserInfo.ID; objVo.CREATE_TIME = System.DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"); if (strID.Length > 0) { isSuccess = new TSysUserLogic().Edit(objVo); if (isSuccess) { new PageBase().WriteLog("编辑用户", "", new UserLogInfo().UserInfo.USER_NAME + "编辑用户" + objVo.ID); } } else { isSuccess = new TSysUserLogic().Create(objVo); if (isSuccess) { new PageBase().WriteLog("添加用户", "", new UserLogInfo().UserInfo.USER_NAME + "添加用户" + objVo.ID); } } TSysUserPostLogic logicUp = new TSysUserPostLogic(); if (strID.Length > 0) { TSysUserPostVo objUserPostDel = new TSysUserPostVo(); objUserPostDel.USER_ID = strID; logicUp.Delete(objUserPostDel); } string strPostId = strREMARK1.Split('|')[0]; string[] arrPostId = strPostId.Split(','); for (int i = 0; i < arrPostId.Length; i++) { TSysUserPostVo objUserPost = new TSysUserPostVo(); objUserPost.USER_ID = objVo.ID; objUserPost.POST_ID = arrPostId[i]; objUserPost.ID = GetSerialNumber("user_post_infor"); isSuccess = new TSysUserPostLogic().Create(objUserPost); if (isSuccess) { new PageBase().WriteLog("添加职位菜单", "", new UserLogInfo().UserInfo.USER_NAME + "添加职位菜单" + objUserPost.ID); } } if (isSuccess) { return("1"); } else { return("0"); } }