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