?? documentflow.cs
字號:
throw new Exception("文件附件刪除出錯!",ex);
}
}
#endregion
#region 獲得公文附件名
/// <summary>
/// 獲得公文附件名
/// </summary>
/// <param name="DocID">文件ID</param>
public string GetAttachName(long DocID)
{
string AttachName="";
UDS.Components.Database data = new UDS.Components.Database();
SqlDataReader dr = null;
SqlParameter[] prams = {
data.MakeInParam("@DocID", SqlDbType.Int, 20, DocID)
};
try
{
data.RunProc("sp_Flow_GetDocumentAttach", prams,out dr);
if(dr.Read())
AttachName = dr["FileVisualPath"].ToString() + dr["FileName"].ToString();
}
catch (Exception ex)
{
Error.Log(ex.ToString());
throw new Exception("獲得文件附出錯!",ex);
}
finally
{
dr.Close();
dr = null;
data = null;
}
return AttachName;
}
#endregion
#region 添加公文批注附件數據庫
/// <summary>
/// 添加文件批注附件數據庫操作
/// </summary>
/// <param name="att">DocAttachFile類</param>
/// <param name="DocID">文件ID</param>
public void AddPostilAttach(UDS.Components.DocAttachFile att,long PostilID)
{
UDS.Components.Database data = new UDS.Components.Database();
SqlParameter[] prams = {
data.MakeInParam("@PostilID", SqlDbType.Int, 20, PostilID),
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_AddPostilFile", prams);
}
catch (Exception ex)
{
Error.Log(ex.ToString());
throw new Exception("文件附件發送出錯!",ex);
}
}
#endregion
#region 獲得文檔的所在項目ID
/// <summary>
/// 獲得文檔的所在項目ID
/// </summary>
/// <param name="DocID">文檔ID</param>
public static int GetDocumentProjectID(long DocID)
{
int iReturn=0;
UDS.Components.Database mySQL = new UDS.Components.Database();
SqlParameter[] parameters = {
mySQL.MakeInParam("@DocID",SqlDbType.Int ,4,DocID)
};
try
{
iReturn = mySQL.RunProc("sp_Flow_GetDocumentProjectID",parameters);
}
catch(Exception e)
{
Error.Log(e.ToString());
throw new Exception("獲得公文的項目ID出錯！",e);
}
finally
{
mySQL.Close();
mySQL = null;
}
return iReturn;
}
#endregion
#region 獲得是否按照項目流轉
/// <summary>
/// 獲得是否按照項目流轉ID
/// </summary>
/// <param name="UserName">用戶名</param>
/// <param name="DocID">文檔ID</param>
public bool IsProject(string UserName,long DocID)
{
bool iReturn = false;
SqlDataReader dr;
UDS.Components.Database mySQL = new UDS.Components.Database();
SqlParameter[] parameters = {
mySQL.MakeInParam("@StaffName",SqlDbType.VarChar,100,UserName),
mySQL.MakeInParam("@DocID",SqlDbType.Int ,4,DocID)
};
try
{
mySQL.RunProc("sp_Flow_GetPrePostInfo",parameters,out dr);
if(dr.Read())
{
if(dr["Flow_Rule"].ToString()=="2")
iReturn = true;
}
dr.Close();
dr = null;
}
catch(Exception e)
{
Error.Log(e.ToString());
throw new Exception("獲得是否按照項目流轉出錯！",e);
}
finally
{
mySQL.Close();
mySQL = null;
}
return iReturn;
}
#endregion
/////////////////////////////////////////////
/// 流程自定義表單
/////////////////////////////////////////////
#region 添加自定義風格表格
/// <summary>
/// 添加自定義風格表格
/// </summary>
/// <param name="StyleName">風格名</param>
/// <param name="StyleRemark">簡介ID</param>
/// <param name="Teamplate">模板路徑</param>
public int AddStyle(string StyleName,string StyleRemark,string Teamplate)
{
int iReturn=-1;
UDS.Components.Database mySQL = new UDS.Components.Database();
SqlParameter[] parameters = {
mySQL.MakeInParam("@StyleName",SqlDbType.VarChar,100,StyleName),
mySQL.MakeInParam("@StyleRemark",SqlDbType.VarChar,100,StyleRemark),
mySQL.MakeInParam("@Teamplate",SqlDbType.VarChar,100,Teamplate)
};
try
{
iReturn = mySQL.RunProc("sp_Flow_AddStyle",parameters);
}
catch(Exception e)
{
Error.Log(e.ToString());
}
finally
{
mySQL.Close();
mySQL = null;
}
return iReturn;
}
#endregion
#region 刪除自定義風格表格
/// <summary>
/// 刪除自定義風格表格
/// </summary>
/// <param name="StyleID">風格ID</param>
public int DeleteStyle(long StyleID,string Path)
{
int iReturn=-1;
UDS.Components.Database mySQL = new UDS.Components.Database();
SqlParameter[] parameters = {
mySQL.MakeInParam("@StyleID",SqlDbType.Int,4,StyleID)
};
try
{
DeleteTemplate(StyleID,Path); //刪除模板實體
iReturn = mySQL.RunProc("sp_Flow_DeleteStyle",parameters);
}
catch(Exception e)
{
Error.Log(e.ToString());
}
finally
{
mySQL.Close();
mySQL = null;
}
return iReturn;
}
#endregion
#region 修改自定義風格表格
/// <summary>
/// 修改自定義風格表格
/// </summary>
/// <param name="StyleID">風格ID</param>
/// <param name="StyleName">風格名</param>
/// <param name="StyleRemark">簡介ID</param>
/// <param name="Teamplate">模板路徑</param>
public int UpdateStyle(long StyleID,string StyleName,string StyleRemark,string Teamplate,string Path)
{
int iReturn=-1;
UDS.Components.Database mySQL = new UDS.Components.Database();
SqlParameter[] parameters = {
mySQL.MakeInParam("@StyleID",SqlDbType.Int,4,StyleID),
mySQL.MakeInParam("@StyleName",SqlDbType.VarChar,100,StyleName),
mySQL.MakeInParam("@StyleRemark",SqlDbType.VarChar,100,StyleRemark),
mySQL.MakeInParam("@Teamplate",SqlDbType.VarChar,100,Teamplate)
};
try
{
DeleteTemplate(StyleID,Path);
iReturn = mySQL.RunProc("sp_Flow_UpdateStyle",parameters);
}
catch(Exception e)
{
Error.Log(e.ToString());
}
finally
{
mySQL.Close();
mySQL = null;
}
return iReturn;
}
#endregion
#region 添加自定義風格詳細定義
/// <summary>
/// 添加自定義風格詳細定義
/// </summary>
/// <param name="StyleID">風格表格ID</param>
/// <param name="FieldName">幫定字段名</param>
/// <param name="FieldDescription">字段意義</param>
/// <param name="Judged">是否作為條件判斷字段</param>
/// <param name="MultiLine">是否多行</param>
/// <param name="Height">控件高度</param>
/// <param name="Width">控件寬</param>
/// <param name="Position">控件在表單中的位置</param>
/// <param name="Example">填表示例</param>
public int AddStyleDescription(long StyleID,string FieldName,string FieldDescription,int Judged,int MultiLine,int Height,int Width,int Position,string Example)
{
int iReturn=-1;
UDS.Components.Database mySQL = new UDS.Components.Database();
SqlParameter[] parameters = {
mySQL.MakeInParam("@StyleID",SqlDbType.Int,4,StyleID),
mySQL.MakeInParam("@FieldName",SqlDbType.VarChar,100,FieldName),
mySQL.MakeInParam("@FieldDescription",SqlDbType.VarChar,100,FieldDescription),
mySQL.MakeInParam("@Judged",SqlDbType.Int,4,Judged),
mySQL.MakeInParam("@MultiLine",SqlDbType.Int,4,MultiLine),
mySQL.MakeInParam("@Height",SqlDbType.Int,4,Height),
mySQL.MakeInParam("@Width",SqlDbType.Int,4,Width),
mySQL.MakeInParam("@Position",SqlDbType.Int,4,Position),
mySQL.MakeInParam("@Example",SqlDbType.VarChar,100,Example)
};
try
{
iReturn = mySQL.RunProc("sp_Flow_AddStyle_Description",parameters);
}
catch(Exception e)
{
Error.Log(e.ToString());
}
finally
{
mySQL.Close();
mySQL = null;
}
return iReturn;
}
#endregion
#region 刪除自定義風格表格詳細定義
/// <summary>
/// 刪除自定義風格表格詳細定義，一行定義表示一個控件
/// </summary>
/// <param name="DescriptionID">風格詳細定義ID</param>
public int DeleteStyleDescription(long DescriptionID)
{
int iReturn=-1;
UDS.Components.Database mySQL = new UDS.Components.Database();
SqlParameter[] parameters = {
mySQL.MakeInParam("@DescriptionID",SqlDbType.Int,4,DescriptionID)
};
try
{
iReturn = mySQL.RunProc("sp_Flow_DeleteStyle_Description",parameters);
}
catch(Exception e)
{
Error.Log(e.ToString());
}
finally
{
mySQL.Close();
mySQL = null;
}
return iReturn;
}
#endregion
#region 修改自定義風格詳細定義
/// <summary>
/// 修改自定義風格詳細定義
/// </summary>
/// <param name="DescriptionID">風格詳細定義ID</param>
/// <param name="StyleID">風格表格ID</param>
/// <param name="FieldName">幫定字段名</param>
/// <param name="FieldDescription">字段意義</param>
/// <param name="Judged">是否作為條件判斷字段</param>
/// <param name="MultiLine">是否多行</param>
/// <param name="Height">控件高度</param>
/// <param name="Width">控件寬</param>
/// <param name="Position">控件在表單中的位置</param>
/// <param name="Example">填表示例</param>
public int UpdateStyleDescription(long DescriptionID,long StyleID,string FieldName,string FieldDescription,int Judged,int MultiLine,int Height,int Width,int Position,string Example)
{
int iReturn=-1;
UDS.Components.Database mySQL = new UDS.Components.Database();
SqlParameter[] parameters = {
mySQL.MakeInParam("@DescriptionID",SqlDbType.Int,4,DescriptionID),
mySQL.MakeInParam("@StyleID",SqlDbType.Int,4,StyleID),
mySQL.MakeInParam("@FieldName",SqlDbType.VarChar,100,FieldName),
mySQL.MakeInParam("@FieldDescription",SqlDbType.VarChar,100,FieldDescription),
mySQL.MakeInParam("@Judged",SqlDbType.Int,4,Judged),
mySQL.MakeInParam("@MultiLine",SqlDbType.Int,4,MultiLine),
mySQL.MakeInParam("@Height",SqlDbType.Int,4,Height),
mySQL.MakeInParam("@Width",SqlDbType.Int,4,Width),
mySQL.MakeInParam("@Position",SqlDbType.Int,4,Position),
mySQL.MakeInParam("@Example",SqlDbType.VarChar,100,Example)
};
try
{
iReturn = mySQL.RunProc("sp_Flow_UpdateStyle_Description",parameters);
}
catch(Exception e)
{
Error.Log(e.ToString());
}
finally
{
mySQL.Close();
mySQL = null;
}
return iReturn;
}
#endregion
#region 獲得自定義風格表格一條詳細定義
/// <summary>
/// 獲得單一樣式描述
/// </summary>
/// <param name="StyleID">流程ID</param>
/// <param name="dr">數據集合</param>
public int GetDescription(long DescriptionID,out SqlDataReader dr )
{
//int iReturn=-1;
dr = null;
UDS.Components.Database mySQL = new UDS.Components.Database();
SqlParameter[] parameters = {
mySQL.MakeInParam("@DescriptionID",SqlDbType.Int ,4,DescriptionID)
};
try
{
mySQL.RunProc("sp_Flow_GetDescription",parameters,out dr);
}
catch(Exception ex)
{
Error.Log(ex.ToString());
}
finally
{
//mySQL.Close();
//mySQL = null;
}
return 0;
}
#endregion
#region 通過流程ID得到流程模板名
/// <summary>
/// 通過流程ID得到流程模板名
/// </summary>
/// <param name="FlowID">流程ID</param>
public string GetStyleTemplate(long FlowID)
{
string str="";
UDS.Components.Database mySQL = new UDS.Components.Database();
SqlParameter[] parameters = {
mySQL.MakeInParam("@FlowID",SqlDbType.Int ,4,FlowID),
mySQL.MakeOutParam("@Template",SqlDbType.VarChar,100)
};
try
{
mySQL.RunProc("sp_Flow_GetStyleTemplate",parameters);
str = parameters[1].Value.ToString();
}
catch(Exception e)
{
Error.Log(e.ToString());
throw new Exception("獲得表格模板錯誤!",e);
}
finally
{
mySQL.Close();
mySQL = null;
}
if(str.Length>0)
return @"Template\" + str;
else
return "";
}
#endregion
#region 通過表單ID得到流程模板名
/// <summary>
/// 通過表單ID得到流程模板名
/// </summary>
/// <param name="FlowID">流程ID</param>
public string GetStyleTemplateEx(long StyleID)
{
string str="";
UDS.Components.Database mySQL = new UDS.Components.Database();
SqlParameter[] parameters = {
mySQL.MakeInParam("@StyleID",SqlDbType.Int ,4,StyleID),
mySQL.MakeOutParam("@Template",SqlDbType.VarChar,100)
};
try
{
mySQL.RunProc("sp_Flow_GetStyleTemplateEx",parameters);
str = parameters[1].Value.ToString();
}
catch(Exception e)
{
Error.Log(e.ToString());
throw new Exception("獲得表格模板錯誤!",e);
}
finally
{
mySQL.Close();
mySQL = null;
}
if(str.Length>0)
return @"Template\" + str;
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -