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