public DataTable GetAllName(AIOSubInfoType subInfoType) { string table = AIOConstant.GetTableName(subInfoType); string column = AIOConstant.GetColumnName(subInfoType); string sql = "SELECT * FROM " + table + " ORDER BY " + column + " ASC"; return(ExecuteSelect(sql)); }
public void UpdateName(string ID, string name, AIOSubInfoType subInfoType) { string table = AIOConstant.GetTableName(subInfoType); string column = AIOConstant.GetColumnName(subInfoType); string sql = "UPDATE " + table + " SET " + column + " = ? WHERE ID = ?"; OleDbCommand cmd = CreateSqlWithParam(sql, new string[] { name, ID }); ExecuteCommand(cmd); }
//SubInfo------------------------------------------------------ public bool IsDuplicateName(string name, AIOSubInfoType subInfoType) { string table = AIOConstant.GetTableName(subInfoType); string column = AIOConstant.GetColumnName(subInfoType); string sql = "SELECT COUNT(*) FROM " + table + " WHERE " + column + " = ?"; OleDbCommand cmd = CreateSqlWithParam(sql, new string[] { name }); cmd.Connection = cn; int num = (int)cmd.ExecuteScalar(); if (num > 0) { return(true); } else { return(false); } }