protected void ButtonSub_Click(object sender, EventArgs e)
 {
     for (int i = 0; i < GridViewActor.Rows.Count; i++)
     {
         CheckBox checkboxselect = GridViewActor.Rows[i].FindControl("CheckBox1") as CheckBox;
         if (checkboxselect.Checked == true)
         {
             string          actorname = GridViewActor.Rows[i].Cells[1].Text;
             string          programid = HiddenFieldP.Value + HiddenFieldActor.Value;
             DtCms.BLL.Actor actorBll  = new DtCms.BLL.Actor();
             bool            isexist   = actorBll.AcExists(programid, actorname);
             if (isexist == false)
             {
                 DtCms.Model.Actor actor = new DtCms.Model.Actor();
                 actor.ActivityId  = HiddenFieldP.Value;
                 actor.ProgrammeId = programid;
                 actor.UserName    = actorname;
                 actor.TureName    = GridViewActor.Rows[i].Cells[2].Text;
                 actor.UserTel     = GridViewActor.Rows[i].Cells[3].Text;
                 actorBll.Add(actor);
                 ClientScript.RegisterClientScriptBlock(Page.GetType(), "", "<script>alert('提交成功!')</script>");
             }
             else
             {
                 ClientScript.RegisterClientScriptBlock(Page.GetType(), "", "<script>alert('提交失败!您已选择了该人员,请不要重复选择!')</script>");
             }
         }
     }
 }
예제 #2
0
        public int Add(DtCms.Model.Actor model)
        {
            StringBuilder strSql = new StringBuilder();

            strSql.Append("insert into dt_Actor(");
            strSql.Append("ActivityId,ProgrammeId,UserName,TureName,UserTel)");
            strSql.Append(" values (");
            strSql.Append("@ActivityId,@ProgrammeId,@UserName,@TureName,@UserTel)");

            SqlParameter[] parameters =
            {
                new SqlParameter("@ActivityId",  SqlDbType.VarChar,  100),
                new SqlParameter("@ProgrammeId", SqlDbType.VarChar,  100),
                new SqlParameter("@UserName",    SqlDbType.NVarChar, 100),
                new SqlParameter("@TureName",    SqlDbType.NVarChar,  50),
                new SqlParameter("@UserTel",     SqlDbType.NVarChar, 50)
            };

            parameters[0].Value = model.ActivityId;
            parameters[1].Value = model.ProgrammeId;
            parameters[2].Value = model.UserName;
            parameters[3].Value = model.TureName;
            parameters[4].Value = model.UserTel;

            object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters);

            if (obj == null)
            {
                return(0);
            }
            else
            {
                return(Convert.ToInt32(obj));
            }
        }
예제 #3
0
        public bool Update(DtCms.Model.Actor model)
        {
            StringBuilder strSql = new StringBuilder();

            strSql.Append("update dt_Actor set ");
            strSql.Append("ActivityId=@ActivityId,");
            strSql.Append("UserName=@UserName,");
            strSql.Append("TureName=@TureName,");
            strSql.Append("UserTel=@UserTel,");

            strSql.Append(" where ProgrammeId=@ProgrammeId");

            SqlParameter[] parameters =
            {
                new SqlParameter("@ActivityId",  SqlDbType.VarChar,  100),
                new SqlParameter("@ProgrammeId", SqlDbType.VarChar,  100),
                new SqlParameter("@UserName",    SqlDbType.NVarChar, 100),
                new SqlParameter("@TureName",    SqlDbType.NVarChar,  50),
                new SqlParameter("@UserTel",     SqlDbType.NVarChar, 50)
            };
            parameters[0].Value = model.ActivityId;
            parameters[1].Value = model.ProgrammeId;
            parameters[2].Value = model.UserName;
            parameters[3].Value = model.TureName;
            parameters[4].Value = model.UserTel;
            int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);

            if (rows > 0)
            {
                return(true);
            }
            else
            {
                return(false);
            }
        }
예제 #4
0
 public bool Update(DtCms.Model.Actor model)
 {
     return(dal.Update(model));
 }
예제 #5
0
 public int Add(DtCms.Model.Actor model)
 {
     return(dal.Add(model));
 }