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