/// <summary>
/// 对象编辑
/// </summary>
/// <param name="tWfSettingTaskHasapp">用户对象</param>
/// <returns>是否成功</returns>
public bool Edit(TWfSettingTaskHasappVo tWfSettingTaskHasapp)
{
string strSQL = SqlHelper.BuildUpdateExpress(tWfSettingTaskHasapp, TWfSettingTaskHasappVo.T_WF_SETTING_TASK_HASAPP_TABLE);
strSQL += string.Format(" where ID='{0}' ", tWfSettingTaskHasapp.ID);
return(SqlHelper.ExecuteNonQuery(CommandType.Text, strSQL) > 0 ? true : false);
}
/// <summary>
/// 获取对象DataTable
/// </summary>
/// <param name="tWfSettingTaskHasapp">对象</param>
/// <param name="iIndex">起始页码</param>
/// <param name="iCount">每页数目</param>
/// <returns>返回结果</returns>
public DataTable SelectByTable(TWfSettingTaskHasappVo tWfSettingTaskHasapp, int iIndex, int iCount)
{
string strSQL = " select * from T_WF_SETTING_TASK_HASAPP {0} ";
strSQL = String.Format(strSQL, BuildWhereStatement(tWfSettingTaskHasapp));
return(SqlHelper.ExecuteDataTable(BuildPagerExpress(strSQL, iIndex, iCount)));
}
/// <summary>
/// 对象编辑
/// </summary>
/// <param name="tWfSettingTaskHasapp_UpdateSet">UpdateSet用户对象</param>
/// <param name="tWfSettingTaskHasapp_UpdateWhere">UpdateWhere用户对象</param>
/// <returns>是否成功</returns>
public bool Edit(TWfSettingTaskHasappVo tWfSettingTaskHasapp_UpdateSet, TWfSettingTaskHasappVo tWfSettingTaskHasapp_UpdateWhere)
{
string strSQL = SqlHelper.BuildUpdateExpress(tWfSettingTaskHasapp_UpdateSet, TWfSettingTaskHasappVo.T_WF_SETTING_TASK_HASAPP_TABLE);
strSQL += this.BuildWhereStatement(tWfSettingTaskHasapp_UpdateWhere);
return(SqlHelper.ExecuteNonQuery(CommandType.Text, strSQL) > 0 ? true : false);
}
/// <summary>
/// 对象删除
/// </summary>
/// <param name="Id">ID</param>
/// <returns>是否成功</returns>
public bool Delete(TWfSettingTaskHasappVo tWfSettingTaskHasapp)
{
string strSQL = "delete from T_WF_SETTING_TASK_HASAPP ";
strSQL += this.BuildWhereStatement(tWfSettingTaskHasapp);
return(SqlHelper.ExecuteNonQuery(CommandType.Text, strSQL) > 0 ? true : false);
}
/// <summary>
/// 获取纸质数据审核记录信息
/// </summary>
/// <returns></returns>
private string getAppInfo()
{
TWfSettingTaskHasappVo tObjVo = new TWfSettingTaskHasappVo();
//int intTotalCount = 0;
//intTotalCount = new TWfSettingTaskHasappLogic().GetSelectResultCount_ForApp(base.LogInfo.UserInfo.ID);
DataTable dt = new TWfSettingTaskHasappLogic().SelectByTable_ForApp(base.LogInfo.UserInfo.ID, 0, 0);
#region 过滤重复列--可能存在同一任务，经过多次退回，存在多次审核的情况
DataTable dttmp = new DataTable();
for (int i = 0; i < dt.Columns.Count; i++)
{
dttmp.Columns.Add(dt.Columns[i].ColumnName);
}
string strTmps = "";
for (int i = dt.Rows.Count - 1; i >= 0; i--)
{
string strtmp = "";
for (int j = 1; j < dt.Columns.Count; j++)
{
strtmp += "," + dt.Rows[i][j].ToString();
}
strtmp += ",";
if (!strTmps.Contains(strtmp))
{
strTmps += "|" + strtmp;
DataRow dr = dttmp.NewRow();
for (int j = 0; j < dt.Columns.Count; j++)
{
dr[j] = dt.Rows[i][j].ToString();
}
dttmp.Rows.InsertAt(dr, 0);
}
}
#endregion
string strJson = CreateToJson(dttmp, dttmp.Rows.Count);
return(strJson);
}
public static string appData(string strWF_ID, string strWF_TASK_ID, string strWF_TASK_Name, string strTASK_ID)
{
TWfSettingTaskHasappVo tObjVo = new TWfSettingTaskHasappVo();
tObjVo.WF_ID = strWF_ID;
tObjVo.WF_TASK_ID = strWF_TASK_ID;
tObjVo.WF_TASK_NAME = strWF_TASK_Name;
tObjVo.TASK_ID = strTASK_ID;
tObjVo.HAS_APP = "1";
tObjVo.ID = GetSerialNumber("T_WF_SETTING_TASK_HASAPP");
bool isSuccess = new TWfSettingTaskHasappLogic().Create(tObjVo);
if (isSuccess)
{
new PageBase().WriteLog("纸质数据审核", "", new PageBase().LogInfo.UserInfo.USER_NAME + "设置已签" + strTASK_ID + "成功");
}
return(isSuccess == true ? "1" : "0");
}
/// <summary>
/// 根据对象构造条件语句
/// </summary>
/// <param name="tWfSettingTaskHasapp"></param>
/// <returns></returns>
public string BuildWhereStatement(TWfSettingTaskHasappVo tWfSettingTaskHasapp)
{
StringBuilder strWhereStatement = new StringBuilder(" Where 1=1 ");
if (null != tWfSettingTaskHasapp)
{
//Id
if (!String.IsNullOrEmpty(tWfSettingTaskHasapp.ID.ToString().Trim()))
{
strWhereStatement.Append(string.Format(" AND ID = '{0}'", tWfSettingTaskHasapp.ID.ToString()));
}
//环节ID
if (!String.IsNullOrEmpty(tWfSettingTaskHasapp.WF_TASK_ID.ToString().Trim()))
{
strWhereStatement.Append(string.Format(" AND WF_TASK_ID = '{0}'", tWfSettingTaskHasapp.WF_TASK_ID.ToString()));
}
//环节名
if (!String.IsNullOrEmpty(tWfSettingTaskHasapp.WF_TASK_NAME.ToString().Trim()))
{
strWhereStatement.Append(string.Format(" AND WF_TASK_NAME = '{0}'", tWfSettingTaskHasapp.WF_TASK_NAME.ToString()));
}
//流程ID或者流程类别（监测分析用流程类别）
if (!String.IsNullOrEmpty(tWfSettingTaskHasapp.WF_ID.ToString().Trim()))
{
strWhereStatement.Append(string.Format(" AND WF_ID = '{0}'", tWfSettingTaskHasapp.WF_ID.ToString()));
}
//实例ID
if (!String.IsNullOrEmpty(tWfSettingTaskHasapp.TASK_ID.ToString().Trim()))
{
strWhereStatement.Append(string.Format(" AND TASK_ID = '{0}'", tWfSettingTaskHasapp.TASK_ID.ToString()));
}
//是否已审核
if (!String.IsNullOrEmpty(tWfSettingTaskHasapp.HAS_APP.ToString().Trim()))
{
strWhereStatement.Append(string.Format(" AND HAS_APP = '{0}'", tWfSettingTaskHasapp.HAS_APP.ToString()));
}
}
return(strWhereStatement.ToString());
}
/// <summary>
/// 获得查询结果总行数，用于分页
/// </summary>
/// <param name="tWfSettingTaskHasapp">对象</param>
/// <returns>返回行数</returns>
public int GetSelectResultCount(TWfSettingTaskHasappVo tWfSettingTaskHasapp)
{
return(access.GetSelectResultCount(tWfSettingTaskHasapp));
}
/// <summary>
/// 获取对象DataTable
/// </summary>
/// <param name="tWfSettingTaskHasapp">对象</param>
/// <param name="iIndex">起始页码</param>
/// <param name="iCount">每页数目</param>
/// <returns>返回结果</returns>
public DataTable SelectByTable(TWfSettingTaskHasappVo tWfSettingTaskHasapp, int iIndex, int iCount)
{
return(access.SelectByTable(tWfSettingTaskHasapp, iIndex, iCount));
}
/// <summary>
/// 根据对象获取全部数据，用Table承载
/// 数据量较小时使用【不推荐】
/// </summary>
/// <param name="tWfSettingTaskHasapp"></param>
/// <returns></returns>
public DataTable SelectByTable(TWfSettingTaskHasappVo tWfSettingTaskHasapp)
{
return(access.SelectByTable(tWfSettingTaskHasapp));
}
/// <summary>
/// 对象添加
/// </summary>
/// <param name="tWfSettingTaskHasapp">对象</param>
/// <returns>是否成功</returns>
public bool Create(TWfSettingTaskHasappVo tWfSettingTaskHasapp)
{
string strSQL = SqlHelper.BuildInsertExpress(tWfSettingTaskHasapp, TWfSettingTaskHasappVo.T_WF_SETTING_TASK_HASAPP_TABLE);
return(SqlHelper.ExecuteNonQuery(CommandType.Text, strSQL) > 0 ? true : false);
}
/// <summary>
/// 根据对象特征获取单一对象
/// </summary>
/// <param name="tWfSettingTaskHasapp">对象</param>
/// <returns></returns>
public TWfSettingTaskHasappVo SelectByObject(TWfSettingTaskHasappVo tWfSettingTaskHasapp)
{
string strSQL = "select * from T_WF_SETTING_TASK_HASAPP " + this.BuildWhereStatement(tWfSettingTaskHasapp);
return(SqlHelper.ExecuteObject(new TWfSettingTaskHasappVo(), strSQL));
}
/// <summary>
/// 根据对象获取全部数据，用Table承载
/// 数据量较小时使用【不推荐】
/// </summary>
/// <param name="tWfSettingTaskHasapp"></param>
/// <returns></returns>
public DataTable SelectByTable(TWfSettingTaskHasappVo tWfSettingTaskHasapp)
{
string strSQL = "select * from T_WF_SETTING_TASK_HASAPP " + this.BuildWhereStatement(tWfSettingTaskHasapp);
return(SqlHelper.ExecuteDataTable(strSQL));
}
/// <summary>
/// 根据对象特征获取单一对象
/// </summary>
/// <param name="tWfSettingTaskHasapp">对象</param>
/// <returns></returns>
public TWfSettingTaskHasappVo SelectByObject(TWfSettingTaskHasappVo tWfSettingTaskHasapp)
{
return(access.SelectByObject(tWfSettingTaskHasapp));
}
/// <summary>
/// 获取对象List
/// </summary>
/// <param name="tWfSettingTaskHasapp">对象</param>
/// <param name="iIndex">起始页码</param>
/// <param name="iCount">每页数目</param>
/// <returns>返回结果</returns>
public List <TWfSettingTaskHasappVo> SelectByObject(TWfSettingTaskHasappVo tWfSettingTaskHasapp, int iIndex, int iCount)
{
string strSQL = String.Format("select * from T_WF_SETTING_TASK_HASAPP " + this.BuildWhereStatement(tWfSettingTaskHasapp));
return(SqlHelper.ExecuteObjectList(tWfSettingTaskHasapp, BuildPagerExpress(strSQL, iIndex, iCount)));
}
/// <summary>
/// 获取对象List
/// </summary>
/// <param name="tWfSettingTaskHasapp">对象</param>
/// <param name="iIndex">起始页码</param>
/// <param name="iCount">每页数目</param>
/// <returns>返回结果</returns>
public List <TWfSettingTaskHasappVo> SelectByObject(TWfSettingTaskHasappVo tWfSettingTaskHasapp, int iIndex, int iCount)
{
return(access.SelectByObject(tWfSettingTaskHasapp, iIndex, iCount));
}
public TWfSettingTaskHasappLogic(TWfSettingTaskHasappVo _tWfSettingTaskHasapp)
{
tWfSettingTaskHasapp = _tWfSettingTaskHasapp;
access = new TWfSettingTaskHasappAccess();
}
/// <summary>
/// 对象删除
/// </summary>
/// <param name="Id">ID</param>
/// <returns>是否成功</returns>
public bool Delete(TWfSettingTaskHasappVo tWfSettingTaskHasapp)
{
return(access.Delete(tWfSettingTaskHasapp));
}
/// <summary>
/// 对象编辑
/// </summary>
/// <param name="tWfSettingTaskHasapp_UpdateSet">UpdateSet用户对象</param>
/// <param name="tWfSettingTaskHasapp_UpdateWhere">UpdateWhere用户对象</param>
/// <returns>是否成功</returns>
public bool Edit(TWfSettingTaskHasappVo tWfSettingTaskHasapp_UpdateSet, TWfSettingTaskHasappVo tWfSettingTaskHasapp_UpdateWhere)
{
return(access.Edit(tWfSettingTaskHasapp_UpdateSet, tWfSettingTaskHasapp_UpdateWhere));
}
/// <summary>
/// 对象编辑
/// </summary>
/// <param name="tWfSettingTaskHasapp">用户对象</param>
/// <returns>是否成功</returns>
public bool Edit(TWfSettingTaskHasappVo tWfSettingTaskHasapp)
{
return(access.Edit(tWfSettingTaskHasapp));
}
/// <summary>
/// 对象添加
/// </summary>
/// <param name="sysRole">对象</param>
/// <returns>是否成功</returns>
public bool Create(TWfSettingTaskHasappVo tWfSettingTaskHasapp)
{
return(access.Create(tWfSettingTaskHasapp));
}
/// <summary>
/// 获得查询结果总行数，用于分页
/// </summary>
/// <param name="tWfSettingTaskHasapp">对象</param>
/// <returns>返回行数</returns>
public int GetSelectResultCount(TWfSettingTaskHasappVo tWfSettingTaskHasapp)
{
string strSQL = "select Count(*) from T_WF_SETTING_TASK_HASAPP " + this.BuildWhereStatement(tWfSettingTaskHasapp);
return(Convert.ToInt32(SqlHelper.ExecuteScalar(strSQL)));
}
/// <summary>
/// 对象明细
/// </summary>
/// <param name="tWfSettingTaskHasapp">对象条件</param>
/// <returns>对象</returns>
public TWfSettingTaskHasappVo Details(TWfSettingTaskHasappVo tWfSettingTaskHasapp)
{
return(access.Details(tWfSettingTaskHasapp));
}
