/// <summary> /// 根据对象获取全部数据,用Table承载 /// 数据量较小时使用【不推荐】 /// </summary> /// <param name="tOaFwInfo"></param> /// <returns></returns> public DataTable SelectByTable(TOaFwInfoVo tOaFwInfo) { string strSQL = "select * from T_OA_FW_INFO " + this.BuildWhereStatement(tOaFwInfo); return(SqlHelper.ExecuteDataTable(strSQL)); }
/// <summary> /// 获取对象DataTable,指定用户的传阅发文 /// </summary> /// <param name="tOaSwInfo">对象</param> /// <param name="iIndex">起始页码</param> /// <param name="iCount">每页数目</param> /// <returns>返回结果</returns> public DataTable SelectByTable_ForRead(TOaFwInfoVo tOaFwInfo, string strUserID, int iIndex, int iCount) { return(access.SelectByTable_ForRead(tOaFwInfo, strUserID, iIndex, iCount)); }
/// <summary> /// 获取对象DataTable /// </summary> /// <param name="tOaFwInfo">对象</param> /// <param name="iIndex">起始页码</param> /// <param name="iCount">每页数目</param> /// <returns>返回结果</returns> public DataTable SelectByTable(TOaFwInfoVo tOaFwInfo, int iIndex, int iCount) { return(access.SelectByTable(tOaFwInfo, iIndex, iCount)); }
/// <summary> /// 对象明细 /// </summary> /// <param name="tOaFwInfo">对象条件</param> /// <returns>对象</returns> public TOaFwInfoVo Details(TOaFwInfoVo tOaFwInfo) { return(access.Details(tOaFwInfo)); }
/// <summary> /// 获取对象List /// </summary> /// <param name="tOaFwInfo">对象</param> /// <param name="iIndex">起始页码</param> /// <param name="iCount">每页数目</param> /// <returns>返回结果</returns> public List <TOaFwInfoVo> SelectByObject(TOaFwInfoVo tOaFwInfo, int iIndex, int iCount) { return(access.SelectByObject(tOaFwInfo, iIndex, iCount)); }
void IWFStepRules.CreatAndRegisterBusinessData() { //这里是产生和注册业务数据的地方 TOaFwInfoVo objFW = new TOaFwInfoVo(); objFW.YWNO = this.YWNO.Text; objFW.FWNO = this.YWNO.Text; objFW.FW_TITLE = this.FW_TITLE.Text; objFW.ZB_DEPT = this.ZB_DEPT.Text; objFW.MJ = this.MJ.SelectedValue; objFW.ZS_DEPT = this.ZS_DEPT.Text; objFW.CB_DEPT = this.CB_DEPT.Text; objFW.CS_DEPT = this.CS_DEPT.Text; objFW.REMARK1 = this.REMARK1.Text; objFW.SUBJECT_WORD = this.SUBJECT_WORD.Text; objFW.DRAFT_DATE = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"); objFW.DRAFT_ID = LogInfo.UserInfo.ID; objFW.FW_DATE = DateTime.Now.ToString(); objFW.FW_STATUS = "1"; if (string.IsNullOrEmpty(this.hidTaskId.Value)) { objFW.ID = GetSerialNumber("t_oa_FWInfoID"); if (new TOaFwInfoLogic().Create(objFW)) { wfControl.SaveInstStepServiceData("发文ID", "fw_id", objFW.ID, "1"); //注册编号 wfControl.ServiceCode = "FW" + DateTime.Now.ToString("yyyyMMddHHmmss"); //注册名称 wfControl.ServiceName = "“" + this.FW_TITLE.Text + "”" + "发文办理"; } else { LigerDialogAlert("数据发送失败!", "error"); return; } } else { objFW.ID = this.hidTaskId.Value; if (new TOaFwInfoLogic().Edit(objFW)) { wfControl.SaveInstStepServiceData("发文ID", "fw_id", objFW.ID, "1"); //注册编号 wfControl.ServiceCode = "FW" + DateTime.Now.ToString("yyyyMMddHHmmss"); //注册名称 wfControl.ServiceName = "“" + this.FW_TITLE.Text + "”" + "发文办理"; } else { LigerDialogAlert("数据发送失败!", "error"); return; } } }
/// <summary> /// 获得查询结果总行数,用于分页 /// </summary> /// <param name="tOaFwInfo">对象</param> /// <returns>返回行数</returns> public int GetSelectResultCount(TOaFwInfoVo tOaFwInfo) { return(access.GetSelectResultCount(tOaFwInfo)); }
/// <summary> /// 对象编辑 /// </summary> /// <param name="tOaFwInfo_UpdateSet">UpdateSet用户对象</param> /// <param name="tOaFwInfo_UpdateWhere">UpdateWhere用户对象</param> /// <returns>是否成功</returns> public bool Edit(TOaFwInfoVo tOaFwInfo_UpdateSet, TOaFwInfoVo tOaFwInfo_UpdateWhere) { return(access.Edit(tOaFwInfo_UpdateSet, tOaFwInfo_UpdateWhere)); }
/// <summary> /// 对象删除 /// </summary> /// <param name="Id">ID</param> /// <returns>是否成功</returns> public bool Delete(TOaFwInfoVo tOaFwInfo) { return(access.Delete(tOaFwInfo)); }
/// <summary> /// 对象添加 /// </summary> /// <param name="sysRole">对象</param> /// <returns>是否成功</returns> public bool Create(TOaFwInfoVo tOaFwInfo) { return(access.Create(tOaFwInfo)); }
/// <summary> /// 对象编辑 /// </summary> /// <param name="tOaFwInfo">用户对象</param> /// <returns>是否成功</returns> public bool Edit(TOaFwInfoVo tOaFwInfo) { return(access.Edit(tOaFwInfo)); }
/// <summary> /// 根据对象特征获取单一对象 /// </summary> /// <param name="tOaFwInfo">对象</param> /// <returns></returns> public TOaFwInfoVo SelectByObject(TOaFwInfoVo tOaFwInfo) { return(access.SelectByObject(tOaFwInfo)); }
/// <summary> /// 根据对象获取全部数据,用Table承载 /// 数据量较小时使用【不推荐】 /// </summary> /// <param name="tOaFwInfo"></param> /// <returns></returns> public DataTable SelectByTable(TOaFwInfoVo tOaFwInfo) { return(access.SelectByTable(tOaFwInfo)); }
void IWFStepRules.SaveBusinessDataFromPageControl() { //这里是执行业务数据保存的地方,此处由工作流控件间接调用 string validateMsg = ValidateBusinessData(); if (!string.IsNullOrEmpty(validateMsg)) { LigerDialogAlert(validateMsg, "warn"); } else { TOaFwInfoVo objFW = new TOaFwInfoVo(); objFW.YWNO = this.YWNO.Text; objFW.FWNO = this.YWNO.Text; objFW.FW_TITLE = this.FW_TITLE.Text; objFW.ZB_DEPT = this.ZB_DEPT.Text; objFW.MJ = this.MJ.SelectedValue; objFW.ZS_DEPT = this.ZS_DEPT.Text; objFW.CB_DEPT = this.CB_DEPT.Text; objFW.CS_DEPT = this.CS_DEPT.Text; objFW.REMARK1 = this.REMARK1.Text; objFW.SUBJECT_WORD = this.SUBJECT_WORD.Text; objFW.FW_DATE = DateTime.Now.ToString(); objFW.DRAFT_DATE = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"); objFW.DRAFT_ID = LogInfo.UserInfo.ID; objFW.FW_STATUS = "0"; if (string.IsNullOrEmpty(hidTaskId.Value)) { objFW.ID = GetSerialNumber("t_oa_FWInfoID"); this.hid_FwId.Value = objFW.ID;//发文ID if (new TOaFwInfoLogic().Create(objFW)) { //wfControl.SaveInstStepServiceData("发文ID", "fw_id", objFW.ID, "1"); ////注册编号 //wfControl.ServiceCode = "FW" + DateTime.Now.ToString("yyyyMMddHHmmss"); ////注册名称 //wfControl.ServiceName = "“" + this.FW_TITLE.Text + "”" + "公文发放"; this.hidTaskId.Value = objFW.ID; } else { LigerDialogAlert("数据保存失败!", "error"); return; } } else { objFW.ID = this.hidTaskId.Value; this.hid_FwId.Value = this.hidTaskId.Value; if (new TOaFwInfoLogic().Edit(objFW)) { //wfControl.SaveInstStepServiceData("发文ID", "fw_id", objFW.ID, "1"); ////注册编号 //wfControl.ServiceCode = "FW" + DateTime.Now.ToString("yyyyMMddHHmmss"); ////注册名称 //wfControl.ServiceName = "“" + this.FW_TITLE.Text + "”" + "公文发放"; } else { LigerDialogAlert("数据保存失败!", "error"); return; } } } }
/// <summary> /// 根据对象特征获取单一对象 /// </summary> /// <param name="tOaFwInfo">对象</param> /// <returns></returns> public TOaFwInfoVo SelectByObject(TOaFwInfoVo tOaFwInfo) { string strSQL = "select * from T_OA_FW_INFO " + this.BuildWhereStatement(tOaFwInfo); return(SqlHelper.ExecuteObject(new TOaFwInfoVo(), strSQL)); }
public TOaFwInfoLogic(TOaFwInfoVo _tOaFwInfo) { tOaFwInfo = _tOaFwInfo; access = new TOaFwInfoAccess(); }
/// <summary> /// 对象添加 /// </summary> /// <param name="tOaFwInfo">对象</param> /// <returns>是否成功</returns> public bool Create(TOaFwInfoVo tOaFwInfo) { string strSQL = SqlHelper.BuildInsertExpress(tOaFwInfo, TOaFwInfoVo.T_OA_FW_INFO_TABLE); return(SqlHelper.ExecuteNonQuery(CommandType.Text, strSQL) > 0 ? true : false); }
private void SetAPPInfo(TOaFwInfoVo objFW) { this.APP_INFO.Value = objFW.APP_INFO; this.APP_ID.Text = new TSysUserLogic().Details(objFW.APP_ID).REAL_NAME; this.APP_DATE.Text = string.IsNullOrEmpty(objFW.APP_DATE) ? "" : DateTime.Parse(objFW.APP_DATE).ToShortDateString(); }