/// <summary> /// 获得某条任务的详细信息 /// </summary> public TaskClass GetTaskDetail(int TaskID) { // 定义数据库操作类及DataReader Database data = new Database(); SqlDataReader dataReader = null; TaskClass tsk = new TaskClass(); // 执行存储过程,并返回SqlDataReader对象 SqlParameter[] prams = { data.MakeInParam("@TaskID", SqlDbType.Int, 8, TaskID) }; try { data.RunProc("sp_GetTaskDetail", prams, out dataReader); if (dataReader.Read()) { tsk.ArrangedBy = dataReader["ArrangedBy"].ToString(); tsk.Detail = dataReader["Detail"].ToString(); tsk.StartTime = dataReader["StartTime"].ToString(); tsk.EndTime = dataReader["EndTime"].ToString(); tsk.ProjectID = Int32.Parse(dataReader["ProjectID"].ToString()); tsk.Subject = dataReader["Subject"].ToString(); tsk.CooperatorList = dataReader["CooperatorList"].ToString(); tsk.Type = Int32.Parse(dataReader["Type"].ToString()); tsk.Attribute = dataReader["Attribute"].ToString() == "True"?1:0; tsk.ContractList = dataReader["ContractList"].ToString(); } dataReader = null; data.Dispose(); return(tsk); } catch (Exception ex) { Error.Log(ex.ToString()); throw new Exception("获得某条任务某天的的时间段出错!", ex); } finally { data.Dispose(); dataReader = null; } }
/// <summary> /// 任务添加 /// </summary> /// <param name="TaskClass">Task类</param> public string AddTask(TaskClass tc) { // create data object and params Database data = new Database(); string TaskID = ""; SqlParameter[] prams = { data.MakeInParam("@ArrangedBy", SqlDbType.VarChar, 20, tc.ArrangedBy), data.MakeInParam("@Subject", SqlDbType.VarChar, 50, tc.Subject), data.MakeInParam("@Detail", SqlDbType.VarChar, 300, tc.Detail), data.MakeInParam("@ProjectID", SqlDbType.SmallInt, 20, tc.ProjectID), data.MakeInParam("@StartTime", SqlDbType.DateTime, 20, DateTime.Parse(tc.StartTime.ToString())), data.MakeInParam("@EndTime", SqlDbType.DateTime, 20, DateTime.Parse(tc.EndTime.ToString())), data.MakeInParam("@Attribute", SqlDbType.Int, 1, tc.Attribute), data.MakeInParam("@Type", SqlDbType.Int, 1, tc.Type), data.MakeInParam("@Status", SqlDbType.Bit, 1, tc.Status), data.MakeInParam("@Tag", SqlDbType.Int, 1, tc.Tag), data.MakeInParam("@IsAwake", SqlDbType.Bit, 1, tc.IsAwake), data.MakeInParam("@AwakeTime", SqlDbType.DateTime, 20, DateTime.Parse(tc.AwakeTime)), data.MakeInParam("@ContractList", SqlDbType.NVarChar, 6000, tc.ContractList), data.MakeInParam("@CooperatorList", SqlDbType.NVarChar, 6000, tc.CooperatorList), data.MakeOutParam("@InsertedTaskID", SqlDbType.Int, 20) }; try { data.RunProc("SP_AddTask", prams); TaskID = prams[14].Value.ToString(); if (TaskID == string.Empty) { return(null); } else { return(TaskID); } } catch (Exception ex) { Error.Log(ex.ToString()); throw new Exception("任务添加出错!", ex); } }
/// <summary> /// ������� /// </summary> /// <param name="TaskClass">Task��</param> public string AddTask(TaskClass tc) { // create data object and params Database data = new Database(); string TaskID = ""; SqlParameter[] prams = { data.MakeInParam("@ArrangedBy", SqlDbType.VarChar, 20, tc.ArrangedBy), data.MakeInParam("@Subject", SqlDbType.VarChar, 50, tc.Subject), data.MakeInParam("@Detail", SqlDbType.VarChar, 300, tc.Detail), data.MakeInParam("@ProjectID", SqlDbType.SmallInt,20, tc.ProjectID), data.MakeInParam("@StartTime", SqlDbType.DateTime, 20, DateTime.Parse(tc.StartTime.ToString())), data.MakeInParam("@EndTime", SqlDbType.DateTime, 20, DateTime.Parse(tc.EndTime.ToString())), data.MakeInParam("@Attribute", SqlDbType.Int, 1, tc.Attribute), data.MakeInParam("@Type", SqlDbType.Int, 1, tc.Type), data.MakeInParam("@Status", SqlDbType.Bit , 1, tc.Status), data.MakeInParam("@Tag", SqlDbType.Int, 1, tc.Tag), data.MakeInParam("@IsAwake", SqlDbType.Bit, 1, tc.IsAwake), data.MakeInParam("@AwakeTime", SqlDbType.DateTime, 20, DateTime.Parse(tc.AwakeTime)), data.MakeInParam("@ContractList", SqlDbType.VarChar, 50, tc.ContractList), data.MakeInParam("@CooperatorList", SqlDbType.VarChar, 200, tc.CooperatorList), data.MakeOutParam("@InsertedTaskID", SqlDbType.Int,20) }; try { data.RunProc("SP_AddTask", prams); TaskID = prams[14].Value.ToString(); if (TaskID == string.Empty ) return null; else return TaskID; } catch (Exception ex) { Error.Log(ex.ToString()); throw new Exception("������ӳ���!",ex); } }
private void PopulateData(TaskClass tsk) { // string Type=""; // // switch (tsk.Type) // { // case 1: // Type="����"; // break; // case 2: // Type="�İ�"; // break; // case 3: // Type="����"; // break; // case 4: // Type="�绰"; // break; // case 5: // Type="�߷�"; // break; // case 6: // Type="���"; // break; // case 7: // Type="����"; // break; // case 8: // Type="����"; // break; // // } // this.lblArrangedBy .Text = UDS.Components .Staff.GetRealNameByUsername(tsk.ArrangedBy) ; //this.lblCooperator .Text = tsk.CooperatorList ; }
private TaskClass ProcessFormPost() { TaskClass tc = new TaskClass(); tc.ArrangedBy = Username; tc.Detail = this.txtDetail.Text.ToString(); tc.Type = Int32.Parse(this.rbType.SelectedItem.Value.ToString()); tc.Attribute = Int32.Parse(this.rbAttribute.SelectedItem.Value.ToString()); tc.Subject = this.txtSubject.Text.ToString(); tc.ProjectID = Request.Form["hdnProjectID"].ToString() != "" ? Int32.Parse(Request.Form["hdnProjectID"].ToString()) : 0; tc.StartTime = this.txtBeginDate.Text.ToString() + " " + ((this.cbIsAllDay.Checked) ? "" : this.listBeginTime.SelectedItem.Text.ToString()); tc.EndTime = this.txtEndDate.Text.ToString() + " " + ((this.cbIsAllDay.Checked) ? "" : this.listEndTime.SelectedItem.Text.ToString()); tc.AwakeTime = DateTime.Parse(tc.EndTime).AddMinutes(-10).ToString(); tc.Tag = 0; tc.ContractList = ""; tc.CooperatorList = UnameStr; // foreach(ListItem i in this.listCooperator .Items) // if(i.Selected == true) // tc.CooperatorList+= i.Value.ToString()+","; return tc; }
private void PopulateData(TaskClass tsk) { string ClassName = "",Type=""; switch (tsk.Type) { case 1: Type="����"; break; case 2: Type="�İ�"; break; case 3: Type="����"; break; case 4: Type="�绰"; break; case 5: Type="�߷�"; break; case 6: Type="���"; break; case 7: Type="����"; break; case 8: Type="����"; break; } this.lblSubject .Text = tsk.Subject ; this.lblDetail .Text = tsk.Detail ; this.lblStartTime .Text = (DateTime.Parse(tsk.StartTime).ToShortTimeString()=="0:00")?DateTime.Parse(tsk.StartTime).ToShortDateString()+" 8:00":tsk.StartTime; this.lblEndTime .Text = (DateTime.Parse(tsk.EndTime).ToShortTimeString()=="0:00")?DateTime.Parse(tsk.EndTime).ToShortDateString()+" 18:00":tsk.EndTime; this.lblArrangedBy .Text = UDS.Components .Staff.GetRealNameByUsername(tsk.ArrangedBy) ; this.lblCooperator .Text = UDS.Components .Staff.GetRealNameStrByUsernameStr(tsk.CooperatorList,0) ; this.lblType.Text = Type; this.lblAttribute.Text = tsk.Attribute.ToString()=="1"?"��ռ����":"��ʱ����"; if(tsk.ProjectID!=0) { ProjectClass prj = new ProjectClass(); SqlDataReader dataReader = prj.GetProjectDetail(tsk.ProjectID); try { if (dataReader.Read()) ClassName = dataReader["ClassName"].ToString(); } finally { dataReader.Close(); } prj = null; } this.lblProjectID .Text = (tsk.ProjectID ==0)?"��":"<a href='#' onclick=javascript:window.close();window.dialogArguments.location='../UnitiveDocument/Project.aspx?classID="+tsk.ProjectID .ToString()+"'>"+ClassName+"</a>"; }
/// <summary> /// ���ij���������ϸ��Ϣ /// </summary> public TaskClass GetTaskDetail(int TaskID) { // �������ݿ�����༰DataReader Database data = new Database(); SqlDataReader dataReader = null; TaskClass tsk = new TaskClass(); // ִ�д洢���̣�������SqlDataReader���� SqlParameter[] prams = { data.MakeInParam("@TaskID", SqlDbType.Int,8, TaskID) }; try { data.RunProc("sp_GetTaskDetail",prams,out dataReader); if(dataReader.Read()) { tsk.ArrangedBy = dataReader["ArrangedBy"].ToString(); tsk.Detail = dataReader["Detail"].ToString(); tsk.StartTime = dataReader["StartTime"].ToString(); tsk.EndTime = dataReader["EndTime"].ToString(); tsk.ProjectID = Int32.Parse(dataReader["ProjectID"].ToString()); tsk.Subject = dataReader["Subject"].ToString(); tsk.CooperatorList = dataReader["CooperatorList"].ToString(); tsk.Type = Int32.Parse(dataReader["Type"].ToString()); tsk.Attribute = dataReader["Attribute"].ToString()=="True"?1:0; tsk.ContractList = dataReader["ContractList"].ToString(); } dataReader = null; data.Dispose(); return tsk; } catch(Exception ex) { Error.Log(ex.ToString()); throw new Exception("���ij������ij��ĵ�ʱ��γ���!",ex); } finally { if (data != null) { data.Close(); } if (dataReader != null) { dataReader.Close(); } dataReader = null; } }