/// <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);
}
}
