/// <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)
{
}
}
