/// <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"); } }