PublicModule(2)
// 執行查詢語句
public DataSet ExecuteQuerySql(string strsql)
{
try
{
DataSet ds = new DataSet();
this.myConn = new SqlConnection( ePO_CONNECTSTRING );
this.myCommand= new SqlCommand( strsql, this.myConn );
this.myConn.Open();
SqlDataAdapter ada = new SqlDataAdapter( this.myCommand );
ada.Fill( ds );
return ds;
}
catch( System.Exception err )
{
SaveLog( err.Message );
return null;
}
finally
{
this.myConn.Close();
}
}
#endregion ---- DataBase Operation ----------------------------------------
public struct MailStruct
{
/// <summary>
/// 消息名稱，系統會將消息名稱相同的匯總
/// </summary>
public struct Notification
{
/// <summary>
/// 發送給待辦理人員簽核通知
/// </summary>
public const string ToBeSign = "簽核通知";
/// <summary>
/// 發送單證被退回通知
/// </summary>
public const string BeRejected = "退件通知";
/// <summary>
/// 發送給原辦理人員,單證已由其代理人辦理
/// </summary>
public const string BeenProcessedByAttorney = "代辦知悉通知";
/// <summary>
/// 發送給代理人,通知其辦理單證
/// </summary>
public const string ToBeProcessedByAttorney = "發送代理人通知";
/// <summary>
/// 發送給供應商,通知其確認單證
/// </summary>
public const string ToBeConfirmedBySupplier = "供應商確認通知";
/// <summary>
/// 發送採購窗口,通知其指派採購人員辦理
/// </summary>
public const string ToBeAssignedPurWindow = "指派採購通知";
/// <summary>
/// 批量簽核中,發送給待辦理人員簽核通知
/// </summary>
public const string BatchToBeSign = "批量簽核通知";
/// <summary>
/// 採購窗口指派採購人員後,發送採購人員下單通知
/// </summary>
public const string ToBeCreatedeVoucher = "下單通知";
/// <summary>
/// 所有單証處于催發狀態的
/// </summary>
public const string UrgeSign = "稽催通知";
}
/// <summary>
/// 遞送優先順序控制Notes 發送信件至Notes 郵件收件人的速度。
/// </summary>
public struct Priority
{
/// <summary>
/// 高 Notes 立即傳送信件。
/// </summary>
public const int High = 1;
/// <summary>
/// 一般 Notes 在下次主要伺服器傳送郵件時發送此信件。
/// </summary>
public const int Normal = 2;
/// <summary>
/// 低 Notes 等到離峰時段再傳送信件。除非Domino 管理員變更時間，
/// </summary>
public const int Low = 3;
}
/// <summary>
/// 重要性
/// 根據預設值，所有信件的重要性皆為「一般」。將信件設定為「高」重要性後，
/// 在收件人視界中的信件旁會顯示驚嘆號，而在您視界中的信件旁則會顯示一個紅
/// 色的信封。重要性並不會變更Notes 遞送信件的順序與速度。
/// </summary>
public struct Importance
{
/// <summary>
/// 高 - 收件人視界中的信件旁會顯示驚嘆號
/// </summary>
public const int High = 1;
/// <summary>
/// 一般 - 預設值
/// </summary>
public const int Normal = 2;
/// <summary>
/// 低
/// </summary>
public const int Low = 3;
}
/// <summary>
/// 顯示給收信者之發信人名稱
/// </summary>
public const string SendFrom = "eVoucher 消息通知";
/// <summary>
/// 郵件內容之HTML標籤
/// </summary>
public const string TagBodyHtml = @"<html><head><title></title>
<style>body {background-color: #FFFFCC; font-size: 12px;}
body, td, th, h3, h6 {color: #330000;}
h1, h2, h4, h5 {color: #660000;}a {color: #003366;}
.name {font-size: 14px;font-weight: bold;color: #0000FF;}
</style></head><body>";
/// <summary>
/// 郵件內容之HTML結尾標籤
/// </summary>
public const string EndTagBodyHtml = "</body></html>";
}
}
}
浙公网安备 33010602011771号