public bool CreateDictType(DictTypeInfo info) { if (info == null) return false; if (info.Code == "") return false; return _dao.CreateDictType(info); }
/// <summary> /// /// </summary> /// <param name="reader"></param> /// <returns></returns> private DictTypeInfo BuilderDictType(DbDataReader reader) { DictTypeInfo info = new DictTypeInfo(); info.Code = (reader.IsDBNull(reader.GetOrdinal("code"))) ? "" : reader["code"].ToString(); info.Name = (reader.IsDBNull(reader.GetOrdinal("name"))) ? "" : reader["name"].ToString(); return(info); }
/// <summary> /// /// </summary> /// <param name="info"></param> /// <returns></returns> public bool ModifyDictType(DictTypeInfo info) { StringBuilder sql = new StringBuilder(); sql.Append("Update dicttypeinfo "); sql.Append(" Set Name = '" + info.Name + "'"); sql.Append(" Where code = '" + info.Code + "'"); return(DataBaseManage.ExecuteSql(sql.ToString()) > 0); }
public bool CreateDictType(DictTypeInfo info) { StringBuilder sql = new StringBuilder(); sql.Append(" Insert Into dicttypeinfo "); sql.Append(" (code, Name) "); sql.Append(" Values "); sql.Append(" ( "); sql.Append(" '" + info.Code + "',"); sql.Append(" '" + info.Name + "'"); sql.Append(" )"); return DataBaseManage.ExecuteSql(sql.ToString()) > 0; }
public bool CreateDictType(DictTypeInfo info) { if (info == null) { return(false); } if (info.Code == "") { return(false); } return(_dao.CreateDictType(info)); }
public bool CreateDictType(DictTypeInfo info) { StringBuilder sql = new StringBuilder(); sql.Append(" Insert Into dicttypeinfo "); sql.Append(" (code, Name) "); sql.Append(" Values "); sql.Append(" ( "); sql.Append(" '" + info.Code + "',"); sql.Append(" '" + info.Name + "'"); sql.Append(" )"); return(DataBaseManage.ExecuteSql(sql.ToString()) > 0); }
/// <summary> /// /// </summary> /// <param name="Code"></param> /// <returns></returns> public DictTypeInfo GetDictTypeInfo(string Code) { DictTypeInfo info = null; string sql = _SelectSql2 + string.Format(" Where code = '{0}'", Code); using (DbDataReader reader = DataBaseManage.ExecuteReader(sql)) { if (reader.Read()) { info = BuilderDictType(reader); } } return(info); }
/// <summary> /// /// </summary> /// <param name="reader"></param> /// <returns></returns> private DictTypeInfo BuilderDictType(DbDataReader reader) { DictTypeInfo info = new DictTypeInfo(); info.Code = (reader.IsDBNull(reader.GetOrdinal("code"))) ? "" : reader["code"].ToString(); info.Name = (reader.IsDBNull(reader.GetOrdinal("name"))) ? "" : reader["name"].ToString(); return info; }
/// <summary> /// /// </summary> /// <param name="info"></param> /// <returns></returns> public bool ModifyDictType(DictTypeInfo info) { StringBuilder sql = new StringBuilder(); sql.Append("Update dicttypeinfo "); sql.Append(" Set Name = '" + info.Name + "'"); sql.Append(" Where code = '" + info.Code + "'"); return DataBaseManage.ExecuteSql(sql.ToString()) > 0; }
/// <summary> /// /// </summary> /// <param name="info"></param> /// <returns></returns> public bool ModifyDictType(DictTypeInfo info) { if (info == null) return false; if (info.Code == "") return false; return _dao.ModifyDictType(info); }