/// <summary>
/// 判断代码类别、代码是否已存在-修改去掉本身
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public bool Exists(CodeBaseModel model)
{
StringBuilder builder = new StringBuilder();
builder.Append("SELECT COUNT(1) FROM tbl_CodeBase");
builder.Append(" WHERE Category=@Category");
builder.Append(" AND CodeNo=@CodeNo");
builder.Append(" AND ID<>@ID");
MySqlParameter[] cmdParms = new MySqlParameter[] {
new MySqlParameter("@Category", MySqlDbType.String),
new MySqlParameter("@CodeNo", MySqlDbType.String),
new MySqlParameter("@ID", MySqlDbType.Int32)
};
cmdParms[0].Value = model.Category;
cmdParms[1].Value = model.CodeNo;
cmdParms[2].Value = model.ID;
return(MySQLHelper.Exists(builder.ToString(), cmdParms));
}
public int Insert(CodeBaseModel model)
{
StringBuilder builder = new StringBuilder();
builder.Append("INSERT INTO tbl_CodeBase(");
builder.Append("Category,CodeNo,CodeName,CodeSeq,CodeRemark,CodeValue,CreateBy,CreateDate,UpdateBy,UpdateDate)");
builder.Append(" VALUES (");
builder.Append("@Category,@CodeNo,@CodeName,@CodeSeq,@CodeRemark,@CodeValue,@CreateBy,NOW(),@UpdateBy,NOW())");
builder.Append(";SELECT @@IDENTITY");
MySqlParameter[] cmdParms = new MySqlParameter[] {
new MySqlParameter("@Category", MySqlDbType.String),
new MySqlParameter("@CodeNo", MySqlDbType.String),
new MySqlParameter("@CodeName", MySqlDbType.String),
new MySqlParameter("@CodeSeq", MySqlDbType.Int32),
new MySqlParameter("@CodeRemark", MySqlDbType.String),
new MySqlParameter("@CodeValue", MySqlDbType.Int32),
new MySqlParameter("@CreateBy", MySqlDbType.String),
new MySqlParameter("@UpdateBy", MySqlDbType.String)
};
cmdParms[0].Value = model.Category;
cmdParms[1].Value = model.CodeNo;
cmdParms[2].Value = model.CodeName;
cmdParms[3].Value = model.CodeSeq;
cmdParms[4].Value = model.CodeRemark;
cmdParms[5].Value = model.CodeValue;
cmdParms[6].Value = model.CreateBy;
cmdParms[7].Value = model.UpdateBy;
object single = MySQLHelper.GetSingle(builder.ToString(), cmdParms);
if (single == null)
{
return(0);
}
return(Convert.ToInt32(single));
}
public bool Update(CodeBaseModel model)
{
StringBuilder builder = new StringBuilder();
builder.Append("UPDATE tbl_CodeBase SET ");
builder.Append("Category=@Category,");
builder.Append("CodeNo=@CodeNo,");
builder.Append("CodeName=@CodeName,");
builder.Append("CodeSeq=@CodeSeq,");
builder.Append("CodeRemark=@CodeRemark,");
builder.Append("CodeValue=@CodeValue,");
builder.Append("UpdateBy=@UpdateBy,");
builder.Append("UpdateDate=NOW()");
builder.Append(" WHERE ID=@ID");
MySqlParameter[] cmdParms = new MySqlParameter[] {
new MySqlParameter("@Category", MySqlDbType.String),
new MySqlParameter("@CodeNo", MySqlDbType.String),
new MySqlParameter("@CodeName", MySqlDbType.String),
new MySqlParameter("@CodeSeq", MySqlDbType.Int32),
new MySqlParameter("@CodeRemark", MySqlDbType.String),
new MySqlParameter("@CodeValue", MySqlDbType.Int32),
new MySqlParameter("@UpdateBy", MySqlDbType.String),
new MySqlParameter("@ID", MySqlDbType.Int32)
};
cmdParms[0].Value = model.Category;
cmdParms[1].Value = model.CodeNo;
cmdParms[2].Value = model.CodeName;
cmdParms[3].Value = model.CodeSeq;
cmdParms[4].Value = model.CodeRemark;
cmdParms[5].Value = model.CodeValue;
cmdParms[6].Value = model.UpdateBy;
cmdParms[7].Value = model.ID;
return(MySQLHelper.ExecuteSql(builder.ToString(), cmdParms) > 0);
}
public bool Update(CodeBaseModel model)
{
return(this.dal.Update(model));
}
public int Insert(CodeBaseModel model)
{
return(this.dal.Insert(model));
}
/// <summary>
/// 判断代码类别、代码是否已存在
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public bool Exists(CodeBaseModel model)
{
return(this.dal.Exists(model));
}
