//页面初始化
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");
}
}
