/// <summary>
/// 更新一条数据
/// </summary>
public void Update(Dianda.Model.Project_Task model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update Project_Task set ");
strSql.Append("ProjectID=@ProjectID,");
strSql.Append("NAMES=@NAMES,");
strSql.Append("DELFLAG=@DELFLAG,");
strSql.Append("Status=@Status,");
strSql.Append("CompleteType=@CompleteType,");
strSql.Append("UserIDs=@UserIDs,");
strSql.Append("UserInfo=@UserInfo,");
strSql.Append("StartTime=@StartTime,");
strSql.Append("EndTime=@EndTime,");
strSql.Append("Overviews=@Overviews,");
strSql.Append("DATETIME=@DATETIME,");
strSql.Append("SendUserID=@SendUserID,");
strSql.Append("ReadTime=@ReadTime,");
strSql.Append("UpID=@UpID,");
strSql.Append("IsFather=@IsFather");
strSql.Append(" where ID=@ID ");
SqlParameter[] parameters =
{
new SqlParameter("@ID", SqlDbType.Int, 4),
new SqlParameter("@ProjectID", SqlDbType.Int, 4),
new SqlParameter("@NAMES", SqlDbType.VarChar, 50),
new SqlParameter("@DELFLAG", SqlDbType.Int, 4),
new SqlParameter("@Status", SqlDbType.Int, 4),
new SqlParameter("@CompleteType", SqlDbType.Int, 4),
new SqlParameter("@UserIDs", SqlDbType.VarChar, 5000),
new SqlParameter("@UserInfo", SqlDbType.VarChar, 5000),
new SqlParameter("@StartTime", SqlDbType.DateTime),
new SqlParameter("@EndTime", SqlDbType.DateTime),
new SqlParameter("@Overviews", SqlDbType.Text),
new SqlParameter("@DATETIME", SqlDbType.DateTime),
new SqlParameter("@SendUserID", SqlDbType.VarChar, 50),
new SqlParameter("@ReadTime", SqlDbType.DateTime),
new SqlParameter("@UpID", SqlDbType.Int, 4),
new SqlParameter("@IsFather", SqlDbType.Int, 4)
};
parameters[0].Value = model.ID;
parameters[1].Value = model.ProjectID;
parameters[2].Value = model.NAMES;
parameters[3].Value = model.DELFLAG;
parameters[4].Value = model.Status;
parameters[5].Value = model.CompleteType;
parameters[6].Value = model.UserIDs;
parameters[7].Value = model.UserInfo;
parameters[8].Value = model.StartTime;
parameters[9].Value = model.EndTime;
parameters[10].Value = model.Overviews;
parameters[11].Value = model.DATETIME;
parameters[12].Value = model.SendUserID;
parameters[13].Value = model.ReadTime;
parameters[14].Value = model.UpID;
parameters[15].Value = model.IsFather;
DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
}
/// <summary>
/// 点击删除按钮触发的事件
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void Button_delete_onclick(object sender, EventArgs e)
{
int num = 0;
int rows = GridView1.Rows.Count;
if (rows > 0)
{
for (int i = 0; i < rows; i++)
{
CheckBox cb = (CheckBox)GridView1.Rows[i].Cells[0].FindControl("CheckBox_choose");
if (cb.Checked)
{
num = num + 1;
}
}
if (num == 0)
{
tag.Text = "删除时最少选择一条数据！";
}
else
{
tag.Text = "";
for (int j = 0; j < rows; j++)
{
CheckBox cb1 = (CheckBox)GridView1.Rows[j].Cells[0].FindControl("CheckBox_choose");
HiddenField hid = (HiddenField)GridView1.Rows[j].Cells[0].FindControl("Hid_ID");
if (cb1.Checked)
{
//获取到当前任务的基本信息
task_model = task_bll.GetModel(int.Parse(hid.Value.ToString()));
//将删除标记设为1
task_model.DELFLAG = 1;
task_bll.Update(task_model);
//添加操作日志
Dianda.BLL.SYS_LogsExt bsyslog = new Dianda.BLL.SYS_LogsExt();
Model.USER_Users user_model = (Model.USER_Users)Session["USER_Users"];
bsyslog.addlogs(user_model.REALNAME + "(" + user_model.USERNAME + ")", "项目中删除任务", project_model.NAMES + "项目" + task_model.NAMES + "任务:删除成功！");
//添加操作日志
}
}
//tag.Text = "操作成功！";
//string coutws = "<script language=\"javascript\" type=\"text/javascript\">alert(\"操作成功！现在返回列表页面\"); location.href = \"manage.aspx?pageindex=" + pageindexHidden.Value.ToString() + "&ID=" + Request["ID"].ToString() + "\";</script>";
//Response.Write(coutws);
ScriptManager.RegisterStartupScript(this, this.GetType(), "ok", "<script>alert('操作成功！现在进入我的项目页面');javascript:location='manage.aspx?pageindex=" + pageindexHidden.Value.ToString() + "&ID=" + Request["ID"].ToString() + "&status=" + DDL_Status.SelectedValue + "';</script>", false);
}
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(Dianda.Model.Project_Task model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into Project_Task(");
strSql.Append("ProjectID,NAMES,DELFLAG,Status,CompleteType,UserIDs,UserInfo,StartTime,EndTime,Overviews,DATETIME,SendUserID,ReadTime,UpID,IsFather)");
strSql.Append(" values (");
strSql.Append("@ProjectID,@NAMES,@DELFLAG,@Status,@CompleteType,@UserIDs,@UserInfo,@StartTime,@EndTime,@Overviews,@DATETIME,@SendUserID,@ReadTime,@UpID,@IsFather)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters =
{
new SqlParameter("@ProjectID", SqlDbType.Int, 4),
new SqlParameter("@NAMES", SqlDbType.VarChar, 50),
new SqlParameter("@DELFLAG", SqlDbType.Int, 4),
new SqlParameter("@Status", SqlDbType.Int, 4),
new SqlParameter("@CompleteType", SqlDbType.Int, 4),
new SqlParameter("@UserIDs", SqlDbType.VarChar, 5000),
new SqlParameter("@UserInfo", SqlDbType.VarChar, 5000),
new SqlParameter("@StartTime", SqlDbType.DateTime),
new SqlParameter("@EndTime", SqlDbType.DateTime),
new SqlParameter("@Overviews", SqlDbType.Text),
new SqlParameter("@DATETIME", SqlDbType.DateTime),
new SqlParameter("@SendUserID", SqlDbType.VarChar, 50),
new SqlParameter("@ReadTime", SqlDbType.DateTime),
new SqlParameter("@UpID", SqlDbType.Int, 4),
new SqlParameter("@IsFather", SqlDbType.Int, 4)
};
parameters[0].Value = model.ProjectID;
parameters[1].Value = model.NAMES;
parameters[2].Value = model.DELFLAG;
parameters[3].Value = model.Status;
parameters[4].Value = model.CompleteType;
parameters[5].Value = model.UserIDs;
parameters[6].Value = model.UserInfo;
parameters[7].Value = model.StartTime;
parameters[8].Value = model.EndTime;
parameters[9].Value = model.Overviews;
parameters[10].Value = model.DATETIME;
parameters[11].Value = model.SendUserID;
parameters[12].Value = model.ReadTime;
parameters[13].Value = model.UpID;
parameters[14].Value = model.IsFather;
object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return(1);
}
else
{
return(Convert.ToInt32(obj));
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Dianda.Model.Project_Task GetModel(int ID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 ID,ProjectID,NAMES,DELFLAG,Status,CompleteType,UserIDs,UserInfo,StartTime,EndTime,Overviews,DATETIME,SendUserID,ReadTime,UpID,IsFather from Project_Task ");
strSql.Append(" where ID=@ID ");
SqlParameter[] parameters =
{
new SqlParameter("@ID", SqlDbType.Int, 4)
};
parameters[0].Value = ID;
Dianda.Model.Project_Task model = new Dianda.Model.Project_Task();
DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
if (ds.Tables[0].Rows[0]["ID"].ToString() != "")
{
model.ID = int.Parse(ds.Tables[0].Rows[0]["ID"].ToString());
}
if (ds.Tables[0].Rows[0]["ProjectID"].ToString() != "")
{
model.ProjectID = int.Parse(ds.Tables[0].Rows[0]["ProjectID"].ToString());
}
model.NAMES = ds.Tables[0].Rows[0]["NAMES"].ToString();
if (ds.Tables[0].Rows[0]["DELFLAG"].ToString() != "")
{
model.DELFLAG = int.Parse(ds.Tables[0].Rows[0]["DELFLAG"].ToString());
}
if (ds.Tables[0].Rows[0]["Status"].ToString() != "")
{
model.Status = int.Parse(ds.Tables[0].Rows[0]["Status"].ToString());
}
if (ds.Tables[0].Rows[0]["CompleteType"].ToString() != "")
{
model.CompleteType = int.Parse(ds.Tables[0].Rows[0]["CompleteType"].ToString());
}
model.UserIDs = ds.Tables[0].Rows[0]["UserIDs"].ToString();
model.UserInfo = ds.Tables[0].Rows[0]["UserInfo"].ToString();
if (ds.Tables[0].Rows[0]["StartTime"].ToString() != "")
{
model.StartTime = DateTime.Parse(ds.Tables[0].Rows[0]["StartTime"].ToString());
}
if (ds.Tables[0].Rows[0]["EndTime"].ToString() != "")
{
model.EndTime = DateTime.Parse(ds.Tables[0].Rows[0]["EndTime"].ToString());
}
model.Overviews = ds.Tables[0].Rows[0]["Overviews"].ToString();
if (ds.Tables[0].Rows[0]["DATETIME"].ToString() != "")
{
model.DATETIME = DateTime.Parse(ds.Tables[0].Rows[0]["DATETIME"].ToString());
}
model.SendUserID = ds.Tables[0].Rows[0]["SendUserID"].ToString();
if (ds.Tables[0].Rows[0]["ReadTime"].ToString() != "")
{
model.ReadTime = DateTime.Parse(ds.Tables[0].Rows[0]["ReadTime"].ToString());
}
if (ds.Tables[0].Rows[0]["UpID"].ToString() != "")
{
model.UpID = int.Parse(ds.Tables[0].Rows[0]["UpID"].ToString());
}
if (ds.Tables[0].Rows[0]["IsFather"].ToString() != "")
{
model.IsFather = int.Parse(ds.Tables[0].Rows[0]["IsFather"].ToString());
}
return(model);
}
else
{
return(null);
}
}
protected void ShowTaskInfo(string taskid)
{
try
{
//获取到任务的基本信息
task_model = task_bll.GetModel(int.Parse(taskid));
//任务标题
NAME.Text = task_model.NAMES;
//开始时间
TB_StartTime.Value = Convert.ToDateTime(task_model.StartTime.ToString()).ToString("yyyy-MM-dd");
//结束时间
TB_EndTime.Value = Convert.ToDateTime(task_model.EndTime.ToString()).ToString("yyyy-MM-dd");
//任务描述
Overviews.Text = task_model.Overviews.ToString();
//任务状态
for (int i = 0; i < RadioButtonList_status.Items.Count; i++)
{
if (RadioButtonList_status.Items[i].Value.Equals(task_model.Status.ToString()))
{
RadioButtonList_status.Items[i].Selected = true;
}
}
//显示可供参与的人员信息 。
DataTable dt_dep = new DataTable();
//project_model = project_bll.GetModel(Convert.ToInt16(Session["Work_ProjectId"]));
//string departID = commons.makeSqlIn(project_model.DepartmentID.ToString(), ',');
//string sql1 = " SELECT ID, USERNAME, REALNAME,REALNAME + '（' + USERNAME +'）' AS NEWNAME FROM USER_Users WHERE (DELFLAG = 0) AND (DepartMentID IN " + departID + ")";
string sql1 = " SELECT ID, USERNAME, REALNAME,REALNAME + '（' + USERNAME +'）' AS NEWNAME FROM USER_Users WHERE (DELFLAG = 0) AND (ID IN (SELECT UserID FROM Project_UserList WHERE (ProjectID = " + Convert.ToInt16(Session["Work_ProjectId"]) + ") AND (Status = 1)))";
dt_dep = pagecontrol.doSql(sql1).Tables[0];
if (dt_dep.Rows.Count > 0)
{
CB_usersID.DataSource = dt_dep.DefaultView;
CB_usersID.DataTextField = "NEWNAME";
CB_usersID.DataValueField = "ID";
CB_usersID.DataBind();
//在任务表中的参与人员字段
string UserIDs = task_model.UserIDs.ToString();
int checknum = 0;
//因为在任务表中部门以‘;’分开。故以‘;’将其分割,切割后的格式为: "用户ID号"+","+"0"
string[] UserIDsInfo = UserIDs.Split(';');
for (int i = 0; i < dt_dep.Rows.Count; i++)
{
for (int j = 0; j < UserIDsInfo.Length; j++)
{
string[] uid = UserIDsInfo[j].Split(',');
if (uid[0].ToString().Equals(CB_usersID.Items[i].Value.ToString()))
{
CB_usersID.Items[i].Selected = true;
checknum = checknum + 1;
}
}
}
//如果所有的参与人员都选中了，则将“全部”的复选框选中
if (checknum == dt_dep.Rows.Count)
{
CheckBox_choose.Checked = true;
}
}
else//因为参与部门是非空项，所以如果没有可供参与的部门的话，是不可以进行项目的申请的。
{
CB_usersID.Enabled = false;
LB_notice.Visible = true;
Button_sumbit.Enabled = false;
}
//显示父任务
DataTable DT_task = new DataTable();
string sql2 = "SELECT ID,NAMES FROM Project_Task WHERE (DELFLAG = 0) AND ProjectID = " + Convert.ToInt16(Session["Work_ProjectId"]) + " AND IsFather = 1 ";
DT_task = pagecontrol.doSql(sql2).Tables[0];
ListItem li = new ListItem("--无--", "0");
DDL_UpID.Items.Add(li);
if (DT_task.Rows.Count > 0)
{
for (int i = 0; i < DT_task.Rows.Count; i++)
{
string name = DT_task.Rows[i]["NAMES"].ToString();
string id = DT_task.Rows[i]["ID"].ToString();
ListItem li1 = new ListItem(name, id);
DDL_UpID.Items.Add(li1);
}
}
//父任务
DDL_UpID.SelectedValue = task_model.UpID.ToString();
//有无子任务
RadioButtonList_IsFather.SelectedValue = task_model.IsFather.ToString();
//是否上传文档
RadioButtonList_doc.SelectedValue = task_model.CompleteType.ToString();
DDL_UpID.Enabled = false;
}
catch
{
}
}
/// <summary>
/// 编辑任务
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void Button_sumbit_Click(object sender, EventArgs e)
{
try
{
project_model = project_bll.GetModel(Convert.ToInt16(Session["Work_ProjectId"]));
//获取到当前要修改的任务的ID
string ID = Request["ID"];
//获取到任务的详细信息
task_model = task_bll.GetModel(int.Parse(ID));
string taskname = NAME.Text.ToString();
//检查是否有该任务名称
bool checkName = pagecontrol.Exists_TaskName("Project_Task", "NAMES", taskname, "ID", ID, Convert.ToInt16(Session["Work_ProjectId"]));
if (checkName)
{
tag.Text = "该任务名已经存在，请修改！";
}
else
{
//任务名称
task_model.NAMES = taskname.ToString();
string time = TB_StartTime.Value.ToString() + " 00:00:00";// +DateTime.Now.ToString("HH:mm:ss");
//开始时间
task_model.StartTime = Convert.ToDateTime(time);
//结果时间
task_model.EndTime = Convert.ToDateTime(TB_EndTime.Value.ToString() + " 23:59:59");
//任务描述
task_model.Overviews = Overviews.Text.ToString();
//状态
task_model.Status = int.Parse(RadioButtonList_status.SelectedValue.ToString());
Model.USER_Users user_model = (Model.USER_Users)Session["USER_Users"];
string userids = "";
string usernames = "";
for (int i = 0; i < CB_usersID.Items.Count; i++)
{
if (CB_usersID.Items[i].Selected == true)
{
userids = userids + CB_usersID.Items[i].Value + ",0" + ";";
if (usernames.Equals(""))
{
usernames = CB_usersID.Items[i].Text;
}
else
{
usernames = usernames + "; " + CB_usersID.Items[i].Text;
}
//给参与此任务的用户发信息
Model.FaceShowMessage mFaceShowMessage = new Dianda.Model.FaceShowMessage();
BLL.FaceShowMessage bFaceShowMessage = new Dianda.BLL.FaceShowMessage();
mFaceShowMessage.DATETIME = DateTime.Now;
mFaceShowMessage.FromTable = "项目任务";
mFaceShowMessage.IsRead = 0;
mFaceShowMessage.NewsID = null;
mFaceShowMessage.NewsType = "项目任务";
mFaceShowMessage.ReadTime = null;
mFaceShowMessage.Receive = CB_usersID.Items[i].Value;
mFaceShowMessage.DELFLAG = 0;
mFaceShowMessage.ProjectID = project_model.ID;
mFaceShowMessage.URLS = "<a href='/Admin/personalProjectManage/OAtask/manage.aspx?ID=" + task_model.ProjectID + "' target='_self' title='任务变更：变更时间" + DateTime.Now.ToString() + "'>任务变更：" + taskname + "</a> " + project_model.NAMES + " (" + user_model.REALNAME + ")";
bFaceShowMessage.Add(mFaceShowMessage);
}
}
//参与的用户的ID
task_model.UserIDs = userids.Substring(0, userids.Length - 1);
//参与人员名称：真实姓名+'（'+用户名＋‘）’；
task_model.UserInfo = usernames;
//是否可建子任务
task_model.IsFather = int.Parse(RadioButtonList_IsFather.SelectedValue.ToString());
//是否上传文档
task_model.CompleteType = int.Parse(RadioButtonList_doc.SelectedValue.ToString());
//时间
task_model.DATETIME = Convert.ToDateTime(DateTime.Now.ToShortDateString());
task_bll.Update(task_model);
//string coutws = "<script language=\"javascript\" type=\"text/javascript\">alert(\"操作成功！现在进入列表页面\"); location.href = \"manage.aspx?pageindex=" + Request["pageindex"].ToString() + "&ID=" + project_model.ID + "\";</script>";
//Response.Write(coutws);
ScriptManager.RegisterStartupScript(this, this.GetType(), "ok", "<script>alert('操作成功！现在进入列表页面');javascript:location='manage.aspx?pageindex=" + Request["pageindex"].ToString() + "&ID=" + project_model.ID + "&status=" + Request.QueryString["status"] + "';</script>", false);
//添加操作日志
Dianda.BLL.SYS_LogsExt bsyslog = new Dianda.BLL.SYS_LogsExt();
//Model.USER_Users user_model = (Model.USER_Users)Session["USER_Users"];
bsyslog.addlogs(user_model.REALNAME + "(" + user_model.USERNAME + ")", "项目中编辑任务", project_model.NAMES + "项目" + task_model.NAMES + "任务:编辑成功！");
//添加操作日志
}
}
catch
{
tag.Text = "操作失败，请重试！";
}
}
/// <summary>
/// 点击设为已完成按钮触发的事件
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void Button_setfinish_onclick(object sender, EventArgs e)
{
try
{
int num = 0;
int rows = GridView1.Rows.Count;
string flag = "";
string action = ((Button)sender).CommandArgument.ToString();
if (rows > 0)
{
for (int i = 0; i < rows; i++)
{
CheckBox cb = (CheckBox)GridView1.Rows[i].Cells[0].FindControl("CheckBox_choose");
if (cb.Checked)
{
num = num + 1;
}
}
if (num == 0)
{
if (action.Equals("1"))//设为进行中
{
flag = "待办";
}
else if (action.Equals("2"))
{
flag = "完成";
}
else if (action.Equals("3"))
{
flag = "暂停";
}
tag.Text = "设为" + flag + "时最少选择一条数据！";
}
else
{
tag.Text = "";
for (int j = 0; j < rows; j++)
{
CheckBox cb1 = (CheckBox)GridView1.Rows[j].Cells[0].FindControl("CheckBox_choose");
HiddenField hid = (HiddenField)GridView1.Rows[j].Cells[0].FindControl("Hid_ID");
if (cb1.Checked)
{
//获取到当前任务的基本信息
task_model = task_bll.GetModel(int.Parse(hid.Value.ToString()));
//任务的状态
task_model.Status = int.Parse(action);
//组员更新时间
task_model.ReadTime = Convert.ToDateTime(DateTime.Now.ToString());
if (!(bool)Session["isProjectLeader"])//如果不是项目负责人
{
Model.USER_Users user_model1 = (Model.USER_Users)Session["USER_Users"];
string userid = "";
string[] userids = task_model.UserIDs.Split(';');
for (int i = 0; i < userids.Length; i++)
{
string[] uid = userids[i].Split(',');
if (uid[0].ToString().Equals(user_model1.ID))
{
uid[1] = action;
}
userid = userid + uid[0] + "," + uid[1] + ";";
}
//将对应的userid的后面的状态也更改掉
task_model.UserIDs = userid.Substring(0, userid.Length - 1);
}
task_bll.Update(task_model);
//添加操作日志
Dianda.BLL.SYS_LogsExt bsyslog = new Dianda.BLL.SYS_LogsExt();
Model.USER_Users user_model = (Model.USER_Users)Session["USER_Users"];
bsyslog.addlogs(user_model.REALNAME + "(" + user_model.USERNAME + ")", "项目任务设为" + flag, project_model.NAMES + "项目" + task_model.NAMES + "任务:设置" + flag + "成功！");
//添加操作日志
}
}
//tag.Text = "操作成功！";
//string coutws = "<script language=\"javascript\" type=\"text/javascript\">alert(\"操作成功！现在返回列表页面\"); location.href = \"manage.aspx?pageindex=" + pageindexHidden.Value.ToString() + "&ID=" + Request["ID"].ToString() + "\";</script>";
//Response.Write(coutws);
ScriptManager.RegisterStartupScript(this, this.GetType(), "ok", "<script>alert('操作成功！现在进入项目任务页面');javascript:location='manage.aspx?pageindex=" + pageindexHidden.Value.ToString() + "&ID=" + Request["ID"].ToString() + "&status=" + DDL_Status.SelectedValue + "';</script>", false);
}
}
}
catch
{
int pageint = 1;
if (pageindexHidden.Value.ToString() != "")
{
pageint = int.Parse(pageindexHidden.Value.ToString());
}
ShowTaskList(pageint);
}
}
