?? documentflow.cs
字號:
/// 獲得用戶所有的項目
/// </summary>
/// <param name="UserName">用戶名</param>
/// <param name="dt">返回表格</param>
public int GetProject(string UserName,out SqlDataReader dr )
{
//int iReturn=0;
dr = null;
UDS.Components.Database mySQL = new UDS.Components.Database();
SqlParameter[] parameters = {
mySQL.MakeInParam("@UserName",SqlDbType.VarChar ,300,UserName)
};
try
{
mySQL.RunProc("sp_GetTaskClass",parameters,out dr);
}
catch(Exception e)
{
Error.Log(e.ToString());
}
finally
{
//mySQL.Close();
//mySQL = null;
}
return 0;
}
#endregion
#region 獲得文檔的批注,返回記錄集
/// <summary>
/// 獲得流程的表格樣式描述
/// </summary>
/// <param name="DocID">文檔ID</param>
/// <param name="dr">返回表格</param>
public int GetDocumentPostil(long DocID,out SqlDataReader dr )
{
//int iReturn=-1;
UDS.Components.Database mySQL = new UDS.Components.Database();
SqlParameter[] parameters = {
mySQL.MakeInParam("@DocID",SqlDbType.Int ,4,DocID)
};
try
{
mySQL.RunProc("sp_Flow_GetDocumentPostil",parameters,out dr);
}
catch(Exception e)
{
Error.Log(e.ToString());
dr = null;
}
finally
{
//mySQL.Close();
//mySQL = null;
}
return 0;
}
#endregion
#region 獲得文檔的批注,返回表格
/// <summary>
/// 獲得流程的表格樣式描述
/// </summary>
/// <param name="DocID">文檔ID</param>
/// <param name="dt">返回表格</param>
public int GetDocumentPostil(long DocID,out DataTable dt )
{
//int iReturn=-1;
SqlDataReader dr;
UDS.Components.Database mySQL = new UDS.Components.Database();
SqlParameter[] parameters = {
mySQL.MakeInParam("@DocID",SqlDbType.Int ,4,DocID)
};
try
{
mySQL.RunProc("sp_Flow_GetDocumentPostil",parameters,out dr);
dt = UDS.Components.Tools.ConvertDataReaderToDataTable(dr);
}
catch(Exception e)
{
Error.Log(e.ToString());
dt = null;
}
finally
{
mySQL.Close();
mySQL = null;
}
return 0;
}
#endregion
#region 獲得文檔的信息實體,返回記錄集
/// <summary>
/// 獲得流程的表格樣式描述
/// </summary>
/// <param name="DocID">文檔ID</param>
/// <param name="dr">返回記錄集</param>
public int GetDocumentInfo(long DocID,out SqlDataReader dr )
{
//int iReturn=-1;
//SqlDataReader dd;
UDS.Components.Database mySQL = new UDS.Components.Database();
SqlParameter[] parameters = {
mySQL.MakeInParam("@DocID",SqlDbType.Int ,4,DocID)
};
try
{
mySQL.RunProc("sp_Flow_GetDocumentInfo",parameters,out dr);
}
catch(Exception e)
{
dr = null;
Error.Log(e.ToString());
}
finally
{
//mySQL.Close();
//mySQL = null;
}
return 0;
}
#endregion
#region 獲得文檔的信息實體,返回表格
/// <summary>
/// 獲得流程的表格樣式描述
/// </summary>
/// <param name="DocID">文檔ID</param>
/// <param name="dr">返回表格</param>
public int GetDocumentInfo(long DocID,out DataTable dt )
{
//int iReturn=-1;
SqlDataReader dr;
UDS.Components.Database mySQL = new UDS.Components.Database();
SqlParameter[] parameters = {
mySQL.MakeInParam("@DocID",SqlDbType.Int ,4,DocID)
};
try
{
mySQL.RunProc("sp_Flow_GetDocumentInfo",parameters,out dr);
dt =UDS.Components.Tools.ConvertDataReaderToDataTable(dr);
}
catch(Exception e)
{
dt = null;
Error.Log(e.ToString());
}
finally
{
mySQL.Close();
mySQL = null;
}
return 0;
}
#endregion
#region 獲得步驟成員,返回表格
/// <summary>
/// 獲得環(huán)節(jié)成員,返回表格
/// </summary>
/// <param name="FlowID">流程ID</param>
/// <param name="StepID">步驟ID</param>
/// <param name="dt">返回表格</param>
public int GetStaffInStep(long FlowID,long StepID,out DataTable dt )
{
//int iReturn=-1;
SqlDataReader dr;
UDS.Components.Database mySQL = new UDS.Components.Database();
SqlParameter[] parameters = {
mySQL.MakeInParam("@FlowID",SqlDbType.Int ,4,FlowID),
mySQL.MakeInParam("@StepID",SqlDbType.Int ,4,StepID)
};
try
{
mySQL.RunProc("sp_Flow_GetStaffInStep",parameters,out dr);
dt = UDS.Components.Tools.ConvertDataReaderToDataTable(dr);
}
catch(Exception e)
{
Error.Log(e.ToString());
dt = null;
}
finally
{
mySQL.Close();
mySQL = null;
}
return 0;
}
#endregion
#region 獲得步驟成員,返回表格
/// <summary>
/// 獲得環(huán)節(jié)成員,返回表格
/// </summary>
/// <param name="DocID">文檔ID</param>
/// <param name="dt">返回表格</param>
public int GetStaffInStep(long DocID,out DataTable dt )
{
//int iReturn=-1;
SqlDataReader dr;
UDS.Components.Database mySQL = new UDS.Components.Database();
SqlParameter[] parameters = {
mySQL.MakeInParam("@DocID",SqlDbType.Int ,4,DocID)
};
try
{
mySQL.RunProc("sp_Flow_GetStaffInStep_Ex",parameters,out dr);
dt = UDS.Components.Tools.ConvertDataReaderToDataTable(dr);
}
catch(Exception e)
{
Error.Log(e.ToString());
dt = null;
}
finally
{
mySQL.Close();
mySQL = null;
}
return 0;
}
#endregion
#region 獲得步驟接受人員,返回表格
/// <summary>
/// 獲得步驟接受人員,返回表格
/// </summary>
/// <param name="DocID">文檔ID</param>
/// <param name="dt">返回表格</param>
public int GetReceiver(long DocID,out DataTable dt )
{
//int iReturn=-1;
SqlDataReader dr;
UDS.Components.Database mySQL = new UDS.Components.Database();
SqlParameter[] parameters = {
mySQL.MakeInParam("@DocID",SqlDbType.Int ,4,DocID)
};
try
{
mySQL.RunProc("sp_Flow_GetReceiver",parameters,out dr);
dt = UDS.Components.Tools.ConvertDataReaderToDataTable(dr);
}
catch(Exception e)
{
Error.Log(e.ToString());
dt = null;
}
finally
{
mySQL.Close();
mySQL = null;
}
return 0;
}
#endregion
#region 獲得步驟已經(jīng)簽收人員,返回表格
/// <summary>
/// 獲得步驟已經(jīng)簽收人員,返回表格
/// </summary>
/// <param name="DocID">文檔ID</param>
/// <param name="dt">返回表格</param>
public int GetSignIner(long DocID,out DataTable dt )
{
//int iReturn=-1;
SqlDataReader dr;
UDS.Components.Database mySQL = new UDS.Components.Database();
SqlParameter[] parameters = {
mySQL.MakeInParam("@DocID",SqlDbType.Int ,4,DocID)
};
try
{
mySQL.RunProc("sp_Flow_GetSignIner",parameters,out dr);
dt = UDS.Components.Tools.ConvertDataReaderToDataTable(dr);
}
catch(Exception e)
{
Error.Log(e.ToString());
dt = null;
}
finally
{
mySQL.Close();
mySQL = null;
}
return 0;
}
#endregion
#region 獲得步驟未簽收人員,返回表格
/// <summary>
/// 獲得步驟未簽收人員,返回表格
/// </summary>
/// <param name="DocID">文檔ID</param>
/// <param name="dt">返回表格</param>
public int GetUnSignIner(long DocID,out DataTable dt )
{
//int iReturn=-1;
SqlDataReader dr;
UDS.Components.Database mySQL = new UDS.Components.Database();
SqlParameter[] parameters = {
mySQL.MakeInParam("@DocID",SqlDbType.Int ,4,DocID)
};
try
{
mySQL.RunProc("sp_Flow_GetUnSignIner",parameters,out dr);
dt = UDS.Components.Tools.ConvertDataReaderToDataTable(dr);
}
catch(Exception e)
{
Error.Log(e.ToString());
dt = null;
}
finally
{
mySQL.Close();
mySQL = null;
}
return 0;
}
#endregion
#region 獲得步驟已經(jīng)批閱人員,返回表格
/// <summary>
/// 獲得步驟已經(jīng)批閱人員,返回表格
/// </summary>
/// <param name="DocID">文檔ID</param>
/// <param name="dt">返回表格</param>
public int GetPostiler(long DocID,out DataTable dt )
{
//int iReturn=-1;
SqlDataReader dr;
UDS.Components.Database mySQL = new UDS.Components.Database();
SqlParameter[] parameters = {
mySQL.MakeInParam("@DocID",SqlDbType.Int ,4,DocID)
};
try
{
mySQL.RunProc("sp_Flow_GetPostiler",parameters,out dr);
dt = UDS.Components.Tools.ConvertDataReaderToDataTable(dr);
}
catch(Exception e)
{
Error.Log(e.ToString());
dt = null;
}
finally
{
mySQL.Close();
mySQL = null;
}
return 0;
}
#endregion
#region 獲得流程頭信息,返回表格
/// <summary獲得流程頭信息
/// 獲得環(huán)節(jié)已經(jīng)批閱人員,返回表格
/// </summary>
/// <param name="FlowID">流程ID</param>
/// <param name="dt">返回表格</param>
public string GetStyleHeadline(long FlowID)
{
string str="";
SqlDataReader dr;
UDS.Components.Database mySQL = new UDS.Components.Database();
SqlParameter[] parameters = {
mySQL.MakeInParam("@FlowID",SqlDbType.Int ,4,FlowID)
};
try
{
mySQL.RunProc("sp_Flow_GetStyleHead",parameters,out dr);
if(dr.Read())
{
str = dr["Flow_Name"].ToString() + "(流水號:" + string.Format(dr["Times"].ToString(),"03d") + ")";
}
}
catch(Exception e)
{
Error.Log(e.ToString());
}
finally
{
mySQL.Close();
mySQL = null;
}
return str;
}
#endregion
#region 獲得文檔的附件,返回表格
/// <summary>
/// 獲得文檔的附件,返回表格
/// </summary>
/// <param name="DocID">文檔ID</param>
/// <param name="dt">返回表格</param>
public int GetDocumentAttach(long DocID,out DataTable dt)
{
SqlDataReader dr;
UDS.Components.Database mySQL = new UDS.Components.Database();
SqlParameter[] parameters = {
mySQL.MakeInParam("@DocID",SqlDbType.Int ,4,DocID)
};
try
{
mySQL.RunProc("sp_Flow_GetDocumentAttach",parameters,out dr);
dt = UDS.Components.Tools.ConvertDataReaderToDataTable(dr);
}
catch(Exception e)
{
Error.Log(e.ToString());
throw new Exception("獲得公文的附件出錯！",e);
}
finally
{
mySQL.Close();
mySQL = null;
}
return 0;
}
#endregion
#region 添加公文附件數(shù)據(jù)庫
/// <summary>
/// 添加文件附件數(shù)據(jù)庫操作
/// </summary>
/// <param name="att">DocAttachFile類</param>
/// <param name="DocID">文件ID</param>
public void AddAttach(UDS.Components.DocAttachFile att,long DocID)
{
UDS.Components.Database data = new UDS.Components.Database();
SqlParameter[] prams = {
data.MakeInParam("@DocID", SqlDbType.Int, 20, DocID),
data.MakeInParam("@FileName", SqlDbType.VarChar, 300, att.FileName),
data.MakeInParam("@FileSize", SqlDbType.Int, 20, att.FileSize),
data.MakeInParam("@FileAttribute", SqlDbType.SmallInt,20, att.FileAttribute),
data.MakeInParam("@FileVisualPath", SqlDbType.NVarChar, 200, att.FileVisualPath),
data.MakeInParam("@FileAuthor", SqlDbType.NVarChar, 50, att.FileAuthor),
data.MakeInParam("@FileCatlog", SqlDbType.NVarChar, 20, att.FileCatlog),
data.MakeInParam("@FileAddedDate", SqlDbType.DateTime, 30, DateTime.Parse(att.FileAddedDate))
};
try
{
data.RunProc("sp_Flow_AddFile", prams);
}
catch (Exception ex)
{
Error.Log(ex.ToString());
throw new Exception("文件附件發(fā)送出錯!",ex);
}
}
#endregion
#region 刪除公文附件數(shù)據(jù)庫
/// <summary>
/// 刪除文件附件數(shù)據(jù)庫操作
/// </summary>
/// <param name="DocID">文件ID</param>
public void DeleteAttach(long DocID)
{
UDS.Components.Database data = new UDS.Components.Database();
SqlParameter[] prams = {
data.MakeInParam("@DocID", SqlDbType.Int, 20, DocID)
};
try
{
data.RunProc("sp_Flow_DeleteFile", prams);
}
catch (Exception ex)
{
Error.Log(ex.ToString());
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -