/// <summary>
/// 编写日期：2010-3-2
/// 编写人：JW
/// </summary>
public Detail_OA_DAYARRANGE GetDetail(string ArrangeGuid)
{
Database db = DatabaseFactory.CreateDatabase(ArrangeConnStr);
string strSql = (db.DbProviderFactory.ToString() != "System.Data.OracleClient.OracleClientFactory") ?
"SELECT * FROM OA_DAYARRANGE WHERE ARRANGEGUID=@ARRANGEGUID" :
"SELECT * FROM OA_DAYARRANGE WHERE ARRANGEGUID=:ARRANGEGUID";
DbCommand cmd = db.GetSqlStringCommand(strSql);
db.AddInParameter(cmd, "ARRANGEGUID", DbType.String, ArrangeGuid);
Detail_OA_DAYARRANGE myDetail = new Detail_OA_DAYARRANGE();
using (IDataReader myReader = db.ExecuteReader(cmd))
{
if (myReader.Read())
{
if (!Convert.IsDBNull(myReader["ARRANGEGUID"]))
{
myDetail.ARRANGEGUID = Convert.ToString(myReader["ARRANGEGUID"]);
}
if (!Convert.IsDBNull(myReader["USERGUID"]))
{
myDetail.USERGUID = Convert.ToString(myReader["USERGUID"]);
}
if (!Convert.IsDBNull(myReader["USERNAME"]))
{
myDetail.USERNAME = Convert.ToString(myReader["USERNAME"]);
}
if (!Convert.IsDBNull(myReader["TIMEFROM"]))
{
myDetail.TIMEFROM = Convert.ToDateTime(myReader["TIMEFROM"]);
}
if (!Convert.IsDBNull(myReader["TIMETO"]))
{
myDetail.TIMETO = Convert.ToDateTime(myReader["TIMETO"]);
}
if (!Convert.IsDBNull(myReader["ARRANGETITLE"]))
{
myDetail.ARRANGETITLE = Convert.ToString(myReader["ARRANGETITLE"]);
}
if (!Convert.IsDBNull(myReader["ARRANGEINFO"]))
{
myDetail.ARRANGEINFO = Convert.ToString(myReader["ARRANGEINFO"]);
}
if (!Convert.IsDBNull(myReader["ISREMINED"]))
{
myDetail.ISREMINED = Convert.ToString(myReader["ISREMINED"]);
}
if (!Convert.IsDBNull(myReader["AHEADMINUTES"]))
{
myDetail.AHEADMINUTES = Convert.ToInt32(myReader["AHEADMINUTES"]);
}
if (!Convert.IsDBNull(myReader["ISOPEN"]))
{
myDetail.ISOPEN = Convert.ToString(myReader["ISOPEN"]);
}
}
}
return myDetail;
}
/// <summary>
/// 获取提醒信息
/// </summary>
/// <param name="UserGuid"></param>
/// <returns></returns>
public List<Detail_OA_DAYARRANGE> SelectArrangeForNote(string UserGuid)
{
Database db = DatabaseFactory.CreateDatabase(ArrangeConnStr);
DateTime Dt = DateTime.Now;
string strSql = "SELECT * FROM OA_DAYARRANGE WHERE USERGUID='" + UserGuid + "' AND ISREMINED='Y' AND HASREMINED<>'Y' AND :Dt+ AHEADMINUTES/24/60 > TIMEFROM AND :Dt+ AHEADMINUTES/24/60 < TIMETO";
DbCommand cmd = db.GetSqlStringCommand(strSql);
db.AddInParameter(cmd, "Dt", DbType.DateTime, Dt);
DataView dv = db.ExecuteDataView(cmd);
List<Detail_OA_DAYARRANGE> DODList = new List<Detail_OA_DAYARRANGE>();
for (int i = 0; i < dv.Count; i++)
{
Detail_OA_DAYARRANGE DOD = new Detail_OA_DAYARRANGE();
DOD.ARRANGETITLE = dv[i]["ARRANGETITLE"].ToString();
DOD.ARRANGEGUID = dv[i]["ARRANGEGUID"].ToString();
DOD.TIMEFROM = Convert.ToDateTime(dv[i]["TIMEFROM"]);
DOD.TIMETO = Convert.ToDateTime(dv[i]["TIMETO"]);
DODList.Add(DOD);
}
return DODList;
}
private void InitArrangeInfo()
{
string ArrangeGuid = Request.QueryString["Guid"].ToString();
DADetail = AddDB.GetDetail(ArrangeGuid);
this.txtTitle.Text = DADetail.ARRANGETITLE;
this.dtxDate.Text = DADetail.TIMEFROM.ToString("yyyy-MM-dd");
this.txtTimeFromH.Text = DADetail.TIMEFROM.Hour.ToString();
this.txtTimeFromM.Text = DADetail.TIMEFROM.Minute.ToString();
this.txtTimeToH.Text = DADetail.TIMETO.Hour.ToString();
this.txtTimeToM.Text = DADetail.TIMETO.Minute.ToString();
chbOpen.Checked = DADetail.ISOPEN == "Y";
chbRemind.Checked = DADetail.ISREMINED == "Y";
this.ntbAheadMinutes.Text = DADetail.AHEADMINUTES.ToString();
this.txtInfo.Text = DADetail.ARRANGEINFO;
if (chbRemind.Checked)
{
tdAhead.Style.Add("display", "");
}
else
{
tdAhead.Style.Add("display", "none");
}
}
