public static string AddSFWRead(string strUserID, string strSWID)
{
List <TOaSwReadVo> list = new TOaSwReadLogic().SelectByReadUser(strSWID);
for (int i = 0; i < list.Count; i++)
{
string swid = list[i].ID;
new TOaSwReadLogic().Delete(swid);
}
string[] str = strUserID.Split(',');
foreach (string userid in str)
{
if (userid == "")
{
break;
}
TOaSwReadVo objSR = new TOaSwReadVo();
objSR.IS_OK = "0";
objSR.REMARK1 = "0";
objSR.SW_ID = strSWID;
objSR.SW_PLAN_ID = userid;
objSR.ID = GetSerialNumber("t_oa_sfw_read");
new TOaSwReadLogic().Create(objSR);
}
return("1");
}
/// <summary>
/// 获取对象DataTable
/// </summary>
/// <param name="tOaSwRead">对象</param>
/// <param name="iIndex">起始页码</param>
/// <param name="iCount">每页数目</param>
/// <returns>返回结果</returns>
public DataTable SelectByTable(TOaSwReadVo tOaSwRead, int iIndex, int iCount)
{
string strSQL = " select * from T_OA_SW_READ {0} ";
strSQL = String.Format(strSQL, BuildWhereStatement(tOaSwRead));
return(SqlHelper.ExecuteDataTable(BuildPagerExpress(strSQL, iIndex, iCount)));
}
/// <summary>
/// 对象编辑
/// </summary>
/// <param name="tOaSwRead">用户对象</param>
/// <returns>是否成功</returns>
public bool Edit(TOaSwReadVo tOaSwRead)
{
string strSQL = SqlHelper.BuildUpdateExpress(tOaSwRead, TOaSwReadVo.T_OA_SW_READ_TABLE);
strSQL += string.Format(" where ID='{0}' ", tOaSwRead.ID);
return(SqlHelper.ExecuteNonQuery(CommandType.Text, strSQL) > 0 ? true : false);
}
/// <summary>
/// 对象编辑
/// </summary>
/// <param name="tOaSwRead_UpdateSet">UpdateSet用户对象</param>
/// <param name="tOaSwRead_UpdateWhere">UpdateWhere用户对象</param>
/// <returns>是否成功</returns>
public bool Edit(TOaSwReadVo tOaSwRead_UpdateSet, TOaSwReadVo tOaSwRead_UpdateWhere)
{
string strSQL = SqlHelper.BuildUpdateExpress(tOaSwRead_UpdateSet, TOaSwReadVo.T_OA_SW_READ_TABLE);
strSQL += this.BuildWhereStatement(tOaSwRead_UpdateWhere);
return(SqlHelper.ExecuteNonQuery(CommandType.Text, strSQL) > 0 ? true : false);
}
public static string FinishData(string ID, string Status, string SwReadIDs, string LoginID)
{
string[] arrSwReadIds = SwReadIDs.Split(',');
for (int i = 0; i < arrSwReadIds.Length; i++)
{
if (arrSwReadIds[i].Length > 0)
{
TOaSwReadVo objRead = new TOaSwReadVo();
objRead.ID = GetSerialNumber("t_oa_SWReadID");
objRead.SW_ID = ID;
objRead.SW_PLAN_ID = arrSwReadIds[i];
objRead.SW_PLAN_DATE = System.DateTime.Now.ToShortDateString();
objRead.IS_OK = "0";
new TOaSwReadLogic().Create(objRead);
}
}
bool b = false;
b = new TOaSwInfoLogic().FinishSW(ID, "6", Status, LoginID);
if (b)
{
return("成功");
}
else
{
return("");
}
}
/// <summary>
/// 根据对象构造条件语句
/// </summary>
/// <param name="tOaSwRead"></param>
/// <returns></returns>
public string BuildWhereStatement(TOaSwReadVo tOaSwRead)
{
StringBuilder strWhereStatement = new StringBuilder(" Where 1=1 ");
if (null != tOaSwRead)
{
//ID
if (!String.IsNullOrEmpty(tOaSwRead.ID.ToString().Trim()))
{
strWhereStatement.Append(string.Format(" AND ID = '{0}'", tOaSwRead.ID.ToString()));
}
//收文ID
if (!String.IsNullOrEmpty(tOaSwRead.SW_ID.ToString().Trim()))
{
strWhereStatement.Append(string.Format(" AND SW_ID = '{0}'", tOaSwRead.SW_ID.ToString()));
}
//传阅人ID
if (!String.IsNullOrEmpty(tOaSwRead.SW_PLAN_ID.ToString().Trim()))
{
strWhereStatement.Append(string.Format(" AND SW_PLAN_ID = '{0}'", tOaSwRead.SW_PLAN_ID.ToString()));
}
//传阅日期
if (!String.IsNullOrEmpty(tOaSwRead.SW_PLAN_DATE.ToString().Trim()))
{
strWhereStatement.Append(string.Format(" AND SW_PLAN_DATE = '{0}'", tOaSwRead.SW_PLAN_DATE.ToString()));
}
//是否已阅
if (!String.IsNullOrEmpty(tOaSwRead.IS_OK.ToString().Trim()))
{
strWhereStatement.Append(string.Format(" AND IS_OK = '{0}'", tOaSwRead.IS_OK.ToString()));
}
//备注1
if (!String.IsNullOrEmpty(tOaSwRead.REMARK1.ToString().Trim()))
{
strWhereStatement.Append(string.Format(" AND REMARK1 = '{0}'", tOaSwRead.REMARK1.ToString()));
}
//备注2
if (!String.IsNullOrEmpty(tOaSwRead.REMARK2.ToString().Trim()))
{
strWhereStatement.Append(string.Format(" AND REMARK2 = '{0}'", tOaSwRead.REMARK2.ToString()));
}
//备注3
if (!String.IsNullOrEmpty(tOaSwRead.REMARK3.ToString().Trim()))
{
strWhereStatement.Append(string.Format(" AND REMARK3 = '{0}'", tOaSwRead.REMARK3.ToString()));
}
//备注4
if (!String.IsNullOrEmpty(tOaSwRead.REMARK4.ToString().Trim()))
{
strWhereStatement.Append(string.Format(" AND REMARK4 = '{0}'", tOaSwRead.REMARK4.ToString()));
}
//备注5
if (!String.IsNullOrEmpty(tOaSwRead.REMARK5.ToString().Trim()))
{
strWhereStatement.Append(string.Format(" AND REMARK5 = '{0}'", tOaSwRead.REMARK5.ToString()));
}
}
return(strWhereStatement.ToString());
}
/// <summary>
/// 对象删除
/// </summary>
/// <param name="Id">ID</param>
/// <returns>是否成功</returns>
public bool Delete(TOaSwReadVo tOaSwRead)
{
string strSQL = "delete from T_OA_SW_READ ";
strSQL += this.BuildWhereStatement(tOaSwRead);
return(SqlHelper.ExecuteNonQuery(CommandType.Text, strSQL) > 0 ? true : false);
}
public static string updateStatus(string strID)
{
TOaSwReadVo sr = new TOaSwReadVo();
sr.SW_ID = strID;
sr.SW_PLAN_ID = new i3.View.PageBase().LogInfo.UserInfo.ID;
TOaSwReadVo srv = new TOaSwReadLogic().SelectByObject(sr);
srv.IS_OK = "1";
new TOaSwReadLogic().Edit(srv);
return("1");
}
/// <summary>
/// 获取断面信息
/// </summary>
/// <returns></returns>
private string getOneGridInfo()
{
string strSortname = Request.Params["sortname"];
string strSortorder = Request.Params["sortorder"];
//当前页面
int intPageIndex = Convert.ToInt32(Request.Params["page"]);
//每页记录数
int intPageSize = Convert.ToInt32(Request.Params["pagesize"]);
TOaSwReadVo tr = new TOaSwReadVo();
tr.REMARK1 = "0";
tr.SW_PLAN_ID = LogInfo.UserInfo.ID;
TOaSwInfoVo TOaSwInfoVo = new TOaSwInfoVo();
DataTable dt = new TOaSwInfoLogic().SelectByTable_ForRead(TOaSwInfoVo, LogInfo.UserInfo.ID, intPageIndex, intPageSize);
//int intTotalCount = new TOaSwInfoLogic().GetSelectResultCount(TOaSwInfoVo);
int intTotalCount = new TOaSwReadLogic().GetSelectResultCount(tr);
string strJson = CreateToJson(dt, intTotalCount);
return(strJson);
}
/// <summary>
/// 获得查询结果总行数，用于分页
/// </summary>
/// <param name="tOaSwRead">对象</param>
/// <returns>返回行数</returns>
public int GetSelectResultCount(TOaSwReadVo tOaSwRead)
{
string strSQL = "select Count(*) from T_OA_SW_READ " + this.BuildWhereStatement(tOaSwRead);
return(Convert.ToInt32(SqlHelper.ExecuteScalar(strSQL)));
}
/// <summary>
/// 对象明细
/// </summary>
/// <param name="tOaSwRead">对象条件</param>
/// <returns>对象</returns>
public TOaSwReadVo Details(TOaSwReadVo tOaSwRead)
{
string strSQL = String.Format("select * from T_OA_SW_READ " + this.BuildWhereStatement(tOaSwRead));
return(SqlHelper.ExecuteObject(new TOaSwReadVo(), strSQL));
}
/// <summary>
/// 对象删除
/// </summary>
/// <param name="Id">ID</param>
/// <returns>是否成功</returns>
public bool Delete(TOaSwReadVo tOaSwRead)
{
return(access.Delete(tOaSwRead));
}
/// <summary>
/// 对象编辑
/// </summary>
/// <param name="tOaSwRead_UpdateSet">UpdateSet用户对象</param>
/// <param name="tOaSwRead_UpdateWhere">UpdateWhere用户对象</param>
/// <returns>是否成功</returns>
public bool Edit(TOaSwReadVo tOaSwRead_UpdateSet, TOaSwReadVo tOaSwRead_UpdateWhere)
{
return(access.Edit(tOaSwRead_UpdateSet, tOaSwRead_UpdateWhere));
}
/// <summary>
/// 获得查询结果总行数，用于分页
/// </summary>
/// <param name="tOaSwRead">对象</param>
/// <returns>返回行数</returns>
public int GetSelectResultCount(TOaSwReadVo tOaSwRead)
{
return(access.GetSelectResultCount(tOaSwRead));
}
public TOaSwReadLogic(TOaSwReadVo _tOaSwRead)
{
tOaSwRead = _tOaSwRead;
access = new TOaSwReadAccess();
}
/// <summary>
/// 根据对象特征获取单一对象
/// </summary>
/// <param name="tOaSwRead">对象</param>
/// <returns></returns>
public TOaSwReadVo SelectByObject(TOaSwReadVo tOaSwRead)
{
string strSQL = "select * from T_OA_SW_READ " + this.BuildWhereStatement(tOaSwRead);
return(SqlHelper.ExecuteObject(new TOaSwReadVo(), strSQL));
}
/// <summary>
/// 对象添加
/// </summary>
/// <param name="tOaSwRead">对象</param>
/// <returns>是否成功</returns>
public bool Create(TOaSwReadVo tOaSwRead)
{
string strSQL = SqlHelper.BuildInsertExpress(tOaSwRead, TOaSwReadVo.T_OA_SW_READ_TABLE);
return(SqlHelper.ExecuteNonQuery(CommandType.Text, strSQL) > 0 ? true : false);
}
/// <summary>
/// 对象编辑
/// </summary>
/// <param name="tOaSwRead">用户对象</param>
/// <returns>是否成功</returns>
public bool Edit(TOaSwReadVo tOaSwRead)
{
return(access.Edit(tOaSwRead));
}
/// <summary>
/// 获取对象List
/// </summary>
/// <param name="tOaSwRead">对象</param>
/// <param name="iIndex">起始页码</param>
/// <param name="iCount">每页数目</param>
/// <returns>返回结果</returns>
public List <TOaSwReadVo> SelectByObject(TOaSwReadVo tOaSwRead, int iIndex, int iCount)
{
string strSQL = String.Format("select * from T_OA_SW_READ " + this.BuildWhereStatement(tOaSwRead));
return(SqlHelper.ExecuteObjectList(tOaSwRead, BuildPagerExpress(strSQL, iIndex, iCount)));
}
/// <summary>
/// 对象明细
/// </summary>
/// <param name="tOaSwRead">对象条件</param>
/// <returns>对象</returns>
public TOaSwReadVo Details(TOaSwReadVo tOaSwRead)
{
return(access.Details(tOaSwRead));
}
/// <summary>
/// 获取对象DataTable
/// </summary>
/// <param name="tOaSwRead">对象</param>
/// <param name="iIndex">起始页码</param>
/// <param name="iCount">每页数目</param>
/// <returns>返回结果</returns>
public DataTable SelectByTable(TOaSwReadVo tOaSwRead, int iIndex, int iCount)
{
return(access.SelectByTable(tOaSwRead, iIndex, iCount));
}
/// <summary>
/// 获取对象List
/// </summary>
/// <param name="tOaSwRead">对象</param>
/// <param name="iIndex">起始页码</param>
/// <param name="iCount">每页数目</param>
/// <returns>返回结果</returns>
public List <TOaSwReadVo> SelectByObject(TOaSwReadVo tOaSwRead, int iIndex, int iCount)
{
return(access.SelectByObject(tOaSwRead, iIndex, iCount));
}
/// <summary>
/// 根据对象特征获取单一对象
/// </summary>
/// <param name="tOaSwRead">对象</param>
/// <returns></returns>
public TOaSwReadVo SelectByObject(TOaSwReadVo tOaSwRead)
{
return(access.SelectByObject(tOaSwRead));
}
/// <summary>
/// 对象添加
/// </summary>
/// <param name="sysRole">对象</param>
/// <returns>是否成功</returns>
public bool Create(TOaSwReadVo tOaSwRead)
{
return(access.Create(tOaSwRead));
}
/// <summary>
/// 根据对象获取全部数据，用Table承载
/// 数据量较小时使用【不推荐】
/// </summary>
/// <param name="tOaSwRead"></param>
/// <returns></returns>
public DataTable SelectByTable(TOaSwReadVo tOaSwRead)
{
string strSQL = "select * from T_OA_SW_READ " + this.BuildWhereStatement(tOaSwRead);
return(SqlHelper.ExecuteDataTable(strSQL));
}
/// <summary>
/// 根据对象获取全部数据，用Table承载
/// 数据量较小时使用【不推荐】
/// </summary>
/// <param name="tOaSwRead"></param>
/// <returns></returns>
public DataTable SelectByTable(TOaSwReadVo tOaSwRead)
{
return(access.SelectByTable(tOaSwRead));
}
