/// <summary> /// 对象编辑 /// </summary> /// <param name="tOaSwHandle">用户对象</param> /// <returns>是否成功</returns> public bool Edit(TOaSwHandleVo tOaSwHandle) { string strSQL = SqlHelper.BuildUpdateExpress(tOaSwHandle, TOaSwHandleVo.T_OA_SW_HANDLE_TABLE); strSQL += string.Format(" where ID='{0}' ", tOaSwHandle.ID); return(SqlHelper.ExecuteNonQuery(CommandType.Text, strSQL) > 0 ? true : false); }
/// <summary> /// 对象编辑 /// </summary> /// <param name="tOaSwHandle_UpdateSet">UpdateSet用户对象</param> /// <param name="tOaSwHandle_UpdateWhere">UpdateWhere用户对象</param> /// <returns>是否成功</returns> public bool Edit(TOaSwHandleVo tOaSwHandle_UpdateSet, TOaSwHandleVo tOaSwHandle_UpdateWhere) { string strSQL = SqlHelper.BuildUpdateExpress(tOaSwHandle_UpdateSet, TOaSwHandleVo.T_OA_SW_HANDLE_TABLE); strSQL += this.BuildWhereStatement(tOaSwHandle_UpdateWhere); return(SqlHelper.ExecuteNonQuery(CommandType.Text, strSQL) > 0 ? true : false); }
/// <summary> /// 获取对象DataTable /// </summary> /// <param name="tOaSwHandle">对象</param> /// <param name="iIndex">起始页码</param> /// <param name="iCount">每页数目</param> /// <returns>返回结果</returns> public DataTable SelectByTable(TOaSwHandleVo tOaSwHandle, int iIndex, int iCount) { string strSQL = " select * from T_OA_SW_HANDLE {0} "; strSQL = String.Format(strSQL, BuildWhereStatement(tOaSwHandle)); return(SqlHelper.ExecuteDataTable(BuildPagerExpress(strSQL, iIndex, iCount))); }
/// <summary> /// 对象删除 /// </summary> /// <param name="Id">ID</param> /// <returns>是否成功</returns> public bool Delete(TOaSwHandleVo tOaSwHandle) { string strSQL = "delete from T_OA_SW_HANDLE "; strSQL += this.BuildWhereStatement(tOaSwHandle); return(SqlHelper.ExecuteNonQuery(CommandType.Text, strSQL) > 0 ? true : false); }
public static string GetSuggions(string strSWID, string strS) { TOaSwHandleVo TOaSwHandle = new TOaSwHandleVo(); TOaSwHandle.SW_ID = strSWID; TOaSwHandle.SW_HANDER = strS; TOaSwHandle.IS_OK = "1"; DataTable dt = new TOaSwHandleLogic().SelectByTable(TOaSwHandle, true); string json = ""; for (int i = 0; i < dt.Rows.Count; i++) { json += "意见:" + dt.Rows[i]["Suggion"].ToString() + "\n"; json += "办理人:" + dt.Rows[i]["UserName"].ToString() + "\t\t\t"; json += "办理时间:" + dt.Rows[i]["PlanDate"].ToString() + "\n\n"; } return(json); }
/// <summary> /// 根据对象特征获取单一对象 /// </summary> /// <param name="tOaSwHandle">对象</param> /// <returns></returns> public TOaSwHandleVo SelectByObject(TOaSwHandleVo tOaSwHandle) { return(access.SelectByObject(tOaSwHandle)); }
/// <summary> /// 根据对象获取全部数据,用Table承载 /// 数据量较小时使用【不推荐】 /// </summary> /// <param name="tOaSwHandle"></param> /// <returns></returns> public DataTable SelectByTable(TOaSwHandleVo tOaSwHandle) { string strSQL = "select * from T_OA_SW_HANDLE " + this.BuildWhereStatement(tOaSwHandle); return(SqlHelper.ExecuteDataTable(strSQL)); }
//页面初始化 private void InitPage() { if (this.hidTaskId.Value.Length == 0) { return; } TOaSwInfoVo objSW = new TOaSwInfoLogic().Details(this.hidTaskId.Value); this.FROM_CODE.Text = objSW.FROM_CODE; this.SW_CODE.Text = objSW.SW_CODE; this.SW_TITLE.Text = objSW.SW_TITLE; this.SW_FROM.Text = objSW.SW_FROM; this.SW_COUNT.Text = objSW.SW_COUNT; this.MJ.Text = getDictName(objSW.SW_MJ, "FW_MJ"); this.SW_SIGN_ID.Text = objSW.SW_SIGN_ID; this.SW_SIGN_DATE.Text = DateTime.Parse(objSW.SW_SIGN_DATE).ToShortDateString(); this.SW_REG_DATE.Text = DateTime.Parse(objSW.SW_REG_DATE).ToShortDateString(); if (this.hidTask_Tatus.Value == "1") { this.SW_PLAN_APP_INFO.Disabled = true; this.SW_APP_INFO.Disabled = true; } else if (this.hidTask_Tatus.Value == "2") { this.SW_PLAN_INFO.Value = objSW.SW_PLAN_INFO; this.SW_PLAN_ID.Text = new TSysUserLogic().Details(objSW.SW_PLAN_ID).REAL_NAME; this.SW_PLAN_DATE.Text = DateTime.Parse(objSW.SW_PLAN_DATE).ToShortDateString(); this.SW_PLAN_INFO.Disabled = true; this.SW_APP_INFO.Disabled = true; this.dAcceptUserLst.Visible = true; this.wfControl.Visible = false; this.Button1.Visible = true; } else if (this.hidTask_Tatus.Value == "3") { this.SW_PLAN_INFO.Value = objSW.SW_PLAN_INFO; this.SW_PLAN_ID.Text = new TSysUserLogic().Details(objSW.SW_PLAN_ID).REAL_NAME; this.SW_PLAN_DATE.Text = DateTime.Parse(objSW.SW_PLAN_DATE).ToShortDateString(); this.SW_PLAN_APP_INFO.Value = objSW.SW_PLAN_APP_INFO; this.SW_PLAN_APP_ID.Text = new TSysUserLogic().Details(objSW.SW_PLAN_APP_ID).REAL_NAME; this.SW_PLAN_APP_DATE.Text = DateTime.Parse(objSW.SW_PLAN_APP_DATE).ToShortDateString(); this.SW_PLAN_INFO.Disabled = true; this.SW_PLAN_APP_INFO.Disabled = true; } else if (this.hidTask_Tatus.Value == "9") { this.SW_PLAN_INFO.Value = objSW.SW_PLAN_INFO; this.SW_PLAN_ID.Text = new TSysUserLogic().Details(objSW.SW_PLAN_ID).REAL_NAME; this.SW_PLAN_DATE.Text = DateTime.Parse(objSW.SW_PLAN_DATE).ToShortDateString(); this.SW_PLAN_APP_INFO.Value = objSW.SW_PLAN_APP_INFO; this.SW_PLAN_APP_ID.Text = new TSysUserLogic().Details(objSW.SW_PLAN_APP_ID).REAL_NAME; this.SW_PLAN_APP_DATE.Text = DateTime.Parse(objSW.SW_PLAN_APP_DATE).ToShortDateString(); //this.SW_APP_INFO.Value = objSW.SW_APP_INFO; //this.SW_APP_ID.Text = new TSysUserLogic().Details(objSW.SW_APP_ID).REAL_NAME; //this.SW_APP_DATE.Text = DateTime.Parse(objSW.SW_APP_DATE).ToShortDateString(); this.SW_PLAN_INFO.Disabled = true; this.SW_PLAN_APP_INFO.Disabled = true; this.SW_APP_INFO.Disabled = true; string strSwAppInfo = ""; TOaSwHandleVo objSwHandle = new TOaSwHandleVo(); objSwHandle.SW_ID = this.hidTaskId.Value; DataTable dt = new TOaSwHandleLogic().SelectByTable(objSwHandle); for (int i = 0; i < dt.Rows.Count; i++) { string strUserName = new TSysUserLogic().Details(dt.Rows[i]["SW_PLAN_ID"].ToString()).REAL_NAME; strSwAppInfo += strUserName + ":" + dt.Rows[i]["SW_PLAN_APP_INFO"].ToString() + "\r\n"; } this.SW_APP_INFO.Value = strSwAppInfo; } }
/// <summary> /// 获取对象DataTable /// </summary> /// <param name="tOaSwHandle">对象</param> /// <param name="iIndex">起始页码</param> /// <param name="iCount">每页数目</param> /// <returns>返回结果</returns> public DataTable SelectByTable(TOaSwHandleVo tOaSwHandle, int iIndex, int iCount) { return(access.SelectByTable(tOaSwHandle, iIndex, iCount)); }
/// <summary> /// 对象明细 /// </summary> /// <param name="tOaSwHandle">对象条件</param> /// <returns>对象</returns> public TOaSwHandleVo Details(TOaSwHandleVo tOaSwHandle) { return(access.Details(tOaSwHandle)); }
public TOaSwHandleLogic(TOaSwHandleVo _tOaSwHandle) { tOaSwHandle = _tOaSwHandle; access = new TOaSwHandleAccess(); }
/// <summary> /// 对象编辑 /// </summary> /// <param name="tOaSwHandle_UpdateSet">UpdateSet用户对象</param> /// <param name="tOaSwHandle_UpdateWhere">UpdateWhere用户对象</param> /// <returns>是否成功</returns> public bool Edit(TOaSwHandleVo tOaSwHandle_UpdateSet, TOaSwHandleVo tOaSwHandle_UpdateWhere) { return(access.Edit(tOaSwHandle_UpdateSet, tOaSwHandle_UpdateWhere)); }
/// <summary> /// 根据对象构造条件语句 /// </summary> /// <param name="tOaSwHandle"></param> /// <returns></returns> public string BuildWhereStatement(TOaSwHandleVo tOaSwHandle) { StringBuilder strWhereStatement = new StringBuilder(" Where 1=1 "); if (null != tOaSwHandle) { //ID if (!String.IsNullOrEmpty(tOaSwHandle.ID.ToString().Trim())) { strWhereStatement.Append(string.Format(" AND ID = '{0}'", tOaSwHandle.ID.ToString())); } //收文ID if (!String.IsNullOrEmpty(tOaSwHandle.SW_ID.ToString().Trim())) { strWhereStatement.Append(string.Format(" AND SW_ID = '{0}'", tOaSwHandle.SW_ID.ToString())); } //拟办人ID if (!String.IsNullOrEmpty(tOaSwHandle.SW_PLAN_ID.ToString().Trim())) { strWhereStatement.Append(string.Format(" AND SW_PLAN_ID = '{0}'", tOaSwHandle.SW_PLAN_ID.ToString())); } //拟办日期 if (!String.IsNullOrEmpty(tOaSwHandle.SW_PLAN_DATE.ToString().Trim())) { strWhereStatement.Append(string.Format(" AND SW_PLAN_DATE = '{0}'", tOaSwHandle.SW_PLAN_DATE.ToString())); } //批办意见 if (!String.IsNullOrEmpty(tOaSwHandle.SW_PLAN_APP_INFO.ToString().Trim())) { strWhereStatement.Append(string.Format(" AND SW_PLAN_APP_INFO = '{0}'", tOaSwHandle.SW_PLAN_APP_INFO.ToString())); } //是否已办 if (!String.IsNullOrEmpty(tOaSwHandle.IS_OK.ToString().Trim())) { strWhereStatement.Append(string.Format(" AND IS_OK = '{0}'", tOaSwHandle.IS_OK.ToString())); } //备注1 if (!String.IsNullOrEmpty(tOaSwHandle.REMARK1.ToString().Trim())) { strWhereStatement.Append(string.Format(" AND REMARK1 = '{0}'", tOaSwHandle.REMARK1.ToString())); } //备注2 if (!String.IsNullOrEmpty(tOaSwHandle.REMARK2.ToString().Trim())) { strWhereStatement.Append(string.Format(" AND REMARK2 = '{0}'", tOaSwHandle.REMARK2.ToString())); } //备注3 if (!String.IsNullOrEmpty(tOaSwHandle.REMARK3.ToString().Trim())) { strWhereStatement.Append(string.Format(" AND REMARK3 = '{0}'", tOaSwHandle.REMARK3.ToString())); } //备注4 if (!String.IsNullOrEmpty(tOaSwHandle.REMARK4.ToString().Trim())) { strWhereStatement.Append(string.Format(" AND REMARK4 = '{0}'", tOaSwHandle.REMARK4.ToString())); } //备注5 if (!String.IsNullOrEmpty(tOaSwHandle.REMARK5.ToString().Trim())) { strWhereStatement.Append(string.Format(" AND REMARK5 = '{0}'", tOaSwHandle.REMARK5.ToString())); } //处理人标志 if (!String.IsNullOrEmpty(tOaSwHandle.SW_HANDER.ToString().Trim())) { strWhereStatement.Append(string.Format(" AND SW_HANDER = '{0}'", tOaSwHandle.SW_HANDER.ToString())); } //发送人ID if (!String.IsNullOrEmpty(tOaSwHandle.STR_USERID.ToString().Trim())) { strWhereStatement.Append(string.Format(" AND STR_USERID = '{0}'", tOaSwHandle.STR_USERID.ToString())); } //发送时间 if (!String.IsNullOrEmpty(tOaSwHandle.STR_DATE.ToString().Trim())) { strWhereStatement.Append(string.Format(" AND STR_DATE = '{0}'", tOaSwHandle.STR_DATE.ToString())); } } return(strWhereStatement.ToString()); }
/// <summary> /// 对象添加 /// </summary> /// <param name="tOaSwHandle">对象</param> /// <returns>是否成功</returns> public bool Create(TOaSwHandleVo tOaSwHandle) { string strSQL = SqlHelper.BuildInsertExpress(tOaSwHandle, TOaSwHandleVo.T_OA_SW_HANDLE_TABLE); return(SqlHelper.ExecuteNonQuery(CommandType.Text, strSQL) > 0 ? true : false); }
/// <summary> /// 根据对象特征获取单一对象 /// </summary> /// <param name="tOaSwHandle">对象</param> /// <returns></returns> public TOaSwHandleVo SelectByObject(TOaSwHandleVo tOaSwHandle) { string strSQL = "select * from T_OA_SW_HANDLE " + this.BuildWhereStatement(tOaSwHandle); return(SqlHelper.ExecuteObject(new TOaSwHandleVo(), strSQL)); }
/// <summary> /// 对象添加 /// </summary> /// <param name="sysRole">对象</param> /// <returns>是否成功</returns> public bool Create(TOaSwHandleVo tOaSwHandle) { return(access.Create(tOaSwHandle)); }
/// <summary> /// 对象编辑 /// </summary> /// <param name="tOaSwHandle">用户对象</param> /// <returns>是否成功</returns> public bool Edit(TOaSwHandleVo tOaSwHandle) { return(access.Edit(tOaSwHandle)); }
/// <summary> /// 获得查询结果总行数,用于分页 /// </summary> /// <param name="tOaSwHandle">对象</param> /// <returns>返回行数</returns> public int GetSelectResultCount(TOaSwHandleVo tOaSwHandle) { string strSQL = "select Count(*) from T_OA_SW_HANDLE " + this.BuildWhereStatement(tOaSwHandle); return(Convert.ToInt32(SqlHelper.ExecuteScalar(strSQL))); }
/// <summary> /// 对象删除 /// </summary> /// <param name="Id">ID</param> /// <returns>是否成功</returns> public bool Delete(TOaSwHandleVo tOaSwHandle) { return(access.Delete(tOaSwHandle)); }
/// <summary> /// 根据对象获取全部数据,用Table承载 /// 数据量较小时使用【不推荐】 /// </summary> /// <param name="tOaSwHandle"></param> /// <returns></returns> public DataTable SelectByTable(TOaSwHandleVo tOaSwHandle, bool b) { string strSQL = "select b.REAL_NAME UserName,a.SW_PLAN_DATE PlanDate,a.SW_PLAN_APP_INFO Suggion from T_OA_SW_HANDLE a left join T_SYS_USER b on(a.SW_PLAN_ID=b.ID)" + this.BuildWhereStatement(tOaSwHandle); return(SqlHelper.ExecuteDataTable(strSQL)); }
/// <summary> /// 获得查询结果总行数,用于分页 /// </summary> /// <param name="tOaSwHandle">对象</param> /// <returns>返回行数</returns> public int GetSelectResultCount(TOaSwHandleVo tOaSwHandle) { return(access.GetSelectResultCount(tOaSwHandle)); }
/// <summary> /// 对象明细 /// </summary> /// <param name="tOaSwHandle">对象条件</param> /// <returns>对象</returns> public TOaSwHandleVo Details(TOaSwHandleVo tOaSwHandle) { string strSQL = String.Format("select * from T_OA_SW_HANDLE " + this.BuildWhereStatement(tOaSwHandle)); return(SqlHelper.ExecuteObject(new TOaSwHandleVo(), strSQL)); }
/// <summary> /// 获取对象List /// </summary> /// <param name="tOaSwHandle">对象</param> /// <param name="iIndex">起始页码</param> /// <param name="iCount">每页数目</param> /// <returns>返回结果</returns> public List <TOaSwHandleVo> SelectByObject(TOaSwHandleVo tOaSwHandle, int iIndex, int iCount) { return(access.SelectByObject(tOaSwHandle, iIndex, iCount)); }
/// <summary> /// 获取对象List /// </summary> /// <param name="tOaSwHandle">对象</param> /// <param name="iIndex">起始页码</param> /// <param name="iCount">每页数目</param> /// <returns>返回结果</returns> public List <TOaSwHandleVo> SelectByObject(TOaSwHandleVo tOaSwHandle, int iIndex, int iCount) { string strSQL = String.Format("select * from T_OA_SW_HANDLE " + this.BuildWhereStatement(tOaSwHandle)); return(SqlHelper.ExecuteObjectList(tOaSwHandle, BuildPagerExpress(strSQL, iIndex, iCount))); }
/// <summary> /// 根据对象获取全部数据,用Table承载 /// 数据量较小时使用【不推荐】 /// </summary> /// <param name="tOaSwHandle"></param> /// <returns></returns> public DataTable SelectByTable(TOaSwHandleVo tOaSwHandle) { return(access.SelectByTable(tOaSwHandle)); }
void IWFStepRules.CreatAndRegisterBusinessData() { if (this.hidTaskId.Value.Length > 0 && String.IsNullOrEmpty(strBtnType)) { //这里是产生和注册业务数据的地方 TOaSwInfoVo objSW = new TOaSwInfoLogic().Details(this.hidTaskId.Value); if (this.hidTask_Tatus.Value == "1") { objSW.SW_PLAN_INFO = this.SW_PLAN_INFO.Value; objSW.SW_PLAN_ID = LogInfo.UserInfo.ID; objSW.SW_PLAN_DATE = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"); objSW.SW_STATUS = "2"; wfControl.SaveInstStepServiceData("收文ID", "sw_id", objSW.ID, "2"); } else if (this.hidTask_Tatus.Value == "2") { objSW.SW_PLAN_APP_INFO = this.SW_PLAN_APP_INFO.Value; objSW.SW_PLAN_APP_ID = LogInfo.UserInfo.ID; objSW.SW_PLAN_APP_DATE = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"); objSW.SW_STATUS = "3"; wfControl.SaveInstStepServiceData("收文ID", "sw_id", objSW.ID, "3"); for (int i = 0; i < this.HID_USERIDS.Value.Split(',').Length; i++) { string strUserID = this.HID_USERIDS.Value.Split(',')[i]; TOaSwHandleVo objSwHandle = new TOaSwHandleVo(); objSwHandle.ID = GetSerialNumber("t_oa_SWHandleID"); objSwHandle.SW_ID = objSW.ID; objSwHandle.SW_PLAN_ID = strUserID; objSwHandle.IS_OK = "0"; new TOaSwHandleLogic().Create(objSwHandle); wfControl.MoreDealUserForAdd(strUserID); } } else if (this.hidTask_Tatus.Value == "3") { TOaSwHandleVo objSwHandle = new TOaSwHandleVo(); objSwHandle.SW_ID = objSW.ID; objSwHandle.SW_PLAN_ID = LogInfo.UserInfo.ID; objSwHandle = new TOaSwHandleLogic().Details(objSwHandle); objSwHandle.IS_OK = "1"; objSwHandle.SW_PLAN_APP_INFO = this.SW_APP_INFO.Value; objSwHandle.SW_PLAN_DATE = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"); objSwHandle.SW_PLAN_ID = LogInfo.UserInfo.ID; new TOaSwHandleLogic().Edit(objSwHandle); //查看是否全部完成,变更收文记录状态 objSwHandle = new TOaSwHandleVo(); objSwHandle.SW_ID = objSW.ID; objSwHandle.IS_OK = "0"; DataTable dt = new TOaSwHandleLogic().SelectByTable(objSwHandle); if (dt.Rows.Count == 0) { objSW.SW_STATUS = "9"; } wfControl.SaveInstStepServiceData("收文ID", "sw_id", objSW.ID, "9"); } else if (this.hidTask_Tatus.Value == "9") { wfControl.SaveInstStepServiceData("收文ID", "sw_id", objSW.ID, "9"); } new TOaSwInfoLogic().Edit(objSW); } else if (this.hidTaskId.Value.Length > 0 && strBtnType == "back") { //这里是产生和注册业务数据的地方 TOaSwInfoVo objSW = new TOaSwInfoLogic().Details(this.hidTaskId.Value); if (this.hidTask_Tatus.Value == "1") { objSW.SW_PLAN_ID = "###"; objSW.SW_PLAN_DATE = "###"; objSW.SW_STATUS = "0"; wfControl.SaveInstStepServiceData("收文ID", "sw_id", objSW.ID, "1"); } else if (this.hidTask_Tatus.Value == "2") { objSW.SW_PLAN_APP_ID = "###"; objSW.SW_PLAN_APP_DATE = "###"; objSW.SW_STATUS = "1"; wfControl.SaveInstStepServiceData("收文ID", "sw_id", objSW.ID, "1"); } else if (this.hidTask_Tatus.Value == "3") { objSW.SW_APP_ID = "###"; objSW.SW_APP_DATE = "###"; objSW.SW_STATUS = "2"; wfControl.SaveInstStepServiceData("收文ID", "sw_id", objSW.ID, "1"); } new TOaSwInfoLogic().Edit(objSW); } }