/// <summary> /// 添加用户 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void Button_sumbit_Click(object sender, EventArgs e) { try { //获得传过来的ID Model.USER_Users user_model = (Model.USER_Users)Session["USER_Users"]; string strId = user_model.ID; DelUser(strId); if (ALLCheck.Checked == true) { Model.Personal_Plan_Limits MperPlan = new Dianda.Model.Personal_Plan_Limits(); MperPlan.USERID = user_model.ID; MperPlan.APPLYUSERID = user_model.ID; MperPlan.ISALL = 1; BPerPlan.Add(MperPlan); } else { ArrayList al = ShareForUser1.getSelectUser(); addUser(strId, al); } //添加操作日志 Dianda.BLL.SYS_LogsExt bsyslog = new Dianda.BLL.SYS_LogsExt(); bsyslog.addlogs(user_model.REALNAME + "(" + user_model.USERNAME + ")", "添加人员", "添加成功"); string coutws = "<script language=\"javascript\" type=\"text/javascript\">alert(\"操作成功!\");location.href='SelectUserPlan.aspx?staue=1';</script>"; Response.Write(coutws); } catch (Exception) { } }
/// <summary> /// 增加一条数据 /// </summary> public int Add(Dianda.Model.Personal_Plan_Limits model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into Personal_Plan_Limits("); strSql.Append("USERID,APPLYUSERID,ISALL)"); strSql.Append(" values ("); strSql.Append("@USERID,@APPLYUSERID,@ISALL)"); strSql.Append(";select @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@USERID", SqlDbType.VarChar, 50), new SqlParameter("@APPLYUSERID", SqlDbType.Text), new SqlParameter("@ISALL", SqlDbType.Int, 4) }; parameters[0].Value = model.USERID; parameters[1].Value = model.APPLYUSERID; parameters[2].Value = model.ISALL; object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters); if (obj == null) { return(1); } else { return(Convert.ToInt32(obj)); } }
/// <summary> /// 得到一个对象实体 /// </summary> public Dianda.Model.Personal_Plan_Limits GetModel(int ID) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 ID,USERID,APPLYUSERID,ISALL from Personal_Plan_Limits "); strSql.Append(" where ID=@ID "); SqlParameter[] parameters = { new SqlParameter("@ID", SqlDbType.Int, 4) }; parameters[0].Value = ID; Dianda.Model.Personal_Plan_Limits model = new Dianda.Model.Personal_Plan_Limits(); 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()); } model.USERID = ds.Tables[0].Rows[0]["USERID"].ToString(); model.APPLYUSERID = ds.Tables[0].Rows[0]["APPLYUSERID"].ToString(); if (ds.Tables[0].Rows[0]["ISALL"].ToString() != "") { model.ISALL = int.Parse(ds.Tables[0].Rows[0]["ISALL"].ToString()); } return(model); } else { return(null); } }
/// <summary> /// 更新一条数据 /// </summary> public void Update(Dianda.Model.Personal_Plan_Limits model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update Personal_Plan_Limits set "); strSql.Append("USERID=@USERID,"); strSql.Append("APPLYUSERID=@APPLYUSERID,"); strSql.Append("ISALL=@ISALL"); strSql.Append(" where ID=@ID "); SqlParameter[] parameters = { new SqlParameter("@ID", SqlDbType.Int, 4), new SqlParameter("@USERID", SqlDbType.VarChar, 50), new SqlParameter("@APPLYUSERID", SqlDbType.Text), new SqlParameter("@ISALL", SqlDbType.Int, 4) }; parameters[0].Value = model.ID; parameters[1].Value = model.USERID; parameters[2].Value = model.APPLYUSERID; parameters[3].Value = model.ISALL; DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); }
/// <summary> /// 将用户添加到项目 /// </summary> /// <param name="strUserId"></param> /// <param name="al"></param> protected void addUser(string ProjectId, ArrayList al) { try { //先清除用户 DelUser(ProjectId); Model.Personal_Plan_Limits plan = new Dianda.Model.Personal_Plan_Limits(); plan.USERID = ProjectId; plan.ISALL = 0; plan.APPLYUSERID = ""; for (int i = 0; i < al.Count; i++) { if (al[i] != null && al[i].ToString() != "") { plan.APPLYUSERID += al[i].ToString() + ","; } } plan.APPLYUSERID = plan.APPLYUSERID.Remove(plan.APPLYUSERID.LastIndexOf(",")); BPerPlan.Add(plan); } catch (Exception) { } }