?? plan.cs
字號:
using System;
using System.Data;
using System.Collections;
using MyOA.DataAccessLayer;
using MyOA.DataAccessHelper;
using MyOA.CommonComponent;
namespace MyOA.BusinessLogicLayer
{
/// <summary>
/// Plan 的摘要說明。
/// </summary>
public class Plan
{
#region 私有成員
private int _planId; //計劃安排ID
private string _loginName; //用戶登錄名
private DateTime _planDate; //計劃日期
private string _planContent; //計劃內容
private bool _exist; //是否存在標志
#endregion 私有成員
#region 屬性
public int PlanID
{
set
{
this._planId=value;
}
get
{
return this._planId;
}
}
public string LoginName
{
set
{
this._loginName=value;
}
get
{
return this._loginName;
}
}
public DateTime PlanDate
{
set
{
this._planDate=value;
}
get
{
return this._planDate;
}
}
public string PlanContent
{
set
{
this._planContent=value;
}
get
{
return this._planContent;
}
}
public bool Exist
{
get
{
return this._exist;
}
}
#endregion 屬性
#region 方法
/// <summary>
/// 根據用戶登錄名和日期,獲取計劃安排
/// </summary>
/// <param name="loginName">用戶登錄名</param>
/// <param name="planDate">日期</param>
public void LoadData(string loginName,DateTime planDate)
{
Database db=new Database(); //實例化一個Database類
string sql="";
sql="Select * from [Plan] where LoginName = "
+ SqlStringConstructor.GetQuotedString(loginName)
+" And PlanDate = "
+ SqlStringConstructor.GetQuotedString(planDate.Date.ToString());
DataRow dr=db.GetDataRow(sql); //利用Database類的GetDataRow方法查詢數據
//根據查詢得到的數據,對成員賦值
if(dr!=null)
{
this._planId=GetSafeData.ValidateDataRow_N(dr,"PlanId");
this._loginName=GetSafeData.ValidateDataRow_S(dr,"LoginName");
this._planDate=GetSafeData.ValidateDataRow_T(dr,"PlanDate");
this._planContent=GetSafeData.ValidateDataRow_S(dr,"PlanContent");
this._exist=true;
}
else
{
this._exist=false;
}
}
/// <summary>
/// 添加計劃信息
/// </summary>
/// <param name="htUserInfo">計劃信息哈希表</param>
public static void Add(Hashtable userInfo)
{
Database db=new Database(); //實例化一個Database類
db.Insert("[Plan]",userInfo ); //利用Database類的Insert方法添加數據
}
/// <summary>
/// 修改計劃信息
/// </summary>
/// <param name="planInfo">計劃信息哈希表</param>
public void Update()
{
Database db=new Database(); //實例化一個Database類
Hashtable planInfo=new Hashtable();
planInfo.Add("PlanContent",SqlStringConstructor.GetQuotedString(this._planContent));
string where=" Where PlanId="+this._planId;
db.Update("[Plan]",planInfo,where); //利用Database類的Update方法修改數據
}
#endregion 方法
}
}
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -