/// <summary> /// 确定添加新用户组 /// 1.添加新人员前要检测该用户组的名称是否已经在系统中注册,如果注册过了,则提醒用户重复,要求用户重新命名 /// 2.添加该用户进数据库 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void Button_queding_Click(object sender, EventArgs e) { try { string username = TB_USERNAME.Text.ToString();//获取到用户名 //检查该名称是否有了 if (username != "") { //检查是否有该用户组名称 bool checkName = pageControl.Exists_Name("USER_Users", "USERNAME", username, "ID", ""); if (checkName) { tag.Text = "该用户名已经存在,请修改!"; } else { //部门ID string DepartMentID = ""; //部门名称 string DepartMentName = ""; foreach (ListItem item in CheckBox_DEPARTMENT.Items) { if (item.Selected == true) { DepartMentID += item.Value + ","; DepartMentName += item.Text + ","; } } if (DepartMentID != null && DepartMentID != "") { users_Model.ID = commons.GetGUID();//获取到GUID作为ID //用户名 users_Model.USERNAME = TB_USERNAME.Text.ToString(); //密码 users_Model.PASSWORD = commons.GetMD5(TB_PASSWORD.Text.Trim()); //真实姓名 users_Model.REALNAME = TB_REALNAME.Text; //性别 users_Model.SEX = RadioButtonList_SEX.SelectedValue.ToString(); //是否为项目经理 users_Model.IsManager = int.Parse(RadioButtonList_IsManager.SelectedValue.ToString()); //部门 users_Model.DepartMentID = DepartMentID.Remove(DepartMentID.LastIndexOf(",")); //部门名称 users_Model.DepartMentName = DepartMentName.Remove(DepartMentName.LastIndexOf(",")); //岗位 users_Model.StationID = DDL_Station.SelectedValue.ToString(); //联系电话 users_Model.TEL = TB_TEL.Text; //移动电话 users_Model.TEMP1 = TextBox_TEMP1.Text; //邮箱 users_Model.EMAIL = TB_EMAIL.Text; //在职状态 users_Model.WorkStats = DDL_WorkStats.SelectedValue.ToString(); //入职时间 if (null == TB_DatesEmployed.Value || TB_DatesEmployed.Value.ToString().Equals("")) { users_Model.DatesEmployed = null; } else { users_Model.DatesEmployed = Convert.ToDateTime(TB_DatesEmployed.Value.ToString()); } //离职时间 if (null == TB_LeaveDates.Value || TB_LeaveDates.Value.ToString().Equals("")) { users_Model.LeaveDates = null; } else { //离职时间 users_Model.LeaveDates = Convert.ToDateTime(TB_LeaveDates.Value.ToString()); } //生日 if (TB_BIRTHDAY.Value == null || TB_BIRTHDAY.Value.ToString().Equals("")) { users_Model.BIRTHDAY = ""; } else { users_Model.BIRTHDAY = TB_BIRTHDAY.Value.ToString(); } //籍贯 users_Model.NativePlace = TB_NativePlace.Text; //学历 users_Model.EducationLevel = DDL_EducationLevel.SelectedValue.ToString(); //住址 users_Model.ADDRESS = TB_ADDRESS.Text.ToString(); //毕业学校 users_Model.GraduateSchool = TB_GraduateSchool.Text; //专业 users_Model.Major = TB_Major.Text; //工作履历 users_Model.TrackRecord = TB_TrackRecord.Text; //时间 users_Model.DATETIME = Convert.ToDateTime(DateTime.Now.ToShortDateString().ToString()); //工作组 string sql_groups = "SELECT ID FROM USER_Groups WHERE (ISMOREN = '1') AND (TAGS = '普通组')"; DataTable dt = pageControl.doSql(sql_groups).Tables[0]; users_Model.GROUPS = dt.Rows[0]["ID"].ToString(); //头像 users_Model.IMAGES = ""; //删除标记 users_Model.DELFLAG = 0; users_Bll.Add(users_Model); new ajax().UpdateUserRemoteInfoWithJAVAWebService(users_Model, EnumRemoteOperation.Import); //人员信息添加成功以后,要向Document_Folder中添加一个当前用户的顶级档案目录 int docfolderid = docfolder_bll.GetMaxId(); docfolder_model.ID = docfolderid; //目录名称 docfolder_model.FolderName = users_Model.USERNAME + "_" + users_Model.REALNAME; //上级目录 docfolder_model.UpID = -1; //文件夹的属性 docfolder_model.Types = "private"; //所属人ID docfolder_model.UserID = users_Model.ID; //是否共享 docfolder_model.IsShare = 0; //删除标记 docfolder_model.DELFLAG = 0; //当前时间 docfolder_model.DATETIME = Convert.ToDateTime(DateTime.Now.ToShortDateString()); //栏目的路径记录(用/来隔开) docfolder_model.COLUMNSPATH = "-1/" + docfolder_model.ID; //栏目显示的顺序 docfolder_model.SHUNXU = 0; //栏目的路径名称 docfolder_model.PNAMES = "我的文档"; //当前文件夹中文件的大小 docfolder_model.SizeOf = "0"; docfolder_bll.Add(docfolder_model); //人员信息添加成功以后,要向Document_Folder中默认添加一个收藏夹 docfolder_model.ID = docfolder_bll.GetMaxId(); //目录名称 docfolder_model.FolderName = "收藏夹"; //上级目录 docfolder_model.UpID = docfolderid; //文件夹的属性 docfolder_model.Types = "private"; //所属人ID docfolder_model.UserID = users_Model.ID; //是否共享 docfolder_model.IsShare = 0; //删除标记 docfolder_model.DELFLAG = 0; //当前时间 docfolder_model.DATETIME = Convert.ToDateTime(DateTime.Now.ToShortDateString()); //栏目的路径记录(用/来隔开) docfolder_model.COLUMNSPATH = "-1/" + docfolder_model.UpID + "/" + docfolder_model.ID; //栏目显示的顺序 docfolder_model.SHUNXU = 0; //栏目的路径名称 docfolder_model.PNAMES = "我的档案>收藏夹"; //当前文件夹中文件的大小 docfolder_model.SizeOf = "0"; docfolder_bll.Add(docfolder_model); tag.Text = "操作成功!"; string coutws = "<script language=\"javascript\" type=\"text/javascript\">alert(\"操作成功!现在进入列表页面\"); location.href = \"manage.aspx" + "\";</script>"; Response.Write(coutws); //添加操作日志 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 + ")", "添加人员信息", "添加" + users_Model.REALNAME + "(" + user_model.USERNAME + ")" + "成功"); //添加操作日志 } else { this.Page.ClientScript.RegisterClientScriptBlock(GetType(), "key", "alert('请选择部门!')", true); } } } } catch { tag.Text = "操作失败,请重试!"; } }
///// <summary> ///// 根据项目负责人来动态显示资金卡下拉列表 ///// </summary> ///// <param name="CashflagID"></param> //protected void SetDDL_CashCardID(string CashflagID) //{ // DataTable dt3 = new DataTable(); // string sql2 = " SELECT ID, CardNum, CardName, LimitNums FROM Cash_Cards WHERE (CardholderID = '" + CashflagID + "') "; // dt3 = pagecontrol.doSql(sql2).Tables[0]; // if (dt3.Rows.Count > 0) // { // DDL_CashCardID.Enabled = true; // DDL_CashCardID.Items.Clear(); // for (int j = 0; j < dt3.Rows.Count; j++) // { // string ID = dt3.Rows[j]["ID"].ToString(); // string CardNum = dt3.Rows[j]["CardNum"].ToString(); // string CardName = dt3.Rows[j]["CardName"].ToString(); // string LimitNums = dt3.Rows[j]["LimitNums"].ToString(); // string showinfo = CardName + "[" + CardNum + "," + LimitNums + "]"; // ListItem li = new ListItem(showinfo, ID); // DDL_CashCardID.Items.Add(li); // } // Button_applyfor.Enabled = true; // Button_reset.Enabled = true; // Button_draft.Enabled = true; // } // else // { // DDL_CashCardID.Items.Clear(); // ListItem li = new ListItem("暂无可选资金卡", ""); // DDL_CashCardID.Items.Add(li); // DDL_CashCardID.Enabled = false; // Button_applyfor.Enabled = false; // Button_reset.Enabled = false; // Button_draft.Enabled = false; // } //} /// <summary> /// 资金卡选择切换 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> //protected void RB_NewAddCashCard_CheckedChanged(object sender, EventArgs e) //{ // RB_CashCardID.Checked = false; // RB_NewAddCashCard.Checked = true; // div_cash.Visible = true; // Button_applyfor.Enabled = true; // Button_reset.Enabled = true; // Button_draft.Enabled = true; //} /// <summary> /// 资金卡选择切换 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> //protected void RB_CashCardID_CheckedChanged(object sender, EventArgs e) //{ // RB_CashCardID.Checked = true; // RB_NewAddCashCard.Checked = false; // div_cash.Visible = false; //} /// <summary> /// 根据项目负责人来动态显示资金卡下拉列表 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> //protected void DDL_LeaderID_Changed(object sender, EventArgs e) //{ // string ID = DDL_LeaderID.SelectedValue.ToString(); // SetDDL_CashCardID(ID); //} /// <summary> /// 点击重置触发事件 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> //protected void Button_reset_Click(object sender, EventArgs e) //{ // NAME.Text = ""; // for (int i = 0; i < CB_DepartmentID.Items.Count; i++) // { // if (CB_DepartmentID.Items[i].Selected == true) // { // CB_DepartmentID.Items[i].Selected = false; // } // } // TB_StartTime.Value = ""; // TB_EndTime.Value = ""; // CashTotal.Text = ""; // RB_CashCardID.Checked = true; // RB_NewAddCashCard.Checked = false; // Overviews.Value = ""; // div_cash.Visible = false; // TB_LimitNums.Text = ""; // TB_Notes.Text = ""; //} /// <summary> /// 点击申请触发事件 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void Button_applyfor_Click(object sender, EventArgs e) { try { string ID = Request["ID"]; project_model = project_bll.GetModel(int.Parse(ID)); //项目审核人 string douserid = project_model.DoUserID.ToString(); string projectName = NAME.Text.ToString(); //检查是否有该项目名称 bool checkName = pagecontrol.Exists_Name("Project_Projects", "NAMES", projectName, "ID", ID); if (checkName) { tag.Text = "该项目名称已经存在,请修改!"; } else { if (FileUpload1.FileName.Length > 2) { string[] content = fileup.UpFile_COMMONS(FileUpload1, "/AllFileUp/fileup", HiddenField_oldpath.Value.ToString()); //1-成功;0-失败;2-类型不支持;3-大小不符合;文件的路径;文件名称;文件类型;图标;大小;操作结果 if (content[0] == "0") { tag.Text = "文件上传失败,请重新上传!"; return; } else if (content[0] == "2") { tag.Text = "系统不允许此类文件上传,文件上传失败,请重新上传!"; return; } else if (content[0] == "3") { tag.Text = "文件上传大小不符合,文件上传失败,请重新上传!"; return; } project_model.Attachments = content[1]; } Model.USER_Users user_model = (Model.USER_Users)Session["USER_Users"]; int statusflag = Convert.ToInt32(((Button)sender).CommandArgument.ToString());//获取到触发源 //项目名称 project_model.NAMES = NAME.Text.ToString(); //状态 project_model.Status = statusflag; //项目负责人 project_model.LeaderID = DDL_LeaderID.SelectedValue.ToString().Split('|')[0].ToString(); ////参与部门--参与部门的编辑工作放在了项目成员的功能处-唐春龙-2011-02-17 //project_model.DepartmentID = ""; ////参与部门名称 //project_model.DepartmentNames = ""; //for (int i = 0; i < CB_DepartmentID.Items.Count; i++) //{ // if (CB_DepartmentID.Items[i].Selected == true) // { // project_model.DepartmentID = project_model.DepartmentID + CB_DepartmentID.Items[i].Value + ","; // project_model.DepartmentNames = project_model.DepartmentNames + CB_DepartmentID.Items[i].Text + ","; // } //} ///* 截掉最后一个逗号*/ //if (project_model.DepartmentID.Length > 0) //{ // project_model.DepartmentID = project_model.DepartmentID.Substring(0, project_model.DepartmentID.Length - 1); // project_model.DepartmentNames = project_model.DepartmentNames.Substring(0, project_model.DepartmentNames.Length - 1); //}--参与部门的编辑工作放在了项目成员的功能处-唐春龙-2011-02-17 //项目预计起始时间 project_model.StartTime = Convert.ToDateTime(TB_StartTime.Value.ToString()); //项目预计结束时间 project_model.EndTime = Convert.ToDateTime(TB_EndTime.Value.ToString()); //预计经费 if (RL_ProjectType.SelectedValue.ToString().Equals("1"))//当项目类型为正常项目时才有预计经费项 { //项目审核人 project_model.DoUserID = DDL_CheckUserID.SelectedValue.ToString(); if (!CashTotal.Text.ToString().Equals("")) { //project_model.CashTotal = Convert.ToDecimal(CashTotal.Text.ToString()); if (RB_cashtotal.SelectedValue.ToString().Equals("1"))//表示经费单位选择的是万元 { //经费额度存放的是元 project_model.CashTotal = Convert.ToDecimal(CashTotal.Text.ToString()) * 10000; //经费单位 project_model.CashDw = "万元"; } else { project_model.CashTotal = Convert.ToDecimal(CashTotal.Text.ToString()); //经费单位 project_model.CashDw = "元"; } } else { project_model.CashTotal = null; } } else { //项目审核人 project_model.DoUserID = ""; } //资金卡选择 //DataSet ds1 = cashmessage_bll.GetList(" ProjectID = " + project_model.ID); //if (RB_CashCardID.Checked == true)//如果选择的是资金卡则设为资金卡的ID; //{ // project_model.CashCardID = Int16.Parse(DDL_CashCardID.SelectedValue.ToString()); // //如果编辑时选择的是资金卡,但是在cash_message表中发现有此项目的消息记录,则说明 // //在新建此项目时选择的是新建资金卡,而现在如果修改成资金卡,则要将这条消息记录删除 // if (ds1.Tables[0].Rows.Count > 0) // { // string cashid = ds1.Tables[0].Rows[0]["ID"].ToString(); // cashmessage_bll.Delete(int.Parse(cashid)); // } //} //else//如果选择的是新建资金卡则设为0,并且需要向cash_message表中加一条记录 //{ // project_model.CashCardID = 0; // //如果原来就有记录,则修改 // if (ds1.Tables[0].Rows.Count > 0) // { // //ID // string cashid = ds1.Tables[0].Rows[0]["ID"].ToString(); // cashmessage_model = cashmessage_bll.GetModel(int.Parse(cashid)); // //资金卡初始金额 // cashmessage_model.LimitNums = Convert.ToDecimal(TB_LimitNums.Text); // //新建备注说明 // cashmessage_model.Notes = TB_Notes.Text.ToString(); // cashmessage_bll.Update(cashmessage_model); // } // else // { // //资金卡名称(暂时写的留空) // cashmessage_model.CardName = ""; // //持卡人 // cashmessage_model.CardholderID = DDL_LeaderID.SelectedValue; // //项目的ID // cashmessage_model.ProjectID = project_model.ID; // //初始金额 // cashmessage_model.LimitNums = Convert.ToDecimal(TB_LimitNums.Text.ToString()); // //填写的时间 // cashmessage_model.DATETIME = Convert.ToDateTime(DateTime.Now.ToString()); // //发出这个消息的用户的ID // cashmessage_model.SendUserID = user_model.ID; // //备注说明 // cashmessage_model.Notes = TB_Notes.Text.ToString(); // //是否已经阅读 // cashmessage_model.IsRead = 0; // //消息的状态 // cashmessage_model.Status = 0; // Session["Cash_Message_temps"] = cashmessage_model; // //向信息表中添加一条新建资金卡的记录 // cashmessage_bll.Add(cashmessage_model); // } //} //项目概要 project_model.Overviews = Overviews.Value.ToString(); //申请时间 project_model.DATETIME = Convert.ToDateTime(DateTime.Now.ToString()); //所属分类 project_model.ColumnsID = int.Parse(DDL_COLUMN.SelectedValue); //修改项目 project_bll.Update(project_model); //根据项目负责人的改变来改变项目组成员 string sql_userlist = " SELECT ID, ProjectID, UserID, Status, DATETIME FROM Project_UserList WHERE (ProjectID = '" + ID + "') AND (UserID = '" + project_model.LeaderID + "') AND (Status = '1')"; DataTable dt = pagecontrol.doSql(sql_userlist).Tables[0]; if (!(dt.Rows.Count > 0)) { Dianda.BLL.Project_UserList project_userlist_bll = new Dianda.BLL.Project_UserList(); Dianda.Model.Project_UserList project_userlist_model = new Dianda.Model.Project_UserList(); // project_userlist_model.ID = project_userlist_bll.GetMaxId(); //项目ID project_userlist_model.ProjectID = project_model.ID; //项目组成员 project_userlist_model.UserID = project_model.LeaderID; //状态 project_userlist_model.Status = 1; //时间 project_userlist_model.DATETIME = DateTime.Now; //向Project_UserList加条记录 project_userlist_bll.Add(project_userlist_model); } //根据所选择的分类的改变来动态的改变项目审批人的下拉列表。这样原来这个项目的审核人就发生了更改则需要将原来审核表中的UserID改成新的 string sql_checkuser = "******" + DDL_CheckUserID.SelectedValue.ToString() + "' WHERE (ProjectID = " + project_model.ID + ") AND (Status = 0) AND (UserID = '" + douserid + "') "; pagecontrol.doSql(sql_checkuser); ScriptManager.RegisterStartupScript(this, this.GetType(), "ok", "<script>alert('操作成功!现在进入我的项目页面');javascript:location='manage.aspx?projectstatus=" + Request["status"] + "';</script>", false); //添加操作日志 Dianda.BLL.SYS_LogsExt bsyslog = new Dianda.BLL.SYS_LogsExt(); bsyslog.addlogs(user_model.REALNAME + "(" + user_model.USERNAME + ")", "修改立项申请", "修改" + project_model.NAMES + "项目申请修改成功"); //添加操作日志 //tag.Text = "操作成功! 点击“返回”按钮进入我的项目页面!"; //addproject.Visible = false; //goback.Visible = true; } } catch { } }
/// <summary> /// 确定添加新建项目负责人 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void Button1_Click(object sender, EventArgs e) { try { string username = TextBox_UserName.Text.ToString();//获取到用户名 //检查该名称是否有了 if (username != "") { //检查是否有该用户组名称 bool checkName = pageControl.Exists_Name("USER_Users", "USERNAME", username, "ID", ""); if (checkName) { tag.Text = "该用户名已经存在,请修改!"; } else { users_Model.ID = commons.GetGUID();//获取到GUID作为ID Session["new_leaderid"] = users_Model.ID; //用户名 users_Model.USERNAME = TextBox_UserName.Text.ToString(); //密码 users_Model.PASSWORD = commons.GetMD5(TextBox_Pwd.Text.Trim()); //真实姓名 users_Model.REALNAME = TextBox_Rlname.Text; //性别 users_Model.SEX = RadioButtonList_Sex.SelectedValue.ToString(); //是否为项目经理 users_Model.IsManager = 9; //部门 users_Model.DepartMentID = ConfigurationManager.AppSettings["departmentid_temp"]; //部门名称 string sql_groups = "SELECT ID,name FROM USER_Groups WHERE id='" + ConfigurationManager.AppSettings["departmentid_temp"] + "'"; DataTable dt = pageControl.doSql(sql_groups).Tables[0]; users_Model.DepartMentName = dt.Rows[0]["name"].ToString(); //岗位 users_Model.StationID = ConfigurationManager.AppSettings["positionid_temp"]; //联系电话 users_Model.TEL = ""; //移动电话 users_Model.TEMP1 = ""; //邮箱 users_Model.EMAIL = "*****@*****.**"; //在职状态 users_Model.WorkStats = "1"; //籍贯 users_Model.NativePlace = "上海"; //学历 users_Model.EducationLevel = "4"; //时间 users_Model.DATETIME = Convert.ToDateTime(DateTime.Now.ToShortDateString().ToString()); //工作组 users_Model.GROUPS = ConfigurationManager.AppSettings["manageid_temp"]; //删除标记 users_Model.DELFLAG = 0; users_Bll.Add(users_Model); tag.Text = "操作成功!"; //添加操作日志 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 + ")", "添加人员信息", "添加" + users_Model.REALNAME + "(" + user_model.USERNAME + ")" + "成功"); Label la = (Label)this.Parent.Parent.FindControl("Label_NewLeader"); la.Text = "--[" + TextBox_Rlname.Text + "(" + TextBox_UserName.Text + ")]"; } } } catch { tag.Text = "操作失败,请重试!"; } }
/// <summary> /// 根据项目负责人来动态显示资金卡下拉列表 /// </summary> /// <param name="CashflagID"></param> //protected void SetDDL_CashCardID(string CashflagID) //{ // DataTable dt3 = new DataTable(); // string sql2 = " SELECT ID, CardNum, CardName, LimitNums FROM Cash_Cards WHERE (CardholderID = '" + CashflagID + "') "; // dt3 = pagecontrol.doSql(sql2).Tables[0]; // if (dt3.Rows.Count > 0) // { // DDL_CashCardID.Enabled = true; // DDL_CashCardID.Items.Clear(); // for (int j = 0; j < dt3.Rows.Count; j++) // { // string ID = dt3.Rows[j]["ID"].ToString(); // string CardNum = dt3.Rows[j]["CardNum"].ToString(); // string CardName = dt3.Rows[j]["CardName"].ToString(); // string LimitNums = dt3.Rows[j]["LimitNums"].ToString(); // string showinfo = CardName + "[" + CardNum + "," + LimitNums + "]"; // ListItem li = new ListItem(showinfo, ID); // DDL_CashCardID.Items.Add(li); // } // Button_applyfor.Enabled = true; // Button_reset.Enabled = true; // Button_draft.Enabled = true; // } // else // { // DDL_CashCardID.Items.Clear(); // ListItem li = new ListItem("暂无可选资金卡", ""); // DDL_CashCardID.Items.Add(li); // DDL_CashCardID.Enabled = false; // Button_applyfor.Enabled = false; // Button_reset.Enabled = false; // Button_draft.Enabled = false; // } //} /// <summary> /// 资金卡选择切换 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> //protected void RB_NewAddCashCard_CheckedChanged(object sender, EventArgs e) //{ // RB_CashCardID.Checked = false; // RB_NewAddCashCard.Checked = true; // div_cash.Visible = true; // Button_applyfor.Enabled = true; // Button_reset.Enabled = true; // Button_draft.Enabled = true; //} /// <summary> /// 资金卡选择切换 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> //protected void RB_CashCardID_CheckedChanged(object sender, EventArgs e) //{ // RB_CashCardID.Checked = true; // RB_NewAddCashCard.Checked = false; // div_cash.Visible = false; //} /// <summary> /// 点击申请触发事件 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void Button_applyfor_Click(object sender, EventArgs e) { try { string projectName = NAME.Text.ToString(); //检查是否有该项目名称 bool checkName = pagecontrol.Exists_Name("Project_Projects", "NAMES", projectName, "ID", ""); if (checkName) { tag.Text = "该项目名称已经存在,请修改!"; } else { //string content = FCL.UpFile(_FileUp, "/AllFileUp/fileup"); if (FileUpload1.FileName.Length > 2) { string[] content = fileup.UpFile_COMMONS(FileUpload1, "/AllFileUp/fileup", ""); //1-成功;0-失败;2-类型不支持;3-大小不符合;文件的路径;文件名称;文件类型;图标;大小;操作结果 if (content[0] == "0") { tag.Text = "文件上传失败,请重新上传!"; return; } else if (content[0] == "2") { tag.Text = "系统不允许此类文件上传,文件上传失败,请重新上传!"; return; } else if (content[0] == "3") { tag.Text = "文件上传大小不符合,文件上传失败,请重新上传!"; return; } project_model.Attachments = content[1]; } Model.USER_Users user_model = (Model.USER_Users)Session["USER_Users"]; int statusflag = Convert.ToInt32(((Button)sender).CommandArgument.ToString());//获取到触发源 //ID int ids = project_bll.GetMaxId(); project_model.ID = ids; //项目类型 project_model.ProjectType = int.Parse(RL_ProjectType.SelectedValue.ToString()); //项目名称 project_model.NAMES = NAME.Text.ToString(); //删除标记 project_model.DELFLAG = 0; //状态 if (RL_ProjectType.SelectedValue.ToString().Equals("1")) { project_model.Status = statusflag; } else { project_model.Status = 1;//项目状态设置为正常运行的项目 } //项目负责人 //project_model.LeaderID = DDL_LeaderID.SelectedValue.ToString(); if (CheckBox_Newleader.Checked == true) { if (Session["new_leaderid"] != null && Session["new_leaderid"] != "") { project_model.LeaderID = Session["new_leaderid"].ToString(); } else { tag.Text = "未设置项目创建人!无法新建项目!"; return; } } else { string[] Leader = DDL_LeaderID.SelectedValue.ToString().Split('|'); project_model.LeaderID = Leader[0].ToString(); } //参与部门 project_model.DepartmentID = ""; //参与部门名称 project_model.DepartmentNames = ""; for (int i = 0; i < CB_DepartmentID.Items.Count; i++) { if (CB_DepartmentID.Items[i].Selected == true) { project_model.DepartmentID = project_model.DepartmentID + CB_DepartmentID.Items[i].Value + ","; project_model.DepartmentNames = project_model.DepartmentNames + CB_DepartmentID.Items[i].Text + ","; } } /* 截掉最后一个逗号*/ if (project_model.DepartmentID.Length > 0) { project_model.DepartmentID = project_model.DepartmentID.Substring(0, project_model.DepartmentID.Length - 1); project_model.DepartmentNames = project_model.DepartmentNames.Substring(0, project_model.DepartmentNames.Length - 1); } //项目预计起始时间 project_model.StartTime = Convert.ToDateTime(TB_StartTime.Value.ToString()); //项目预计结束时间 project_model.EndTime = Convert.ToDateTime(TB_EndTime.Value.ToString()); //预计经费 if (RL_ProjectType.SelectedValue.ToString().Equals("1"))//当项目类型为正常项目时才有预计经费项 { //审核的用户ID project_model.DoUserID = DDL_CheckUserID.SelectedValue.ToString(); if (!CashTotal.Text.ToString().Equals("")) { if (RB_cashtotal.SelectedValue.ToString().Equals("1"))//表示经费单位选择的是万元 { //经费额度存放的是元 project_model.CashTotal = Convert.ToDecimal(CashTotal.Text.ToString()) * 10000; //经费单位 project_model.CashDw = "万元"; } else { project_model.CashTotal = Convert.ToDecimal(CashTotal.Text.ToString()); //经费单位 project_model.CashDw = "元"; } } } else { //审核的用户ID project_model.DoUserID = ""; } //资金卡选择 project_model.CashCardID = 0; //if (RB_CashCardID.Checked == true)//如果选择的是资金卡则设为资金卡的ID; //{ // project_model.CashCardID = Int16.Parse(DDL_CashCardID.SelectedValue.ToString()); //} //else//如果选择的是新建资金卡则设为0,并且需要向cash_message表中加一条记录 //{ // project_model.CashCardID = 0; // //资金卡名称(暂时写的留空) // cashmessage_model.CardName = ""; // //持卡人 // cashmessage_model.CardholderID = DDL_LeaderID.SelectedValue; // //项目的ID // cashmessage_model.ProjectID = project_model.ID; // //初始金额 // cashmessage_model.LimitNums = Convert.ToDecimal(TB_LimitNums.Text.ToString()); // //填写的时间 // cashmessage_model.DATETIME = Convert.ToDateTime(DateTime.Now.ToString()); // //发出这个消息的用户的ID // cashmessage_model.SendUserID = user_model.ID; // //备注说明 // cashmessage_model.Notes = TB_Notes.Text.ToString(); // //是否已经阅读 // cashmessage_model.IsRead = 0; // //消息的状态 // cashmessage_model.Status = 0; // Session["Cash_Message_temps"] = cashmessage_model; // //向信息表中添加一条新建资金卡的记录 // cashmessage_bll.Add(cashmessage_model); //} //项目概要 project_model.Overviews = Overviews.Value.ToString(); //申请时间 project_model.DATETIME = Convert.ToDateTime(DateTime.Now.ToString()); //申请的用户的ID project_model.SendUserID = user_model.ID; //所属分类 project_model.ColumnsID = int.Parse(DDL_COLUMN.SelectedValue); //向项目表中添加 project_bll.Add(project_model); //******************在项目申请成功以后将项目负责人默认为项目组成员,即向Project_UserList加条记录 Dianda.BLL.Project_UserList project_userlist_bll = new Dianda.BLL.Project_UserList(); Dianda.Model.Project_UserList project_userlist_model = new Dianda.Model.Project_UserList(); // project_userlist_model.ID = project_userlist_bll.GetMaxId(); //项目ID project_userlist_model.ProjectID = ids; // project_model.ID; //项目组成员 project_userlist_model.UserID = project_model.LeaderID; //状态 project_userlist_model.Status = 1; //时间 project_userlist_model.DATETIME = DateTime.Now; //向Project_UserList加条记录 project_userlist_bll.Add(project_userlist_model); //再将项目的创建者添加到项目组成员列表中--唐春龙2011-02-17 project_userlist_model.ProjectID = ids; project_userlist_model.UserID = project_model.SendUserID.ToString(); project_userlist_model.Status = 1; project_userlist_model.DATETIME = DateTime.Now; project_userlist_bll.Add(project_userlist_model); //******************在项目申请成功以后要根据所选择的项目审批人,将此项目发送给这个人,即向Project_ShenheList加条记录 //如果项目类型是“正常项目”才做如下操作 if (RL_ProjectType.SelectedValue.ToString().Equals("1")) { Dianda.BLL.Project_ShenheList Shenhe_bll = new Dianda.BLL.Project_ShenheList(); Dianda.Model.Project_ShenheList Shenhe_model = new Dianda.Model.Project_ShenheList(); //ID Shenhe_model.ID = Shenhe_bll.GetMaxId(); //需要审核的项目ID Shenhe_model.ProjectID = project_model.ID; //审核人的ID Shenhe_model.UserID = DDL_CheckUserID.SelectedValue.ToString(); //审核状态(新建默认时默认为0:待审核) Shenhe_model.Status = 0; //是否到当前的用户审核:0表示未到;1表示到;2表示已经审核过 Shenhe_model.Isturn = 1; //审核意见 Shenhe_model.Infors = ""; //向Project_ShenheList加条记录 Shenhe_bll.Add(Shenhe_model); } // ScriptManager.RegisterStartupScript(this, this.GetType(), "ok", "<script>alert('操作成功!现在进入我的项目页面');javascript:location='manage.aspx?projecttype=4&projectStatus=0';</script>", false); if (statusflag == 4) { ScriptManager.RegisterStartupScript(this, this.GetType(), "ok", "<script>alert('操作成功!现在进入立项草稿箱页面');javascript:location='manage.aspx?projectStatus=4';</script>", false); } else { if (RL_ProjectType.SelectedValue.ToString().Equals("0"))//临时项目 { ScriptManager.RegisterStartupScript(this, this.GetType(), "ok", "<script>alert('操作成功!现在进入我的项目页面');javascript:location='manage.aspx?projectStatus=1';</script>", false); } else { ScriptManager.RegisterStartupScript(this, this.GetType(), "ok", "<script>alert('操作成功!现在进入我的项目页面');javascript:location='manage.aspx?projectStatus=0';</script>", false); } } //清空Session new_leaderid Session["new_leaderid"] = ""; //添加操作日志 Dianda.BLL.SYS_LogsExt bsyslog = new Dianda.BLL.SYS_LogsExt(); bsyslog.addlogs(user_model.REALNAME + "(" + user_model.USERNAME + ")", "添加立项申请", "添加" + project_model.NAMES + "项目申请成功"); //添加操作日志 //tag.Text = "操作成功! 点击“返回”按钮进入我的项目页面!"; //addproject.Visible = false; // goback.Visible = true; //添加立项申请的前台提醒信息 mFaceshowMessage.DATETIME = DateTime.Now; mFaceshowMessage.FromTable = "立项申请"; mFaceshowMessage.IsRead = 0; mFaceshowMessage.NewsType = "立项申请"; mFaceshowMessage.Receive = project_model.DoUserID.ToString(); mFaceshowMessage.DELFLAG = 0; mFaceshowMessage.ProjectID = project_model.ID; mFaceshowMessage.URLS = "<a href='/Admin/SystemProjectManage/ProjectCheck/check.aspx?ID=" + ids.ToString() + "&pageindex=1&Status=0' target='_self' title='新建项目:提交时间" + DateTime.Now.ToString() + "'>新建项目:" + NAME.Text.ToString() + "</a> (" + user_model.REALNAME + ")"; bFaceshowMessage.Add(mFaceshowMessage); //如果是个人或者是临时项目的话,就没有审批一环了。所以就直接在创建项目时建一个档案目录 if (RL_ProjectType.SelectedValue.ToString().Equals("0")) { //项审批成功以后,要向Document_Folder中添加一个当前用户的顶级档案目录 Dianda.Model.Document_Folder docfolder_model = new Dianda.Model.Document_Folder(); Dianda.BLL.Document_Folder docfolder_bll = new Dianda.BLL.Document_Folder(); int id = docfolder_bll.GetMaxId(); docfolder_model.ID = id; //目录名称 docfolder_model.FolderName = project_model.NAMES; //上级目录 docfolder_model.UpID = 38; //文件夹的属性 docfolder_model.Types = "public"; //是否共享 docfolder_model.IsShare = 0; //创建的用户 docfolder_model.UserID = user_model.ID; //删除标记 docfolder_model.DELFLAG = 0; //当前时间 docfolder_model.DATETIME = Convert.ToDateTime(DateTime.Now.ToShortDateString()); //栏目的路径记录(用/来隔开) docfolder_model.COLUMNSPATH = "-1/38/" + docfolder_model.ID; //项目ID docfolder_model.ProjectID = ids; //栏目显示的顺序 docfolder_model.SHUNXU = 0; //栏目的路径名称 docfolder_model.PNAMES = "项目文档>" + project_model.NAMES; //当前文件夹中文件的大小 docfolder_model.SizeOf = "0"; docfolder_bll.Add(docfolder_model); if (null != project_model.Attachments && !(project_model.Attachments.ToString().Equals(""))) { setAttachmentsToDocument(user_model.ID, id.ToString(), project_model.Attachments.ToString());//将立项申请时的上传附件保存到项目的目录中 } //项审批成功以后往信息栏目表中添加一条记录 Dianda.BLL.News_ColumnsExt columnsext = new Dianda.BLL.News_ColumnsExt(); columnsext.addCloumns(project_model.NAMES, "PROJECT", project_model.ID.ToString(), 2); } } } catch { tag.Text = "立项过程中发生错误,请检查输入项是否正确!"; } }