/// <summary> /// 新增CPs信息 /// </summary> /// <param name="entity"></param> /// <returns></returns> public int Insert(CPsEntity entity) { #region CommandText string commandText = @" INSERT INTO CPs ( CPType, IsDeveloper, CPName, FullName, Remarks, CreateTime, UpdateTime, Status ) VALUES ( @CPType, @IsDeveloper, @CPName, @FullName, @Remarks, @CreateTime, @UpdateTime, @Status ); SELECT LAST_INSERT_ID(); "; #endregion List <MySqlParameter> paramsList = this.GetMySqlParameters(entity); int result = MySqlHelper.ExecuteScalar(this.ConnectionString, commandText, paramsList.ToArray()).Convert <int>(); return(result); }
/// <summary> /// 更新开发者数据 /// </summary> /// <param name="currentEntity"></param> /// <returns></returns> public bool Update(CPsEntity currentEntity) { string commandText = @"UPDATE CPs SET CPType = @CPType IsDeveloper = @IsDeveloper CPName = @CPName, FullName = @FullName, Remarks = @Remarks, CreateTime = @CreateTime, UpdateTime = @UpdateTime, Status = @Status WHERE CPID = @CPID;"; List <MySqlParameter> paramsList = new List <MySqlParameter>(); paramsList.Add(new MySqlParameter("@CPID", currentEntity.CPID)); paramsList.Add(new MySqlParameter("@CPType", currentEntity.CPType)); paramsList.Add(new MySqlParameter("@IsDeveloper", currentEntity.IsDeveloper)); paramsList.Add(new MySqlParameter("@CPName", currentEntity.CPName)); paramsList.Add(new MySqlParameter("@FullName", currentEntity.FullName)); paramsList.Add(new MySqlParameter("@Remarks", currentEntity.Remarks)); paramsList.Add(new MySqlParameter("@CreateTime", currentEntity.CreateTime)); paramsList.Add(new MySqlParameter("@UpdateTime", currentEntity.UpdateTime)); paramsList.Add(new MySqlParameter("@Status", currentEntity.Status)); int result = MySqlHelper.ExecuteNonQuery(this.ConnectionString, commandText, paramsList.ToArray()); return(this.ExecuteStatus(result)); }
private bool ExecuteNonQuery(string commandText, CPsEntity entity) { List <MySqlParameter> paramsList = GetMySqlParameters(entity); int result = MySqlHelper.ExecuteNonQuery(this.ConnectionString, commandText, paramsList.ToArray()); return(base.ExecuteStatus(result)); }
private List <MySqlParameter> GetMySqlParameters(CPsEntity entity) { List <MySqlParameter> paramsList = new List <MySqlParameter>(); paramsList.Add(new MySqlParameter("@CPID", entity.CPID)); paramsList.Add(new MySqlParameter("@CPType", entity.CPType)); paramsList.Add(new MySqlParameter("@IsDeveloper", entity.IsDeveloper)); paramsList.Add(new MySqlParameter("@CPName", entity.CPName)); paramsList.Add(new MySqlParameter("@FullName", entity.FullName)); paramsList.Add(new MySqlParameter("@Remarks", entity.Remarks)); paramsList.Add(new MySqlParameter("@CreateTime", DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"))); paramsList.Add(new MySqlParameter("@UpdateTime", DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"))); paramsList.Add(new MySqlParameter("@Status", entity.Status)); return(paramsList); }
/// <summary> /// 更新CPs信息 /// </summary> /// <param name="entity"></param> /// <returns></returns> public bool Update(CPsEntity entity) { #region CommandText string commandText = @"UPDATE CPs SET CPType = @CPType, IsDeveloper = @IsDeveloper, CPName = @CPName, FullName = @FullName, Remarks = @Remarks, UpdateTime = @UpdateTime, Status = @Status WHERE CPID = @CPID ;"; #endregion return(ExecuteNonQuery(commandText, entity)); }
/// <summary> /// 新增信息 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void Button1_Click(object sender, EventArgs e) { CPsEntity entity = new CPsEntity() { CPID = Convert.ToInt32(hidID.Value), CPType = Convert.ToInt32(drpCPType.SelectedValue), IsDeveloper = Convert.ToInt32(drpIsDeveloper.SelectedValue), CPName = txtCpsName.Text, FullName = txtFullName.Text, Status = 1, Remarks = "", CreateTime = DateTime.Now, UpdateTime = DateTime.Now, }; if (Convert.ToInt32(hidID.Value) > 0) { bool rult = new CPsBLL().Update(entity); if (rult) { Response.Redirect("CPsList.aspx"); } else { Response.Write("修改失败"); } } else { int rult = new CPsBLL().Insert(entity); if (rult > 0) { Response.Redirect("CPsList.aspx"); } else { Response.Write("添加失败"); } } }
public bool Insert(CPsEntity currentEntity) { string commandText = @"INSERT INTO CPs ( CPID, CPType, IsDeveloper, FullName, CPName, Remarks, CreateTime, UpdateTime, Status) VALUES (@CPID, @CPType, @IsDeveloper, @FullName, @Remarks, @CreateTime, @UpdateTime, @Status);"; List <MySqlParameter> paramsList = new List <MySqlParameter>(); paramsList.Add(new MySqlParameter("@CPID", currentEntity.CPID)); paramsList.Add(new MySqlParameter("@CPType", currentEntity.CPType)); paramsList.Add(new MySqlParameter("@IsDeveloper", currentEntity.IsDeveloper)); paramsList.Add(new MySqlParameter("@CPName", currentEntity.CPName)); paramsList.Add(new MySqlParameter("@FullName", currentEntity.FullName)); paramsList.Add(new MySqlParameter("@Remarks", currentEntity.Remarks)); paramsList.Add(new MySqlParameter("@CreateTime", currentEntity.CreateTime)); paramsList.Add(new MySqlParameter("@UpdateTime", currentEntity.UpdateTime)); paramsList.Add(new MySqlParameter("@Status", currentEntity.Status)); int result = MySqlHelper.ExecuteNonQuery(this.ConnectionString, commandText, paramsList.ToArray()); return(this.ExecuteStatus(result)); }
/// <summary> /// 更新CPs信息 /// </summary> /// <param name="entity"></param> /// <returns></returns> public bool Update(CPsEntity entity) { return(new CPsDAL().Update(entity)); }
/// <summary> /// 新增CPs信息 /// </summary> /// <param name="entity"></param> /// <returns></returns> public int Insert(CPsEntity entity) { return(new CPsDAL().Insert(entity)); }
/// <summary> /// 更新开发者数据 /// </summary> /// <param name="currentEntity"></param> /// <returns></returns> public bool Update(CPsEntity currentEntity) { return(new B_DevDAL().Update(currentEntity)); }
/// <summary> /// 新增一条开发者信息 /// </summary> /// <param name="currentEntity"></param> /// <returns></returns> public bool Insert(CPsEntity currentEntity) { return(new B_DevDAL().Insert(currentEntity)); }